ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F39E3869E053B46B63588994Y select decode(:P_order_by, 1, rpad(mp.organization_code,3,' ') || we.wip_entity_name, 3, rpad(mp.organization_code,3,' ') || rpad(pp.segment1, 30, ' ') || pt.task_number, NULL) order_by ,mp.organization_code org ,we.wip_entity_name job_name ,mif.item_number assembly ,ml1.meaning status ,ml2.meaning job_type ,wdj.start_quantity start_qty ,wdj.quantity_completed compl_qty ,fnd_date.date_to_displaydate(wdj.scheduled_start_date, 2) job_start_date ,fnd_date.date_to_displaydate(wdj.scheduled_completion_date, 2) job_completion_date ,pp.segment1 project_number ,pt.task_number task_number ,fnd_date.date_to_displaydate(nvl(pt.start_date,pp.start_date), 2) start_date ,fnd_date.date_to_displaydate(nvl(pt.completion_date,pp.completion_date), 2) end_date from wip_discrete_jobs wdj ,wip_entities we ,mfg_lookups ml1 ,mfg_lookups ml2 ,pa_projects_all pp ,pa_tasks pt ,mtl_parameters mp ,mtl_item_flexfields mif where wdj.project_id is not null and wdj.status_type not in (4,5,7,12) and nvl(wdj.start_quantity,0) > nvl(to_number(wdj.quantity_completed),0) and we.wip_entity_id =wdj.wip_entity_id and ml1.lookup_type ='WIP_JOB_STATUS' and ml1.lookup_code =wdj.status_type and ml2.lookup_type ='WIP_DISCRETE_JOB' and ml2.lookup_code =wdj.job_type and pp.project_id =wdj.project_id and &P_project_where and pt.task_id (+) =wdj.task_id and mp.organization_id =wdj.organization_id and mif.organization_id =wdj.organization_id and mif.inventory_item_id =wdj.primary_item_id and &P_item_where and sysdate > nvl(pt.completion_date,nvl(pp.completion_date,sysdate)) and nvl(pt.completion_date,pp.completion_date) &P_date_where order by 1 PJM PJMRPWSE_XML AR PJM تقرير أوامر شغل ما تحت التنفيذ لمشروعات متجاوزة الاستحقاق (بتنسيق XML) Application: تصنيع المشروعات Source: تقرير أوامر شغل ما تحت التنفيذ لمشروعات متجاوزة الاستحقاق (بتنسيق XML) Short Name: PJMRPWSE_XML DB package: PJM_PJMRPWSE_XMLP_PKG D PJM Überfällige Fertigungsaufträge - Projekt Application: Project Manufacturing Source: Überfällige Fertigungsaufträge - Projekt (XML) Short Name: PJMRPWSE_XML DB package: PJM_PJMRPWSE_XMLP_PKG F PJM OF projet en retard Application: Project Manufacturing Source: OF projet en retard (XML) Short Name: PJMRPWSE_XML DB package: PJM_PJMRPWSE_XMLP_PKG US PJM Overdue Project WIP Jobs Application: Project Manufacturing Source: Overdue Project WIP Jobs Report (XML) Short Name: PJMRPWSE_XML DB package: PJM_PJMRPWSE_XMLP_PKG ZHS PJM 逾期项目 WIP 任务报表 Application: 项目制造 Source: 逾期项目 WIP 任务报表 (XML) Short Name: PJMRPWSE_XML DB package: PJM_PJMRPWSE_XMLP_PKG BI Publisher &p_date_where &p_item_where &p_project_where :d_date_from :d_date_from_disp :d_date_to :d_date_to_disp :p_assembly_from :p_assembly_to :p_conc_request_id :p_date_from :p_date_to :p_date_where :p_item_where :p_order_by :p_order_by_disp :p_project_number_from :p_project_number_to :p_project_where 1 10 :p_order_by LOV Oracle PJM_SRS_PWSE_ORDERBY Y select lookup_code id, meaning value, null description from mfg_lookups where lookup_type='PJM_SCHEDEXC_ORDERBY' and lookup_code in (1,3) order by lookup_code SELECT MEANING FROM MFG_LOOKUPS WHERE LOOKUP_TYPE = 'PJM_SCHEDEXC_ORDERBY' AND LOOKUP_CODE = 1 Y AR ترتيب بواسطة D Sortieren nach F Tri par US Order By ZHS 排序依据 2 20 :p_assembly_from Char AR المنتج من D Von Baugruppe F Produit - De US Assembly From ZHS 装配件自 3 30 :p_assembly_to Char AR المنتج إلى D Bis Baugruppe F Produit - A US Assembly To ZHS 装配件至 4 40 :p_project_number_from LOV Oracle PJM_SRS_PROJECT Y Y select project_number id, project_number value, project_name description from pa_projects_all_basic_v where template_flag!='Y' and org_id=(select operating_unit from org_organization_definitions where organization_id=fnd_profile.value('MFG_ORGANIZATION_ID')) order by project_number_sort_order AR رقم المشروع من D Von Projektnummer F Numéro de projet - De US Project Number From ZHS 项目编号自 5 50 :p_project_number_to LOV Oracle PJM_SRS_PROJECT Y Y select project_number id, project_number value, project_name description from pa_projects_all_basic_v where template_flag!='Y' and org_id=(select operating_unit from org_organization_definitions where organization_id=fnd_profile.value('MFG_ORGANIZATION_ID')) order by project_number_sort_order AR رقم المشروع إلى D Bis Projektnummer F Numéro de projet - A US Project Number To ZHS 项目编号至 6 60 :p_date_from Date AR من تاريخ D Datum von F Date de début US Date From ZHS 日期自 7 70 :p_date_to Date AR إلى تاريخ D Bis Datum F Date de fin US Date To ZHS 终止日期