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）限制的操作单元。 82288223F3C03869E053B46B63588994 select x.operating_unit, x.po_number, x.release_number, x.order_type, x.vendor, x.vendor_site, x.order_date, x.created_by, x.order_amount, x.currency, x.buyer, x.cancelled_date, x.cancelled_by, x.reason -- line &lp_line_cols from ( select mgoat.organization_name operating_unit, poh.segment1 po_number, null release_number, flvv.description order_type, pov.vendor_name vendor, pvs.vendor_site_code vendor_site, trunc(poh.creation_date) order_date, nvl(papf3.full_name,fu.user_name || ' (' || fu.description || ')') created_by, poh.currency_code currency, sum(nvl(pll.quantity,0) * nvl(pll.price_override,0)) over (partition by poh.po_header_id) order_amount, papf2.full_name buyer, trunc(pah.action_date) cancelled_date, papf.full_name cancelled_by, pah.note reason, -- &lp_line_po_cols -- decode(psp.manual_po_num_type,'NUMERIC', null,poh.segment1) ord_sort_1, decode(psp.manual_po_num_type,'NUMERIC', to_number(poh.segment1), null) ord_sort_2 from po_headers_all poh, po_action_history pah, po_vendors pov, ap_supplier_sites_all pvs, fnd_user fu, per_all_people_f papf, per_all_people_f papf2, per_all_people_f papf3, po_system_parameters_all psp, mo_glob_org_access_tmp mgoat, fnd_lookup_values_vl flvv, -- financials_system_params_all fspa, po_lines_all pol, po_line_locations_all pll, mtl_categories_kfv mc, mtl_system_items_vl msi where 1=1 and 2=2 and poh.cancel_flag = 'Y' and poh.org_id = psp.org_id and poh.org_id = fspa.org_id and poh.org_id = mgoat.organization_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(pah2.object_revision_num), max(pah2.sequence_num) from po_action_history pah2 where 4=4 and pah2.object_type_code in ('PO','PA') and pah2.action_code in ('CANCEL','MASSCANCEL','RELEASE_MASSCANCEL') and poh.po_header_id = pah2.object_id ) 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 papf.person_id(+) = pah.employee_id and papf2.person_id(+) = poh.agent_id and fu.user_id = poh.created_by and papf3.person_id(+) = fu.employee_id and flvv.lookup_type = 'PO TYPE' and flvv.view_application_id = 201 and flvv.lookup_code = poh.type_lookup_code -- and pol.po_header_id(+) = poh.po_header_id and pll.po_line_id(+) = pol.po_line_id and pll.po_release_id(+) is null and ( pll.shipment_type in ('STANDARD','PLANNED') or poh.type_lookup_code='BLANKET') and mc.category_id(+) = pol.category_id and msi.inventory_item_id(+) = pol.item_id and nvl(msi.organization_id,fspa.inventory_organization_id) = fspa.inventory_organization_id -- and papf.employee_number (+) is not null and trunc(sysdate) between papf.effective_start_date (+)and papf.effective_end_date(+) 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_general.get_xbg_profile,'Y', papf2.business_group_id(+) , hr_general.get_business_group_id) = papf2.business_group_id(+) and papf3.employee_number(+) is not null and trunc(sysdate) between papf3.effective_start_date (+) and papf3.effective_end_date (+) and decode(hr_general.get_xbg_profile,'Y', papf3.business_group_id(+) , hr_general.get_business_group_id) = papf3.business_group_id(+) union select mgoat.organization_name operating_unit, poh.segment1 po_number, por.release_num release_number, flvv.description order_type, pov.vendor_name vendor, pvs.vendor_site_code vendor_site, trunc(por.creation_date) order_date, nvl(papf3.full_name,fu.user_name || ' (' || fu.description || ')') created_by, poh.currency_code currency, sum(decode (pol.order_type_lookup_code, 'RATE', pll.amount, 'FIXED PRICE', pll.amount, nvl(pll.quantity, 0) * nvl(pll.price_override, 0))) over (partition by por.po_release_id) order_amount, papf2.full_name buyer, trunc(pah.action_date) cancelled_date, papf.full_name cancelled_by, pah.note reason, -- &lp_line_rel_cols -- decode(psp.manual_po_num_type,'NUMERIC', null,poh.segment1) ord_sort_1, decode(psp.manual_po_num_type,'NUMERIC', to_number(poh.segment1), null) ord_sort_2 from po_releases_all por, po_headers_all poh, ap_supplier_sites_all pvs, po_vendors pov, po_action_history pah, fnd_user fu, per_all_people_f papf, per_all_people_f papf2, per_all_people_f papf3, po_system_parameters_all psp, mo_glob_org_access_tmp mgoat, fnd_lookup_values_vl flvv, -- financials_system_params_all fspa, po_line_locations_all pll, po_lines_all pol, mtl_categories_kfv mc, mtl_system_items_vl msi where 1=1 and 3=3 and por.cancel_flag = 'Y' and por.org_id = psp.org_id and poh.org_id = fspa.org_id and por.org_id = mgoat.organization_id and poh.po_header_id = por.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(pah2.object_revision_num), max(pah2.sequence_num) from po_action_history pah2 where 4=4 and pah2.object_type_code in ('RELEASE') and pah2.action_code in ('CANCEL','MASSCANCEL','RELEASE_MASSCANCEL') and por.po_release_id = pah2.object_id ) 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 papf.person_id(+) = pah.employee_id and papf2.person_id(+) = por.agent_id and fu.user_id = por.created_by and papf3.person_id(+) = fu.employee_id and pll.shipment_type in ('BLANKET','SCHEDULED') and flvv.lookup_type = 'DOCUMENT' and flvv.view_application_id = 201 and flvv.lookup_code = 'RELEASE' -- and pll.po_release_id = por.po_release_id and pol.po_line_id = pll.po_line_id and mc.category_id(+) = pol.category_id and msi.inventory_item_id(+) = pol.item_id and nvl(msi.organization_id,fspa.inventory_organization_id) = fspa.inventory_organization_id -- and trunc(sysdate) between papf.effective_start_date (+)and papf.effective_end_date(+) and decode(hr_general.get_xbg_profile,'Y', papf.business_group_id(+) , hr_general.get_business_group_id) = papf.business_group_id(+) and trunc(sysdate) between papf2.effective_start_date (+) and papf2.effective_end_date (+) and decode(hr_general.get_xbg_profile,'Y', papf2.business_group_id(+) , hr_general.get_business_group_id) = papf2.business_group_id(+) and papf3.employee_number(+) is not null and trunc(sysdate) between papf3.effective_start_date (+) and papf3.effective_end_date (+) and decode(hr_general.get_xbg_profile,'Y', papf3.business_group_id(+) , hr_general.get_business_group_id) = papf3.business_group_id(+) ) x order by x.operating_unit, x.ord_sort_1, x.ord_sort_2, x.release_number &lp_line_sort Y PO POXPOCAN_XML AR PO تقرير أوامر الشراء الملغاة (بتنسيق XML) Application: المشتريات Source: تقرير أوامر الشراء الملغاة (بتنسيق XML) Short Name: POXPOCAN_XML DB package: PO_POXPOCAN_XMLP_PKG D PO Bestellungen - storniert Application: Einkauf Source: Bestellungen - storniert (XML) Short Name: POXPOCAN_XML DB package: PO_POXPOCAN_XMLP_PKG F PO Etat des commandes annulées Application: Purchasing Source: Etat des commandes annulées (XML) Short Name: POXPOCAN_XML DB package: PO_POXPOCAN_XMLP_PKG US PO Cancelled Purchase Orders Application: Purchasing Source: Cancelled Purchase Orders Report (XML) Short Name: POXPOCAN_XML DB package: PO_POXPOCAN_XMLP_PKG ZHS PO 取消的采购订单报表 Application: 采购管理系统 Source: 取消的采购订单报表 (XML) Short Name: POXPOCAN_XML DB package: PO_POXPOCAN_XMLP_PKG Enginatics &lp_line_cols &lp_line_po_cols &lp_line_rel_cols &lp_line_sort 1=1 2=2 3=3 4=4 :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 5 &lp_line_cols , x.line_number, x.category, x.item, x.item_revision, x.line_description, x.uom, x.quantity, x.unit_price, x.line_amount, x.line_cancelled_date, x.line_cancelled_reason 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 Y Y Y US Show Order Lines 2 &lp_line_cols -- N US Show Order Lines 3 &lp_line_po_cols -- N US Show Order Lines 4 &lp_line_po_cols pol.line_num line_number, mc.concatenated_segments category, msi.concatenated_segments item, pol.item_revision item_revision, pol.item_description line_description, pol.unit_meas_lookup_code uom, sum(pll.quantity) over (partition by pol.po_line_id, nvl(pll.price_override,0)) quantity, coalesce(pll.price_override,pol.unit_price,0) unit_price, sum(nvl(pll.quantity,0) * nvl(pll.price_override,0)) over (partition by pol.po_line_id, nvl(pll.price_override,0)) line_amount, trunc(pol.cancel_date) line_cancelled_date, pol.cancel_reason line_cancelled_reason, Y US Show Order Lines 5 &lp_line_rel_cols -- N US Show Order Lines 6 &lp_line_rel_cols pol.line_num line_number, mc.concatenated_segments category, msi.concatenated_segments item, pol.item_revision item_revision, pol.item_description line_description, pol.unit_meas_lookup_code uom, sum(pll.quantity) over (partition by por.po_release_id, pol.po_line_id, nvl(pll.price_override,0)) quantity, coalesce(pll.price_override,pol.unit_price,0) unit_price, sum(decode(pol.order_type_lookup_code, 'RATE', pll.amount, 'FIXED PRICE', pll.amount, nvl(pll.quantity, 0) * nvl(pll.price_override, 0))) over (partition by por.po_release_id, pol.po_line_id, nvl(pll.price_override,0)) line_amount, trunc(pol.cancel_date) line_cancelled_date, pol.cancel_reason line_cancelled_reason, Y US Show Order Lines 7 &lp_line_sort -- N US Show Order Lines 8 &lp_line_sort ,x.line_number Y US Show Order Lines 9 10 1=1 mgoat.organization_name=:p_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 coalesce(xxen_util.default_operating_unit,xxen_util.previous_parameter_value(:parameter_id)) US Operating Unit 10 20 1=1 pov.vendor_name>=: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 AR الموردون من D Von Lieferant F Fournisseurs - De US Vendor From ZHS 供应商自 11 30 1=1 pov.vendor_name<=: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 :$flex$.Vendor_From AR إلى D Bis F A US Vendor To ZHS 至 12 40 1=1 papf2.person_id=: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 AR اسم المشتري D Einkäufername F Nom de l'acheteur US Buyer Name ZHS 采购员姓名 13 50 1=1 pah.action_date>=:p_cancelled_date_from Date AR تواريخ الإلغاء من D Von Stornodatum F Dates d'annulation - Du US Cancelled Date From ZHS 取消日期自 14 4=4 pah2.action_date>=:p_cancelled_date_from US Cancelled Date From 15 60 1=1 pah.action_date<:p_cancelled_date_to+1 Date last_day(:$flex$.Cancelled_Date_From) AR إلى D Bis F Au US Cancelled Date To ZHS 至 16 4=4 pah2.action_date<:p_cancelled_date_to+1 US Cancelled Date To 17 70 2=2 poh.creation_date>=:p_order_date_from Date US Creation Date From 18 3=3 por.creation_date>=:p_order_date_from US Creation Date From 19 80 2=2 poh.creation_date<:p_order_date_to+1 Date last_day(:$flex$.Creation_Date_From) US Creation Date To 20 3=3 por.creation_date<:p_order_date_to+1 US Creation Date To :$flex$.Cancelled_Date_From Cancelled Date From Y Cancelled Date To :$flex$.Creation_Date_From Creation Date From Y Creation Date To :$flex$.Vendor_From Vendor From Vendor To