ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F39C3869E053B46B63588994Y select decode(:P_order_by, 4, to_char(ooh.order_number), 5, rpad(to_char(100000000 - abs(PJM_INTEGRATION_PROJ_MFG.PJM_EXCEPTION_DAYS ( ool.promise_date , 'BETWEEN' , 0 , pp.start_date , pp.completion_date , pt.start_date , pt.completion_date ) ) ),100,'0'), 6, rpad(pp.segment1, 30, ' ') || pt.task_number, NULL) order_by , 1 report_type , ooh.order_number so_number , mif.item_number item , hou.name warehouse , nvl(ool.ordered_quantity,0) ordered_qty , fnd_date.date_to_displaydate(ool.request_date, 2) requested_date , abs(PJM_INTEGRATION_PROJ_MFG.PJM_EXCEPTION_DAYS ( ool.request_date , 'BETWEEN' , 0 , pp.start_date , pp.completion_date , pt.start_date , pt.completion_date )) exception_days1 , fnd_date.date_to_displaydate(ool.promise_date, 2) promise_date , abs(PJM_INTEGRATION_PROJ_MFG.PJM_EXCEPTION_DAYS ( ool.promise_date , 'BETWEEN' , 0 , pp.start_date , pp.completion_date , pt.start_date , pt.completion_date )) exception_days2 , 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 oe_order_lines ool , hr_organization_units hou , oe_order_headers ooh , mtl_item_flexfields mif , pa_projects pp , pa_tasks pt where ool.project_id is not null and nvl(ool.cancelled_flag,'N') <> 'Y' and nvl(ool.open_flag,'Y') <> 'N' and ooh.header_id = ool.header_id and hou.organization_id = ool.ship_from_org_id and mif.organization_id = ool.ship_from_org_id and mif.inventory_item_id = ool.inventory_item_id and &P_item_where and pp.project_id = ool.project_id and &P_project_where and pt.task_id (+) = ool.task_id and (( PJM_INTEGRATION_PROJ_MFG.PJM_EXCEPTION_DAYS ( ool.request_date , 'BETWEEN' , :P_tolerance_days , pp.start_date , pp.completion_date , pt.start_date , pt.completion_date ) > 0 and ool.request_date &P_date_where ) or ( PJM_INTEGRATION_PROJ_MFG.PJM_EXCEPTION_DAYS ( ool.promise_date , 'BETWEEN' , :P_tolerance_days , pp.start_date , pp.completion_date , pt.start_date , pt.completion_date ) > 0 and ool.promise_date &P_date_where )) union all select decode(:P_order_by, 4, to_char(ooh.order_number), 5, rpad(to_char(100000000 - abs(PJM_INTEGRATION_PROJ_MFG.PJM_EXCEPTION_DAYS ( ool.promise_date , 'BETWEEN' , 0 , pp.start_date , pp.completion_date , pt.start_date , pt.completion_date ) ) ),100,'0'), 6, rpad(pp.segment1, 30, ' ') || pt.task_number, NULL) order_by , 2 report_type , ooh.order_number so_number , mif.item_number item , hou.name warehouse , nvl(ool.ordered_quantity,0) ordered_qty , fnd_date.date_to_displaydate(ool.request_date, 2) requested_date , abs(PJM_INTEGRATION_PROJ_MFG.PJM_EXCEPTION_DAYS ( ool.request_date , 'BETWEEN' , 0 , pp.start_date , pp.completion_date , pt.start_date , pt.completion_date )) exception_days1 , fnd_date.date_to_displaydate(ool.promise_date, 2) promise_date , abs(PJM_INTEGRATION_PROJ_MFG.PJM_EXCEPTION_DAYS ( ool.promise_date , 'BETWEEN' , 0 , pp.start_date , pp.completion_date , pt.start_date , pt.completion_date )) exception_days2 , 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 oe_order_lines_all ool , hr_organization_units hou , oe_order_headers_all ooh , mtl_item_flexfields mif , pa_projects_all pp , pa_tasks pt where ool.project_id is not null and nvl(ool.cancelled_flag,'N') <> 'Y' and nvl(ool.open_flag,'Y') <> 'N' and ooh.header_id = ool.header_id and hou.organization_id = ool.ship_from_org_id and mif.organization_id = ool.ship_from_org_id and mif.inventory_item_id = ool.inventory_item_id and &P_item_where and pp.project_id = ool.project_id and &P_project_where and pt.task_id (+) = ool.task_id and (( PJM_INTEGRATION_PROJ_MFG.PJM_EXCEPTION_DAYS ( ool.request_date , 'BETWEEN' , :P_tolerance_days , pp.start_date , pp.completion_date , pt.start_date , pt.completion_date ) < 0 and ool.request_date &P_date_where ) or ( PJM_INTEGRATION_PROJ_MFG.PJM_EXCEPTION_DAYS ( ool.promise_date , 'BETWEEN' , :P_tolerance_days , pp.start_date , pp.completion_date , pt.start_date , pt.completion_date ) < 0 and ool.promise_date &P_date_where )) order by 2,1 PJM PJMRPSES_XML AR PJM تقرير استثناء جدول المشروع - أوامر المبيعات (بتنسيق XML) Application: تصنيع المشروعات Source: تقرير استثناء جدول المشروع - أوامر المبيعات (بتنسيق XML) Short Name: PJMRPSES_XML DB package: PJM_PJMRPSES_XMLP_PKG D PJM Projektplanungsausnahmen - Kundenaufträge Application: Project Manufacturing Source: Projektplanungsausnahmen - Kundenaufträge (XML) Short Name: PJMRPSES_XML DB package: PJM_PJMRPSES_XMLP_PKG F PJM Etat de notification d'exceptions de planification de projet - Commandes client Application: Project Manufacturing Source: Etat de notification d'exceptions de planification de projet - Commandes client (XML) Short Name: PJMRPSES_XML DB package: PJM_PJMRPSES_XMLP_PKG US PJM Project Schedule Exception Report - Sales Orders Application: Project Manufacturing Source: Project Schedule Exception Report - Sales Orders (XML) Short Name: PJMRPSES_XML DB package: PJM_PJMRPSES_XMLP_PKG ZHS PJM 项目计划例外报表 - 销售订单 Application: 项目制造 Source: 项目计划例外报表 - 销售订单 (XML) Short Name: PJMRPSES_XML DB package: PJM_PJMRPSES_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_conc_request_id :p_date_from :p_date_to :p_date_where :p_item_from :p_item_to :p_item_where :p_oe_or_ont :p_order_by :p_order_by_disp :p_project_number_from :p_project_number_to :p_project_where :p_tolerance_days 1 10 :p_order_by LOV Oracle PJM_SRS_PSES_ORDERBY Y select lookup_code id, meaning value, null description from mfg_lookups where lookup_type='PJM_SCHEDEXC_ORDERBY' and lookup_code in (4,5,6) order by lookup_code SELECT MEANING FROM MFG_LOOKUPS WHERE LOOKUP_TYPE = 'PJM_SCHEDEXC_ORDERBY' AND LOOKUP_CODE = 4 Y AR ترتيب بواسطة D Sortieren nach F Tri par US Order By ZHS 排序依据 2 20 :p_tolerance_days Number 0 Y AR أيام التجاوز D Toleranz (Tage) F Jours de tolérance US Tolerance Days ZHS 允差天数 3 30 :p_item_from Char AR الصنف من D Von Artikel F Article - De US Item From ZHS 物料自 4 40 :p_item_to Char AR الصنف إلى D Bis Artikel F Article - A US Item To ZHS 物料至 5 50 :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 项目编号自 6 60 :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 项目编号至 7 70 :p_date_from Date AR من تاريخ D Datum von F Date de début US Date From ZHS 日期自 8 80 :p_date_to Date AR إلى تاريخ D Bis Datum F Date de fin US Date To ZHS 终止日期