ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F3B53869E053B46B63588994Y select pov.vendor_name C_VENDOR_NAME , pvs.vendor_site_code C_VENDOR_SITE , null C_FLEX_ITEM , msi.description C_ITEM_DESCRIPTION , msi.list_price_per_unit C_PRICE , paa.country_of_origin_code C_COOC , ft.eu_code C_EU_COOC , pasl.primary_vendor_item C_VENDOR_ITEM_NUMBER , pas.status_description C_ASL_STATUS_DESC , paa.purchasing_unit_of_measure C_UOM, fnd_flex_xml_publisher_apis.process_kff_combination_1('c_flex_item_disp', 'INV', 'MSTK', 101, MSI.ORGANIZATION_ID, MSI.INVENTORY_ITEM_ID, 'ALL', 'Y', 'VALUE') C_FLEX_ITEM_DISP from po_asl_attributes paa , mtl_system_items msi , po_vendors pov , po_vendor_sites pvs , financials_system_parameters fsp , po_approved_supplier_list pasl , po_asl_statuses pas , fnd_territories ft where paa.country_of_origin_code IS NOT NULL AND paa.item_id=msi.inventory_item_id(+) AND msi.organization_id=fsp.inventory_organization_id AND paa.vendor_id=pov.vendor_id AND pov.vendor_name between nvl(:p_vendor_from, pov.vendor_name) and nvl(:p_vendor_to, pov.vendor_name) AND paa.vendor_site_id=pvs.vendor_site_id AND pvs.vendor_site_code=nvl(:p_vendor_site,pvs.vendor_site_code) AND ((paa.using_organization_id = -1 and not exists (SELECT * FROM po_asl_attributes_val_v paa2 WHERE paa2.using_organization_id = :p_ship_to AND paa2.vendor_id = paa.vendor_id AND paa2.vendor_site_id = paa.vendor_site_id AND paa2.item_id = paa.item_id )) OR (paa.using_organization_id =:p_ship_to)) AND paa.asl_id = pasl.asl_id AND pasl.asl_status_id = pas.status_id AND paa.country_of_origin_code = ft.territory_code (+) AND &P_QUERY_WHERE_COUNTRY_CODE PO POXCORSL_XML AR PO تقرير دولة المنشأ (حسب المورد) (بتنسيق XML) Application: المشتريات Source: تقرير دولة المنشأ (حسب المورد) (بتنسيق XML) Short Name: POXCORSL_XML DB package: PO_POXCORSL_XMLP_PKG D PO Ursprungsland - nach Lieferanten Application: Einkauf Source: Ursprungsland - nach Lieferanten (XML) Short Name: POXCORSL_XML DB package: PO_POXCORSL_XMLP_PKG F PO Etat du pays d'origine (par fournisseur) Application: Purchasing Source: Etat du pays d'origine (par fournisseur) (XML) Short Name: POXCORSL_XML DB package: PO_POXCORSL_XMLP_PKG US PO Country of Origin (By Supplier) Application: Purchasing Source: Country of Origin (By Supplier) Report (XML) Short Name: POXCORSL_XML DB package: PO_POXCORSL_XMLP_PKG ZHS PO 原产地（按供应商）报表 Application: 采购管理系统 Source: 原产地（按供应商）报表 (XML) Short Name: POXCORSL_XML DB package: PO_POXCORSL_XMLP_PKG BI Publisher &p_query_where_country_code :operating_unit :p_conc_request_id :p_country_of_origin_code :p_flex_item :p_item_struct_num :p_query_where_country_code :p_ship_to :p_ship_to_org_name :p_title :p_vendor_from :p_vendor_site :p_vendor_to 1 10 :p_title Char AR العنوان D Titel F Titre US Title ZHS 标题 2 20 :p_ship_to LOV Oracle PO_SRS_ORGANIZATIONS Y select organization_id id, organization_code value, organization_name description from org_organization_definitions where nvl(disable_date,trunc(sysdate)+1)>trunc(sysdate) order by value,description Y AR شحن إلى تنظيم D Lieferorganisation F Organisation de livraison US Ship To Organization ZHS 收货组织 3 30 :p_country_of_origin_code LOV Oracle PO_SRS_COOC Y select territory_code id, territory_code value, territory_short_name description from fnd_territories_vl order by territory_code AR رمز دولة المنشأ D Schlüssel Ursprungsland F Code pays d'origine US Country of Origin Code ZHS 原产地代码 4 40 :p_vendor_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 Fournisseur - De US Supplier From ZHS 起始供应商 5 50 :p_vendor_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 AR مورد إلى D Bis Lieferant F Fournisseur - A US Supplier To ZHS 供应商至 6 60 :p_vendor_site LOV Oracle PO_SRS_VENDOR_SITE Y select vendor_site_code id, vendor_site_code value, null description from po_vendor_sites order by vendor_site_code AR موقع المورِّد D Lieferantenadresse F Site fournisseur US Supplier Site ZHS 供应商地点