ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 8E2FF36EDEB979D2E0530100007F1FF2 HR Operating Unit Y select hou.name value, null description from hr_operating_units hou where sysdate between hou.date_from and nvl(hou.date_to,sysdate) and (:$flex$.ledger is null or hou.set_of_books_id in (select gl.ledger_id from gl_ledgers gl where xxen_util.contains(:$flex$.ledger,gl.name)='Y')) and hou.organization_id in (select mgoat.organization_id from mo_glob_org_access_tmp mgoat union select fnd_global.org_id from dual where fnd_release.major_version=11) order by hou.name Fixed where clause duplication AR وحدة التشغيل مقيدة بالتحكم في الوصول متعدد المنظمات (MOAC) D Bedieneinheit eingeschränkt durch Multi Org Access Control (MOAC) E Unidad operativa restringida por el control de acceso multiorgánico (MOAC) F Unité opérationnelle restreinte par un contrôle d'accès multi-organismes (MOAC) I Unità operativa limitata dal controllo di accesso multiorgano (MOAC) JA 多機関アクセス制御(MOAC)で制限された操作ユニット KO 다중 조직 액세스 제어 (MOAC)에 의해 제한되는 운영 단위 PTB Unidade operacional restrita por controle de acesso multi org (MOAC) RU Операционное устройство, ограниченное мультиорганизованным контролем доступа (MOAC) S Styrenhet begränsad av multi-org access control (MOAC) TR Çoklu kuruluş erişim kontrolü (MOAC) tarafından kısıtlanan işletim birimi US Operating unit restricted by multi org access control (MOAC) ZHS 受多机构访问控制（MOAC）限制的操作单元。 41D6D8409707CF99E06362FB0905AA49Y SELECT poh.segment1 PO_Number_Release , pov.vendor_name Vendor , pvs.vendor_site_code Vendor_Site , poh.creation_date Creation_Date , poh.currency_code C_CURRENCY , sum(nvl(pll.quantity,0) * nvl(pll.price_override,0)) C_AMOUNT , papf2.full_name Buyer , pah.action_date Cancelled_Date , papf.full_name Cancelled_By , pah.note Reason , decode(psp.manual_po_num_type,'NUMERIC', null,poh.segment1) , decode(psp.manual_po_num_type,'NUMERIC', to_number(poh.segment1), null) FROM po_line_locations pll , ap_supplier_sites pvs , po_vendors pov , po_action_history pah , po_headers poh , PER_ALL_PEOPLE_F PAPF , PER_ALL_PEOPLE_F PAPF2 , po_system_parameters psp WHERE poh.cancel_flag = 'Y' AND poh.po_header_id = pll.po_header_id (+) AND pov.vendor_id = poh.vendor_id AND pvs.vendor_site_id = poh.vendor_site_id AND (pah.object_revision_num,pah.sequence_num) = (Select max(object_revision_num),max(sequence_num) From po_action_history Where object_type_code in ('PO','PA') And action_code in ('CANCEL','MASSCANCEL','RELEASE_MASSCANCEL') And poh.po_header_id = po_action_history.object_id AND trunc(action_date) BETWEEN nvl(:P_cancelled_date_from,trunc(action_date)) AND nvl(:P_cancelled_date_to,trunc(action_date)) ) AND pah.object_id = poh.po_header_id AND pah.object_type_code in ('PO','PA') AND pah.action_code in ( 'CANCEL','MASSCANCEL','RELEASE_MASSCANCEL') AND trunc(pah.action_date) BETWEEN nvl(:P_cancelled_date_from,trunc(pah.action_date)) AND nvl(:P_cancelled_date_to,trunc(pah.action_date)) AND papf.person_id(+) = pah.employee_id AND pov.vendor_name >= decode(:P_Vendor_Name_From,'', pov.vendor_name,:P_Vendor_Name_From) AND pov.vendor_name <= decode(:P_Vendor_Name_To,'', pov.vendor_name,:P_Vendor_Name_To) AND papf2.person_id(+) = poh.agent_id /* AND nvl(papf2.full_name,'A') = decode(:P_Buyer,'',nvl(papf2.full_name,'A'), :P_Buyer) */ /*Bug#2453022 Commented out the above condition and replaced it as follows as the user parameter P_Buyer will now return the id and not the name */ AND nvl(papf2.person_id,-9999) = decode(:P_Buyer,'',nvl(papf2.person_id,-9999), :P_Buyer) /* Bug5122407 - Modified shipment_type condition */ AND pll.po_release_id(+) is null AND ( pll.shipment_type in ('STANDARD','PLANNED') OR poh.type_lookup_code='BLANKET') and PAPF.EMPLOYEE_NUMBER (+) IS NOT NULL AND TRUNC(SYSDATE) BETWEEN PAPF.EFFECTIVE_START_DATE (+)AND PAPF.EFFECTIVE_END_DATE(+) AND DECODE(HR_SECURITY.VIEW_ALL ,'Y' , 'TRUE', HR_SECURITY.SHOW_RECORD('PER_ALL_PEOPLE_F',PAPF.PERSON_ID(+), PAPF.PERSON_TYPE_ID(+), PAPF.EMPLOYEE_NUMBER(+),PAPF.APPLICANT_NUMBER (+))) = 'TRUE' AND DECODE(HR_GENERAL.GET_XBG_PROFILE,'Y', PAPF.BUSINESS_GROUP_ID(+) , HR_GENERAL.GET_BUSINESS_GROUP_ID) = PAPF.BUSINESS_GROUP_ID(+) and PAPF2.EMPLOYEE_NUMBER(+) IS NOT NULL AND TRUNC(SYSDATE) BETWEEN PAPF2.EFFECTIVE_START_DATE (+) AND PAPF2.EFFECTIVE_END_DATE (+) AND DECODE(HR_SECURITY.VIEW_ALL ,'Y' , 'TRUE', HR_SECURITY.SHOW_RECORD('PER_ALL_PEOPLE_F',PAPF2.PERSON_ID(+), PAPF2.PERSON_TYPE_ID(+), PAPF2.EMPLOYEE_NUMBER(+),PAPF2.APPLICANT_NUMBER (+))) = 'TRUE' AND DECODE(HR_GENERAL.GET_XBG_PROFILE,'Y', PAPF2.BUSINESS_GROUP_ID(+) , HR_GENERAL.GET_BUSINESS_GROUP_ID) = PAPF2.BUSINESS_GROUP_ID(+) GROUP BY poh.segment1 , pov.vendor_name , pvs.vendor_site_code , poh.currency_code , poh.creation_date , pah.action_date , papf.full_name , papf2.full_name , pah.note , decode(psp.manual_po_num_type,'NUMERIC', null,poh.segment1) , decode(psp.manual_po_num_type,'NUMERIC', to_number(poh.segment1), null) /*ORDER BY decode(psp.manual_po_num_type,'NUMERIC', null,poh.segment1) , decode(psp.manual_po_num_type,'NUMERIC', to_number(poh.segment1), null) */ UNION SELECT poh.segment1 || '-' || por.release_num PO_Number_Release , pov.vendor_name Vendor , pvs.vendor_site_code Vendor_Site , poh.creation_date Creation_Date , poh.currency_code C_CURRENCY , SUM (DECODE (POL.order_type_lookup_code, 'RATE', PLL.amount, 'FIXED PRICE', PLL.amount, NVL(PLL.quantity, 0) * NVL(PLL.price_override, 0))) C_AMOUNT /* <SERVICES FPJ> */ , papf2.full_name Buyer , pah.action_date Cancelled_Date , papf.full_name Cancelled_By , pah.note Reason , decode(psp.manual_po_num_type,'NUMERIC', null,poh.segment1) , decode(psp.manual_po_num_type,'NUMERIC', to_number(poh.segment1), null) FROM po_line_locations pll , po_releases por , ap_supplier_sites pvs , po_vendors pov , po_action_history pah , po_headers poh , po_lines POL /* <SERVICES FPJ> */ , PER_ALL_PEOPLE_F PAPF , PER_ALL_PEOPLE_F PAPF2 , po_system_parameters psp WHERE por.cancel_flag = 'Y' AND pll.po_release_id = por.po_release_id AND POH.po_header_id = POL.po_header_id /* <SERVICES FPJ> */ AND POL.po_line_id = PLL.po_line_id (+) /* <SERVICES FPJ> */ AND pov.vendor_id = poh.vendor_id AND pvs.vendor_site_id = poh.vendor_site_id AND (pah.object_revision_num,pah.sequence_num) = (Select max(object_revision_num),max(sequence_num) From po_action_history Where object_type_code in ('RELEASE') And action_code in ('CANCEL','MASSCANCEL','RELEASE_MASSCANCEL') And por.po_release_id = po_action_history.object_id AND trunc(action_date) BETWEEN nvl(:P_cancelled_date_from,trunc(action_date)) AND nvl(:P_cancelled_date_to,trunc(action_date)) ) AND pah.object_id = por.po_release_id AND pah.object_type_code in ('RELEASE') AND pah.action_code in ( 'CANCEL','MASSCANCEL','RELEASE_MASSCANCEL') AND trunc(pah.action_date) BETWEEN nvl(:P_cancelled_date_from,trunc(pah.action_date)) AND nvl(:P_cancelled_date_to,trunc(pah.action_date)) AND papf.person_id(+) = pah.employee_id AND pov.vendor_name >= decode(:P_Vendor_Name_From,'', pov.vendor_name,:P_Vendor_Name_From) AND pov.vendor_name <= decode(:P_Vendor_Name_To,'', pov.vendor_name,:P_Vendor_Name_To) AND papf2.person_id(+) = por.agent_id /* AND nvl(papf2.full_name,'A') = decode(:P_Buyer,'',nvl(papf2.full_name,'A'), :P_Buyer) */ /*Bug#2453022 Commented out the above condition and replaced it as follows as the user parameter P_Buyer will now return the id and not the name */ AND nvl(papf2.person_id,-9999) = decode(:P_Buyer,'',nvl(papf2.person_id,-9999), :P_Buyer) AND pll.shipment_type in ('BLANKET','SCHEDULED') /* and PAPF.EMPLOYEE_NUMBER (+) IS NOT NULL*/ /*<R12 CWK>*/ AND TRUNC(SYSDATE) BETWEEN PAPF.EFFECTIVE_START_DATE (+)AND PAPF.EFFECTIVE_END_DATE(+) AND DECODE(HR_SECURITY.VIEW_ALL ,'Y' , 'TRUE', HR_SECURITY.SHOW_RECORD('PER_ALL_PEOPLE_F',PAPF.PERSON_ID(+), PAPF.PERSON_TYPE_ID(+), PAPF.EMPLOYEE_NUMBER(+),PAPF.APPLICANT_NUMBER (+) ,PAPF.NPW_NUMBER(+) )) = 'TRUE' /* <R12 CWK>*/ AND DECODE(HR_GENERAL.GET_XBG_PROFILE,'Y', PAPF.BUSINESS_GROUP_ID(+) , HR_GENERAL.GET_BUSINESS_GROUP_ID) = PAPF.BUSINESS_GROUP_ID(+) /* and PAPF2.EMPLOYEE_NUMBER(+) IS NOT NULL*/ /*<R12 CWK>*/ AND TRUNC(SYSDATE) BETWEEN PAPF2.EFFECTIVE_START_DATE (+) AND PAPF2.EFFECTIVE_END_DATE (+) AND DECODE(HR_SECURITY.VIEW_ALL ,'Y' , 'TRUE', HR_SECURITY.SHOW_RECORD('PER_ALL_PEOPLE_F',PAPF2.PERSON_ID(+), PAPF2.PERSON_TYPE_ID(+), PAPF2.EMPLOYEE_NUMBER(+),PAPF2.APPLICANT_NUMBER (+) ,PAPF2.NPW_NUMBER(+) )) = 'TRUE' /*<R12 CWK>*/ AND DECODE(HR_GENERAL.GET_XBG_PROFILE,'Y', PAPF2.BUSINESS_GROUP_ID(+) , HR_GENERAL.GET_BUSINESS_GROUP_ID) = PAPF2.BUSINESS_GROUP_ID(+) GROUP BY poh.segment1 || '-' || por.release_num , pov.vendor_name , pvs.vendor_site_code , poh.currency_code , poh.creation_date , pah.action_date , papf.full_name , papf2.full_name , pah.note , decode(psp.manual_po_num_type,'NUMERIC', null,poh.segment1) , decode(psp.manual_po_num_type,'NUMERIC', to_number(poh.segment1), null) , por.release_num /* ORDER BY decode(psp.manual_po_num_type,'NUMERIC', null,poh.segment1) , decode(psp.manual_po_num_type,'NUMERIC', to_number(poh.segment1), null) */ ORDER BY 11,12 PO POXPOCAN_XML AR PO تقرير أوامر الشراء الملغاة (بتنسيق XML) (1) Imported from BI Publisher Description: تقرير أوامر الشراء الملغاة Application: المشتريات Source: تقرير أوامر الشراء الملغاة (بتنسيق XML) Short Name: POXPOCAN_XML DB package: PO_POXPOCAN_XMLP_PKG D PO Bestellungen - storniert (1) Imported from BI Publisher Description: Bestellungen - storniert Application: Einkauf Source: Bestellungen - storniert (XML) Short Name: POXPOCAN_XML DB package: PO_POXPOCAN_XMLP_PKG E PO Informe Pedidos Cancelados Imported from BI Publisher Description: Pedidos Cancelados Application: Purchasing Source: Informe Pedidos Cancelados (XML) Short Name: POXPOCAN_XML DB package: PO_POXPOCAN_XMLP_PKG F PO Etat des commandes annulées (1) Imported from BI Publisher Description: Etat des commandes annulées Application: Purchasing Source: Etat des commandes annulées (XML) Short Name: POXPOCAN_XML DB package: PO_POXPOCAN_XMLP_PKG I PO Rapporto Ordini di acquisto annullati Imported from BI Publisher Description: Rapporto Ordini di acquisto annullati Application: Purchasing Source: Rapporto Ordini di acquisto annullati (XML) Short Name: POXPOCAN_XML DB package: PO_POXPOCAN_XMLP_PKG JA PO 取消済発注レポート Imported from BI Publisher Description: 取消済発注レポート Application: Purchasing Source: 取消済発注レポート(XML) Short Name: POXPOCAN_XML DB package: PO_POXPOCAN_XMLP_PKG KO PO 취소된 구매 발주 보고서 Imported from BI Publisher Description: 취소된 구매발주 보고서 Application: Purchasing Source: 취소된 구매 발주 보고서(XML) Short Name: POXPOCAN_XML DB package: PO_POXPOCAN_XMLP_PKG PTB PO Relatório de Ordens de Compra Canceladas Imported from BI Publisher Description: Relatório de Ordens de Compra Canceladas Application: Compra Source: Relatório de Ordens de Compra Canceladas (XML) Short Name: POXPOCAN_XML DB package: PO_POXPOCAN_XMLP_PKG RU PO Отчет об отмененных заказах на приобретение Imported from BI Publisher Description: Отчет об отмененных заказах на приобретение Application: Закупки Source: Отчет об отмененных заказах на приобретение (XML) Short Name: POXPOCAN_XML DB package: PO_POXPOCAN_XMLP_PKG S PO Annullerade inköpsorder - rapport Imported from BI Publisher Description: Annullerade inköpsorder - rapport Application: Purchasing Source: Annullerade inköpsorder - rapport (XML) Short Name: POXPOCAN_XML DB package: PO_POXPOCAN_XMLP_PKG TR PO İptal Edilen Satın Alma Siparişleri Raporu Imported from BI Publisher Description: İptal Edilen Satın Alma Siparişleri Raporu Application: Satın Alma Yönetimi Source: İptal Edilen Satın Alma Siparişleri Raporu (XML) Short Name: POXPOCAN_XML DB package: PO_POXPOCAN_XMLP_PKG US PO Cancelled Purchase Orders (1) Imported from BI Publisher Description: Cancelled Purchase Orders Report Application: Purchasing Source: Cancelled Purchase Orders Report (XML) Short Name: POXPOCAN_XML DB package: PO_POXPOCAN_XMLP_PKG ZHS PO 取消的采购订单报表 (1) Imported from BI Publisher Description: 取消的采购订单报表 Application: 采购管理系统 Source: 取消的采购订单报表 (XML) Short Name: POXPOCAN_XML DB package: PO_POXPOCAN_XMLP_PKG BI Publisher 1=1 :operating_unit :p_buyer :p_cancelled_date_from :p_cancelled_date_to :p_conc_request_id :p_title :p_vendor_name_from :p_vendor_name_to 1 -10 :debugflag Char N US DebugFlag Debug Flag 2 0 :operating_unit LOV HR Operating Unit 8E2FF36EDEB979D2E0530100007F1FF2 Y select hou.name value, null description from hr_operating_units hou where sysdate between hou.date_from and nvl(hou.date_to,sysdate) and (:$flex$.ledger is null or hou.set_of_books_id in (select gl.ledger_id from gl_ledgers gl where xxen_util.contains(:$flex$.ledger,gl.name)='Y')) and hou.organization_id in (select mgoat.organization_id from mo_glob_org_access_tmp mgoat union select fnd_global.org_id from dual where fnd_release.major_version=11) order by hou.name select haouv.name from hr_all_organization_units_vl haouv where haouv.organization_id=nvl((select mgoat.organization_id from mo_glob_org_access_tmp mgoat where mgoat.organization_id=nvl(fnd_profile.value('DEFAULT_ORG_ID'),mgoat.organization_id) and rownum=1),fnd_global.org_id) Y US Operating Unit Required Operating Unit restriction for reports working in single operating unit mode only 3 10 :p_title Char US Title Title 4 20 :p_vendor_name_from LOV Oracle PO_SRS_VENDOR_NAME Y Y select vendor_name id, vendor_name value, null description from po_vendors order by vendor_name US Vendors From Vendor Names From 5 30 :p_vendor_name_to LOV Oracle PO_SRS_VENDOR_NAME Y Y select vendor_name id, vendor_name value, null description from po_vendors order by vendor_name US To To 6 40 :p_buyer LOV Oracle PO_SRS_BUYER_NAME_NUM Y select buyer_id id, buyer_info value, null description from po_buyer_name_num_v order by buyer_info US Buyer Name Buyer Name 7 50 :p_cancelled_date_from Date US Cancelled Dates From Cancelled Dates From 8 60 :p_cancelled_date_to Date US To 2 To