ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F39B3869E053B46B63588994Y select decode(:P_order_by, 7, ph.segment1, 5, rpad(to_char(100000000 - abs(PJM_INTEGRATION_PROJ_MFG.PJM_EXCEPTION_DAYS ( pll.need_by_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 ,ph.segment1||','||to_char(pr.release_num) blanket_release ,PO_HEADERS_SV3.GET_PO_STATUS(ph.po_header_id) status ,mif.item_number item ,hou.name ship_to_location ,pd.quantity_ordered ordered ,pd.quantity_delivered delivered ,fnd_date.date_to_displaydate(pll.promised_date, 2) promised_date ,abs(PJM_INTEGRATION_PROJ_MFG.PJM_EXCEPTION_DAYS (pll.promised_date ,'BETWEEN' ,0 ,pp.start_date ,pp.completion_date ,pt.start_date ,pt.completion_date )) exception_days1 ,fnd_date.date_to_displaydate(pll.need_by_date, 2) need_by_date ,abs(PJM_INTEGRATION_PROJ_MFG.PJM_EXCEPTION_DAYS (pll.need_by_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 po_distributions pd ,po_releases pr ,po_line_locations pll ,po_lines pl ,po_headers ph ,mtl_item_flexfields mif ,pa_projects pp ,pa_tasks pt ,hr_organization_units hou ,financials_system_parameters fsp where pd.project_id is not null and pd.po_release_id is not null and pr.po_release_id =pd.po_release_id and pll.line_location_id =pd.line_location_id and pl.po_line_id =pll.po_line_id and ph.po_header_id =pl.po_header_id and nvl(ph.closed_code,'OPEN') not like '%CLOSED%' and nvl(ph.authorization_status,'N') not in ('CANCELLED','REJECTED') and nvl( pr.closed_code , 'OPEN' ) not like '%CLOSED%' and nvl( pr.authorization_status , 'N' ) not in ( 'CANCELLED' , 'REJECTED' ) and nvl( pr.cancel_flag , 'N' ) <> 'Y' and mif.organization_id =fsp.inventory_organization_id and mif.inventory_item_id =pl.item_id and &P_item_where and pp.project_id =pd.project_id and &P_project_where and pt.task_id (+) =pd.task_id and hou.organization_id =pd.destination_organization_id and (( PJM_INTEGRATION_PROJ_MFG.PJM_EXCEPTION_DAYS(pll.promised_date ,'BETWEEN' ,:P_tolerance_days ,pp.start_date ,pp.completion_date ,pt.start_date ,pt.completion_date ) > 0 and pll.promised_date &P_date_where ) or ( PJM_INTEGRATION_PROJ_MFG.PJM_EXCEPTION_DAYS(pll.need_by_date ,'BETWEEN' ,:P_tolerance_days ,pp.start_date ,pp.completion_date ,pt.start_date ,pt.completion_date ) > 0 and pll.need_by_date &P_date_where )) union all select decode(:P_order_by, 7, ph.segment1, 5, rpad(to_char(100000000 - abs(PJM_INTEGRATION_PROJ_MFG.PJM_EXCEPTION_DAYS ( pll.need_by_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 ,ph.segment1||','||to_char(pr.release_num) blanket_release ,PO_HEADERS_SV3.GET_PO_STATUS(ph.po_header_id) status ,mif.item_number item ,hou.name ship_to_location ,pd.quantity_ordered ordered ,pd.quantity_delivered delivered ,fnd_date.date_to_displaydate(pll.promised_date, 2) promised_date ,abs(PJM_INTEGRATION_PROJ_MFG.PJM_EXCEPTION_DAYS (pll.promised_date ,'BETWEEN' ,0 ,pp.start_date ,pp.completion_date ,pt.start_date ,pt.completion_date )) exception_days1 ,fnd_date.date_to_displaydate(pll.need_by_date, 2) need_by_date ,abs(PJM_INTEGRATION_PROJ_MFG.PJM_EXCEPTION_DAYS (pll.need_by_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 po_distributions_all pd ,po_releases_all pr ,po_line_locations_all pll ,po_lines_all pl ,po_headers_all ph ,mtl_item_flexfields mif ,pa_projects_all pp ,pa_tasks pt ,hr_organization_units hou ,financials_system_params_all fsp where pd.project_id is not null and pd.po_release_id is not null and pr.po_release_id =pd.po_release_id and pll.line_location_id =pd.line_location_id and pl.po_line_id =pll.po_line_id and ph.po_header_id =pl.po_header_id and nvl(ph.closed_code,'OPEN') not like '%CLOSED%' and nvl(ph.authorization_status,'N') not in ('CANCELLED','REJECTED') and nvl( pr.closed_code , 'OPEN' ) not like '%CLOSED%' and nvl( pr.authorization_status , 'N' ) not in ( 'CANCELLED' , 'REJECTED' ) and nvl( pr.cancel_flag , 'N' ) <> 'Y' and mif.organization_id =fsp.inventory_organization_id and fsp.org_id = ph.org_id and mif.inventory_item_id =pl.item_id and &P_item_where and pp.project_id =pd.project_id and &P_project_where and pt.task_id (+) =pd.task_id and hou.organization_id =pd.destination_organization_id and (( PJM_INTEGRATION_PROJ_MFG.PJM_EXCEPTION_DAYS(pll.promised_date ,'BETWEEN' ,:P_tolerance_days ,pp.start_date ,pp.completion_date ,pt.start_date ,pt.completion_date ) < 0 and pll.promised_date &P_date_where ) or ( PJM_INTEGRATION_PROJ_MFG.PJM_EXCEPTION_DAYS(pll.need_by_date ,'BETWEEN' ,:P_tolerance_days ,pp.start_date ,pp.completion_date ,pt.start_date ,pt.completion_date ) < 0 and pll.need_by_date &P_date_where )) order by 1 PJM PJMRPSEP_XML AR PJM تقرير استثناء جدول المشروع - أنشطة الشراء (بتنسيق XML) Application: تصنيع المشروعات Source: تقرير استثناء جدول المشروع - أنشطة الشراء (بتنسيق XML) Short Name: PJMRPSEP_XML DB package: PJM_PJMRPSEP_XMLP_PKG D PJM Projektplanungsausnahmen - Beschaffungsaktivitäten Application: Project Manufacturing Source: Projektplanungsausnahmen - Beschaffungsaktivitäten (XML) Short Name: PJMRPSEP_XML DB package: PJM_PJMRPSEP_XMLP_PKG F PJM Etat de notification d'exceptions de planification de projet - Activités d'achat Application: Project Manufacturing Source: Etat de notification d'exceptions de planification de projet - Activités d'achat (XML) Short Name: PJMRPSEP_XML DB package: PJM_PJMRPSEP_XMLP_PKG US PJM Project Schedule Exception Report - Procurement Activities Application: Project Manufacturing Source: Project Schedule Exception Report - Procurement Activities (XML) Short Name: PJMRPSEP_XML DB package: PJM_PJMRPSEP_XMLP_PKG ZHS PJM 项目计划例外报表 - 采购活动 Application: 项目制造 Source: 项目计划例外报表 - 采购活动 (XML) Short Name: PJMRPSEP_XML DB package: PJM_PJMRPSEP_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 :lp_order_by_disp :p_conc_request_id :p_date_from :p_date_to :p_date_where :p_item_from :p_item_to :p_item_where :p_order_by :p_order_by_disp :p_project_number_from :p_project_number_to :p_project_where :p_prt_po :p_prt_pr :p_prt_qtn :p_prt_rel :p_prt_rfq :p_tolerance_days 1 10 :p_order_by LOV Oracle PJM_SRS_PSEP_ORDERBY Y select lookup_code id, meaning value, null description from mfg_lookups where lookup_type='PJM_SCHEDEXC_ORDERBY' and lookup_code in (7,5,6) order by lookup_code SELECT MEANING FROM MFG_LOOKUPS WHERE LOOKUP_TYPE = 'PJM_SCHEDEXC_ORDERBY' AND LOOKUP_CODE = 7 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_prt_po LOV Oracle Yes_No Y select lookup_code id, meaning value, null description from fnd_lookups where fnd_lookups.lookup_type='YES_NO' order by value,description SELECT MEANING FROM FND_LOOKUPS WHERE LOOKUP_TYPE = 'YES_NO' AND LOOKUP_CODE = 'Y' Y AR تضمين أوامر الشراء D Mit Bestellungen F Inclure les commandes US Include Purchase Orders ZHS 包括采购订单 4 40 :p_prt_rel LOV Oracle Yes_No Y select lookup_code id, meaning value, null description from fnd_lookups where fnd_lookups.lookup_type='YES_NO' order by value,description SELECT MEANING FROM FND_LOOKUPS WHERE LOOKUP_TYPE = 'YES_NO' AND LOOKUP_CODE = 'N' Y AR تضمين إصدارات عامة D Mit Rahmenvertragsabrufen F Inclure les appels de commandes ouvertes US Include Blanket Releases ZHS 包括一揽子发放 5 50 :p_prt_pr LOV Oracle Yes_No Y select lookup_code id, meaning value, null description from fnd_lookups where fnd_lookups.lookup_type='YES_NO' order by value,description SELECT MEANING FROM FND_LOOKUPS WHERE LOOKUP_TYPE = 'YES_NO' AND LOOKUP_CODE = 'N' Y AR تضمين توريدات الشراء D Mit Bestellanforderungen F Inclure les demandes d'achat US Include Purchase Requisitions ZHS 包括采购申请 6 60 :p_prt_rfq LOV Oracle Yes_No Y select lookup_code id, meaning value, null description from fnd_lookups where fnd_lookups.lookup_type='YES_NO' order by value,description SELECT MEANING FROM FND_LOOKUPS WHERE LOOKUP_TYPE = 'YES_NO' AND LOOKUP_CODE = 'N' Y AR تضمين طلب عروض الأسعار D Mit Angebotsanfragen F Inclure les appels d'offres US Include Request For Quotations ZHS 包括报价请求 7 70 :p_prt_qtn LOV Oracle Yes_No Y select lookup_code id, meaning value, null description from fnd_lookups where fnd_lookups.lookup_type='YES_NO' order by value,description SELECT MEANING FROM FND_LOOKUPS WHERE LOOKUP_TYPE = 'YES_NO' AND LOOKUP_CODE = 'N' Y AR تضمين عروض الأسعار D Mit Angeboten F Inclure les propositions de prix US Include Quotations ZHS 包括报价单 8 80 :p_item_from Char AR الصنف من D Von Artikel F Article - De US Item From ZHS 物料自 9 90 :p_item_to Char AR الصنف إلى D Bis Artikel F Article - A US Item To ZHS 物料至 10 100 :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 项目编号自 11 110 :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 项目编号至 12 120 :p_date_from Date AR من تاريخ D Datum von F Date de début US Date From ZHS 日期自 13 130 :p_date_to Date AR إلى تاريخ D Bis Datum F Date de fin US Date To ZHS 终止日期