ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F3C23869E053B46B63588994Y select Q1.*, PO_POXPODDR_XMLP_PKG.C_amount_cur_round_p(Q1.C_dist_amt_cur,:p_qty_precision) C_amount_cur_round, PO_POXPODDR_XMLP_PKG.C_amount_fun_round_p(Q1.C_dist_amt_func,:p_qty_precision) C_amount_fun_round from (SELECT pol.line_num||'-'||pll.shipment_num Line_Ship , por.release_num Release , null C_FLEX_ITEM , pol.item_revision Rev , pol.item_description Description , pol.unit_meas_lookup_code Unit , pol.order_type_lookup_code ORDER_TYPE_LOOKUP_CODE , round((pll.quantity - nvl(pll.quantity_cancelled, 0)),:p_qty_precision) ship_qty_ordered , round((pll.quantity - nvl(pll.quantity_cancelled, 0)),:p_qty_precision) C_Quantity_Ordered , pll.price_override Unit_Price , null C_FLEX_ACC , to_char(pod.gl_encumbered_date,'DD-MON-YY') Reserved_Date , pod.quantity_ordered - nvl(pod.quantity_cancelled, 0) dist_quantity_ordered , pll.line_location_id , pll.source_shipment_id , pll.shipment_type , pod.po_distribution_id , pod.rate rate , pod.source_distribution_id , POD.amount_ordered - NVL(POD.amount_cancelled, 0) DIST_AMOUNT_ORDERED &select_failed_f, 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, PO_POXPODDR_XMLP_PKG.get_ship_quantity(pll.shipment_type, round ( ( pll.quantity - nvl ( pll.quantity_cancelled , 0 ) ) , :p_qty_precision ), :C_ship_rls_qty) C_ship_quantity, PO_POXPODDR_XMLP_PKG.get_dist_cur_amount(pll.shipment_type, pod.quantity_ordered - nvl ( pod.quantity_cancelled , 0 ), :C_dist_rls_qty, pll.price_override, pol.order_type_lookup_code, POD.amount_ordered - NVL ( POD.amount_cancelled , 0 )) C_dist_amt_cur, PO_POXPODDR_XMLP_PKG.get_dist_func_amount(pll.shipment_type, pod.quantity_ordered - nvl ( pod.quantity_cancelled , 0 ), :C_dist_rls_qty, pll.price_override, pod.rate, pol.order_type_lookup_code, POD.amount_ordered - NVL ( POD.amount_cancelled , 0 )) C_dist_amt_func, fnd_flex_xml_publisher_apis.process_kff_combination_1('c_flex_acc_sort', 'SQLGL', 'GL#', GCC.CHART_OF_ACCOUNTS_ID, NULL, GCC.CODE_COMBINATION_ID, 'ALL', 'Y', 'PADDED_VALUE') C_FLEX_ACC_SORT, fnd_flex_xml_publisher_apis.process_kff_combination_1('c_flex_acc_disp', 'SQLGL', 'GL#', GCC.CHART_OF_ACCOUNTS_ID, NULL, GCC.CODE_COMBINATION_ID, 'ALL', 'Y', 'VALUE') C_FLEX_ACC_DISP FROM po_lines pol , po_releases por , mtl_system_items msi , po_line_locations pll , &lp_po_distributions pod &from_failed_f WHERE pod.po_release_id = por.po_release_id (+) AND pol.item_id = msi.inventory_item_id (+) AND nvl(msi.organization_id, :c_organization_id) = :c_organization_id AND pol.po_line_id = pll.po_line_id AND pll.line_location_id = pod.line_location_id AND pll.shipment_type in ('BLANKET','STANDARD','PLANNED','SCHEDULED') AND DECODE (POL.order_type_lookup_code, 'RATE', POD.amount_ordered - NVL(POD.amount_cancelled, 0), 'FIXED PRICE', POD.amount_ordered - NVL(POD.amount_cancelled, 0), POD.quantity_ordered - NVL(POD.quantity_cancelled, 0)) > 0 &where_failed_f and pol.po_header_id = :po_header_id1 ORDER BY 2 ASC,4 ASC,5 ASC,6 ASC,10 ASC,7 ASC,21 ASC,3 ASC,8 ASC,1 ASC,14 ASC,15 ASC,19 ASC,16 ASC,18 ASC,9 ASC , pol.line_num , &P_FLEX_ACC) Q1 PO POXPODDR_XML AR PO تقرير تفاصيل توزيع أمر الشراء (بتنسيق XML) Application: المشتريات Source: تقرير تفاصيل توزيع أمر الشراء (بتنسيق XML) Short Name: POXPODDR_XML DB package: PO_POXPODDR_XMLP_PKG D PO Bestellungen - Aufteilungsdetails Application: Einkauf Source: Bestellungen - Aufteilungsdetails (XML) Short Name: POXPODDR_XML DB package: PO_POXPODDR_XMLP_PKG F PO Etat détaillé des imputations de commande Application: Purchasing Source: Etat détaillé des imputations de commande (XML) Short Name: POXPODDR_XML DB package: PO_POXPODDR_XMLP_PKG US PO Purchase Order Distribution Detail Application: Purchasing Source: Purchase Order Distribution Detail Report (XML) Short Name: POXPODDR_XML DB package: PO_POXPODDR_XMLP_PKG ZHS PO 采购订单分配明细报表 Application: 采购管理系统 Source: 采购订单分配明细报表 (XML) Short Name: POXPODDR_XML DB package: PO_POXPODDR_XMLP_PKG BI Publisher &from_failed_f &lp_po_distributions &p_flex_acc &select_failed_f &where_failed_f :c_amount_cur_round :c_amount_fun_round :c_amount_func_sub_round :c_amount_func_tot_round :c_dist_rls_qty :c_organization_id :c_ship_rls_qty :lp_fin_system_parameters :lp_fin_system_parameters_all :lp_po_distributions :lp_po_distributions_all :lp_po_headers :lp_po_headers_all :lp_rcv_receiving_sub_ledger :lp_rcv_shipment_headers :lp_rcv_sub_ledger_details :lp_rcv_transactions :operating_unit :p_buyer :p_ca_set_of_books_id :p_conc_request_id :p_creation_date_from :p_creation_date_from1 :p_creation_date_to :p_creation_date_to1 :p_failed_funds :p_failed_funds_disp :p_flex_acc :p_flex_item :p_mrcsobtype :p_orderby :p_orderby_disp :p_po_num_from :p_po_num_to :p_qty_precision :p_title :p_vendor_from :p_vendor_to :po_header_id1 :type_lookup_code :where_performance :where_vendor_performance 1 10 :p_ca_set_of_books_id LOV Oracle PO_LEDGER_CURRENCY Y select target_ledger_id id, target_currency_code value, target_ledger_name description from gl_ledger_relationships where source_ledger_id=(select set_of_books_id from financials_system_parameters) and relationship_enabled_flag='Y' and ((relationship_type_code='NONE' and application_id=101) or (target_ledger_category_code='ALC' and application_id=201 and relationship_type_code='SUBLEDGER')) order by value,description SELECT target_currency_code FROM gl_ledger_relationships WHERE source_ledger_id = (select set_of_books_id from financials_system_parameters) AND relationship_enabled_flag = 'Y' AND ( ( relationship_type_code = 'NONE' AND application_id = 101)) Y AR عملة الأستاذ D Buchwährung F Devise comptable US Ledger Currency ZHS 分类帐币种 2 20 :p_title Char AR العنوان D Titel F Titre US Title ZHS 标题 3 30 :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 de commande - De US PO Numbers From ZHS PO 编号自 4 60 :p_creation_date_to Date AR إلى D Bis F Au US To ZHS 至 5 40 :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 至 6 80 :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 至 7 50 :p_creation_date_from Date AR تواريخ التكوين من D Von Erstellungsdatum F Dates de création - Du US Creation Dates From ZHS 创建日期自 8 70 :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 供应商自 9 90 :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 采购员姓名 10 100 :p_failed_funds LOV Oracle AP_SRS_YES_NO_OPT Y select lookup_code id, meaning value, null description from fnd_lookups where lookup_type='YES_NO' order by value,description Y AR فشل الأموال فقط D Nur nicht genehmigte Mittel F Fonds insuffisants seulement US Failed Funds Only ZHS 仅限于未通过资金检查的采购单 11 110 :p_orderby LOV Oracle PO_SRS_POXPODDR_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 ('PO NUMBER','VENDOR') order by displayed_field AR فرز بواسطة D Sortieren nach F Tri par US Sort By ZHS 排序依据