ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F3C43869E053B46B63588994Y SELECT distinct(pov.vendor_name||papf.full_name) , papf.full_name Buyer , pov.vendor_name Vendor , pov.vendor_id , papf. person_id employee_id, PO_POXPOPAA_XMLP_PKG.cf_buyer_formulaformula(papf.full_name) CF_BUYER_FORMULA FROM PER_ALL_PEOPLE_F PAPF , po_vendors pov , po_headers poh WHERE poh.agent_id = papf.person_id AND poh.vendor_id = pov.vendor_id AND poh.type_lookup_code in ('STANDARD','BLANKET','PLANNED') AND nvl(poh.closed_code,'OPEN') NOT IN ('FINALLY CLOSED', 'CLOSED') AND nvl(poh.cancel_flag,'N') = 'N' AND papf.person_id = nvl(:P_buyer,papf.person_id) AND pov.vendor_name BETWEEN nvl(:P_vendor_from,pov.vendor_name) AND nvl(:P_vendor_to,pov.vendor_name) AND EXISTS (select 'x' from po_lines pol , po_line_locations pll , po_releases por where pol.po_header_id = poh.po_header_id and pol.po_line_id = pll.po_line_id and nvl(pll.closed_code,'OPEN') not in ('FINALLY CLOSED','CLOSED') and nvl(pol.closed_code,'OPEN') not in ('FINALLY CLOSED','CLOSED') and nvl(por.closed_code,'OPEN') not in ('FINALLY CLOSED','CLOSED') and nvl(pll.cancel_flag,'N') = 'N' and nvl(pol.cancel_flag,'N') = 'N' and nvl(por.cancel_flag,'N') = 'N' and pll.shipment_type in ('STANDARD','BLANKET','SCHEDULED') and pll.po_release_id = por.po_release_id(+)) and PAPF.BUSINESS_GROUP_ID = (SELECT NVL(MAX(FSP.BUSINESS_GROUP_ID),0) FROM FINANCIALS_SYSTEM_PARAMETERS FSP) 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' AND DECODE(HR_GENERAL.GET_XBG_PROFILE,'Y', PAPF.BUSINESS_GROUP_ID , HR_GENERAL.GET_BUSINESS_GROUP_ID) = PAPF.BUSINESS_GROUP_ID ORDER BY papf.full_name , pov.vendor_name PO POXPOPAA_XML AR PO تقرير أوامر الشراء المفتوحة (بواسطة المشتري) (بتنسيق XML) Application: المشتريات Source: تقرير أوامر الشراء المفتوحة (بواسطة المشتري) (بتنسيق XML) Short Name: POXPOPAA_XML DB package: PO_POXPOPAA_XMLP_PKG D PO Bestellungen - offen nach Einkäufer Application: Einkauf Source: Bestellungen - offen nach Einkäufer (XML) Short Name: POXPOPAA_XML DB package: PO_POXPOPAA_XMLP_PKG F PO Etat des commandes non soldées, par acheteur Application: Purchasing Source: Etat des commandes non soldées, par acheteur (XML) Short Name: POXPOPAA_XML DB package: PO_POXPOPAA_XMLP_PKG US PO Open Purchase Orders Report(by Buyer) Application: Purchasing Source: Open Purchase Orders Report(by Buyer) (XML) Short Name: POXPOPAA_XML DB package: PO_POXPOPAA_XMLP_PKG ZHS PO 打开的采购订单报表（按采购员） Application: 采购管理系统 Source: 打开的采购订单报表（按采购员）(XML) Short Name: POXPOPAA_XML DB package: PO_POXPOPAA_XMLP_PKG BI Publisher :cp_buyer :operating_unit :p_buyer :p_conc_request_id :p_flex_cat :p_flex_item :p_qty_precision :p_struct_num :p_title :p_vendor_from :p_vendor_to :qty_precision 1 10 :p_title Char AR العنوان D Titel F Titre US Title ZHS 标题 2 20 :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 采购员姓名 3 30 :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 Fournisseurs - De US Vendors From ZHS 供应商自 4 40 :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 F A US To ZHS 至 5 50 :p_qty_precision LOV Oracle INV_SRS_PRECISION Y select lookup_code id, lookup_code value, meaning description from mfg_lookups where lookup_type='INV_SRS_PRECISION' and enabled_flag='Y' order by lookup_code select fnd_profile.value('REPORT_QUANTITY_PRECISION') from dual Y AR خيار الدقة الديناميكية D Option Nachkommastellen F Option précision dynamique US Dynamic Precision Option ZHS 动态精确度选项