ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F3D73869E053B46B63588994Y SELECT prh.segment1 Req_Number , prl.creation_date CDate , prl.line_num Line , prl.item_id Item_ID , prl.source_organization_id Org_ID , null C_FLEX_ITEM , null C_FLEX_CAT , prl.item_description Item_Description , papf.full_name Requestor , ood.organization_code Organization , prl.source_subinventory Subinventory , (prl.quantity - nvl(prl.quantity_cancelled,0)) Ordered_Quantity , round(SUM(&C_backordered),:P_qty_precision) Backordered , prl.unit_meas_lookup_code Unit , round(SUM(&C_ship_quantity), :P_qty_precision) Shipped , decode(psp1.manual_req_num_type,'NUMERIC', null,prh.segment1) , decode(psp1.manual_req_num_type,'NUMERIC', to_number(prh.segment1),null), 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, fnd_flex_xml_publisher_apis.process_kff_combination_1('c_flex_cat_disp', 'INV', 'MCAT', MCA.STRUCTURE_ID, NULL, MCA.CATEGORY_ID, 'ALL', 'Y', 'VALUE') C_FLEX_CAT_DISP FROM po_requisition_headers prh , po_requisition_lines prl , mtl_system_items msi , per_all_people_f papf &C_from , mtl_categories mca , org_organization_definitions ood , po_system_parameters psp1 WHERE trunc(prl.creation_date) BETWEEN nvl(:P_creation_date_from,trunc(prl.creation_date)-1) AND nvl(:P_creation_date_to,trunc(prl.creation_date)+1) AND papf.full_name = nvl(:P_requestor,papf.full_name) AND nvl(prl.source_subinventory,'-1') BETWEEN nvl(:P_subinventory_from, nvl(prl.source_subinventory,'-1')) AND nvl(:P_subinventory_to,nvl(prl.source_subinventory,'-1')) AND prl.requisition_header_id = prh.requisition_header_id AND prl.source_type_code = 'INVENTORY' AND nvl(prh.transferred_to_oe_flag,'N') = 'Y' AND prl.source_organization_id = ood.organization_id AND papf.person_id = prl.to_person_id AND msi.inventory_item_id = prl.item_id AND msi.organization_id = prl.source_organization_id AND mca.category_id = prl.category_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 &C_where GROUP BY prh.segment1 , prl.creation_date , prl.line_num , prl.item_id , prl.source_organization_id , 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') , fnd_flex_xml_publisher_apis.process_kff_combination_1('c_flex_cat_disp', 'INV', 'MCAT', MCA.STRUCTURE_ID, NULL, MCA.CATEGORY_ID, 'ALL', 'Y', 'VALUE') , prl.item_description , papf.full_name , ood.organization_code , prl.source_subinventory , &C_backordered , prl.unit_meas_lookup_code , &C_ship_quantity , psp1.manual_req_num_type , (prl.quantity - nvl(prl.quantity_cancelled,0)) ORDER BY decode(psp1.manual_req_num_type,'NUMERIC', null,prh.segment1) , decode(psp1.manual_req_num_type,'NUMERIC', to_number(prh.segment1), null) , prl.line_num PO POXRQOBO_XML AR PO تقرير متأخرات طلبات الشراء الداخلية (بتنسيق XML) Application: المشتريات Source: تقرير متأخرات طلبات الشراء الداخلية (بتنسيق XML) Short Name: POXRQOBO_XML DB package: PO_POXRQOBO_XMLP_PKG D PO Interne Anforderungen - Nachlieferungen Application: Einkauf Source: Interne Anforderungen - Nachlieferungen (XML) Short Name: POXRQOBO_XML DB package: PO_POXRQOBO_XMLP_PKG F PO Etat des demandes d'approvisionnement en reliquat Application: Purchasing Source: Etat des demandes d'approvisionnement en reliquat (XML) Short Name: POXRQOBO_XML DB package: PO_POXRQOBO_XMLP_PKG US PO Backordered Internal Requisitions Application: Purchasing Source: Backordered Internal Requisitions Report (XML) Short Name: POXRQOBO_XML DB package: PO_POXRQOBO_XMLP_PKG ZHS PO 延交订单的内部申请报表 Application: 采购管理系统 Source: 延交订单的内部申请报表 (XML) Short Name: POXRQOBO_XML DB package: PO_POXRQOBO_XMLP_PKG BI Publisher &c_backordered &c_from &c_ship_quantity &c_where :operating_unit :p_conc_request_id :p_cr_installed :p_creation_date_from :p_creation_date_to :p_flex_cat :p_flex_item :p_oe_status :p_qty_precision :p_requestor :p_struct_num :p_subinventory_from :p_subinventory_to :p_title :qty_precision 1 10 :p_title Char AR العنوان D Titel F Titre US Title ZHS 标题 2 20 :p_creation_date_from Date AR تواريخ التكوين من D Von Erstellungsdatum F Dates de création - Du US Creation Dates From ZHS 创建日期自 3 30 :p_creation_date_to Date AR إلى D Bis F Au US To ZHS 至 4 60 :p_subinventory_to LOV Oracle PO_SRS_SUBINVENTORY Y select msub.secondary_inventory_name id, msub.secondary_inventory_name value, msub.description description from mtl_secondary_inventories msub,financials_system_parameters fsp where fsp.inventory_organization_id=msub.organization_id order by msub.secondary_inventory_name AR إلى D Bis F A US To ZHS 至 5 40 :p_requestor LOV Oracle PO_SRS_EMPLOYEE Y select full_name id, full_name value, null description from hr_employees order by full_name AR الطالب D Anforderer F Demandeur US Requester ZHS 申请人 6 50 :p_subinventory_from LOV Oracle PO_SRS_SUBINVENTORY Y select msub.secondary_inventory_name id, msub.secondary_inventory_name value, msub.description description from mtl_secondary_inventories msub,financials_system_parameters fsp where fsp.inventory_organization_id=msub.organization_id order by msub.secondary_inventory_name AR المخازن من D Von Lager F Magasins - De US Subinventories From ZHS 子库存自 7 70 :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 动态精确度选项