ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F3EF3869E053B46B63588994Y SELECT poh.po_header_id PO_header_id , pov.vendor_name Vendor , pov.segment1 Vendor_number , pov.purchasing_hold_reason Hold_reason , pov.hold_date Hold_date , hre2.full_name Held_by , poh.segment1 PO_number , hre1.full_name Buyer , poh.creation_date Creation_date , plkc.displayed_field Status , poh.currency_code C_CURRENCY , decode(psp1.manual_po_num_type, 'NUMERIC', null, poh.segment1) , decode(psp1.manual_po_num_type, 'NUMERIC',decode(rtrim(poh.segment1,'0123456789'),null,to_number(poh.segment1),-1), null) , sum((poll.quantity-poll.quantity_cancelled) * poll.price_override) C_AMOUNT FROM hr_employees hre1 , hr_employees hre2 , po_system_parameters psp1 , po_lookup_codes plkc , po_vendors pov , po_headers poh , po_line_locations poll WHERE nvl(poh.authorization_status, 'INCOMPLETE') = plkc.lookup_code AND plkc.lookup_type = 'DOCUMENT STATE' AND poh.vendor_id = pov.vendor_id AND poh.po_header_id = poll.po_header_id AND poh.agent_id = hre1.employee_id AND hre2.employee_id (+) = pov.hold_by AND nvl(poll.cancel_flag,'N') != 'Y' AND nvl(poll.closed_code,'OPEN') NOT IN ('CLOSED','CLOSED FOR RECEIVING','FINALLY CLOSED') AND nvl(pov.hold_flag,'Y') = 'Y' AND ((decode(psp1.manual_po_num_type,'NUMERIC',decode(rtrim(poh.segment1,'0123456789'),NULL,to_number(poh.segment1),-1),null) BETWEEN decode(psp1.manual_po_num_type,'NUMERIC',decode(rtrim(nvl(:P_po_num_from,poh.segment1),'0123456789'),NULL,to_number(nvl(:P_po_num_from,poh.segment1)),-1),null) AND decode(psp1.manual_po_num_type,'NUMERIC',decode(rtrim(nvl(:P_po_num_to,poh.segment1),'0123456789'),NULL,to_number(nvl(:P_po_num_to,poh.segment1)),-1),null)) OR (poh.segment1 BETWEEN decode(psp1.manual_po_num_type,'ALPHANUMERIC',nvl(:P_po_num_from,poh.segment1),null) AND decode(psp1.manual_po_num_type,'ALPHANUMERIC',nvl(:P_po_num_to,poh.segment1),null))) AND pov.vendor_name BETWEEN nvl(:P_vendor_from, pov.vendor_name) AND nvl(:P_vendor_to, pov.vendor_name) GROUP BY poh.po_header_id , pov.vendor_name , pov.segment1 , pov.purchasing_hold_reason , pov.hold_date , hre2.full_name , poh.segment1 , hre1.full_name , poh.creation_date , plkc.displayed_field , poh.currency_code , decode(psp1.manual_po_num_type, 'NUMERIC',decode(rtrim(poh.segment1,'0123456789'),null,to_number(poh.segment1),-1), null) , decode(psp1.manual_po_num_type, 'NUMERIC', null, poh.segment1) ORDER BY &orderby_clause PO POXVDVOH_XML AR PO تقرير إيقاف الموردين (بتنسيق XML) Application: المشتريات Source: تقرير إيقاف الموردين (بتنسيق XML) Short Name: POXVDVOH_XML DB package: PO_POXVDVOH_XMLP_PKG D PO Lieferanten - gesperrt Application: Einkauf Source: Lieferanten - gesperrt (XML) Short Name: POXVDVOH_XML DB package: PO_POXVDVOH_XMLP_PKG F PO Etat des fournisseurs bloqués Application: Purchasing Source: Etat des fournisseurs bloqués (XML) Short Name: POXVDVOH_XML DB package: PO_POXVDVOH_XMLP_PKG US PO Vendors on Hold Application: Purchasing Source: Vendors on Hold Report (XML) Short Name: POXVDVOH_XML DB package: PO_POXVDVOH_XMLP_PKG ZHS PO 供应商暂挂报表 Application: 采购管理系统 Source: 供应商暂挂报表 (XML) Short Name: POXVDVOH_XML DB package: PO_POXVDVOH_XMLP_PKG BI Publisher &orderby_clause :operating_unit :p_conc_request_id :p_min_precision :p_orderby :p_orderby_displayed :p_po_num_from :p_po_num_to :p_title :p_vendor_from :p_vendor_to 1 10 :p_title Char AR العنوان D Titel F Titre US Title ZHS 标题 2 20 :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 Noms de fournisseur - De US Vendor Names From ZHS 起始供应商名称 3 50 :p_po_num_to LOV Oracle PO_SRS_PO_NUMBER Y select poh.segment1 id, poh.segment1 value, null description from po_headers poh,po_system_parameters posp where poh.type_lookup_code in ('STANDARD','PLANNED', 'BLANKET','CONTRACT') order by decode(posp.manual_po_num_type,'NUMERIC', to_number(poh.segment1)), decode(posp.manual_po_num_type,'ALPHANUMERIC', poh.segment1) AR إلى D Bis F A US To ZHS 至 4 30 :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 40 :p_po_num_from LOV Oracle PO_SRS_PO_NUMBER Y select poh.segment1 id, poh.segment1 value, null description from po_headers poh,po_system_parameters posp where poh.type_lookup_code in ('STANDARD','PLANNED', 'BLANKET','CONTRACT') order by decode(posp.manual_po_num_type,'NUMERIC', to_number(poh.segment1)), decode(posp.manual_po_num_type,'ALPHANUMERIC', poh.segment1) AR أرقام أوامر الشراء من D Von Bestellnummer F Numéros d'ordre d'achat - De US PO Numbers From ZHS PO 编号自 6 60 :p_orderby LOV Oracle PO_SRS_POXVDVOH_SORT Y select lookup_code id, displayed_field value, null description from po_lookup_codes where lookup_type='SRS ORDER BY' and lookup_code in ('VENDOR','PO NUMBER') order by displayed_field AR فرز بواسطة D Sortieren nach F Tri par US Sort By ZHS 排序依据 7 70 :p_min_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 动态精确度选项