ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F3DB3869E053B46B63588994Y SELECT prh.segment1 Req_Number , trunc(prl.creation_date) CDate , papf.full_name Requestor , prl.source_subinventory Subinventory , null C_FLEX_ITEM , prl.item_revision Rev , prl.item_description Description , prl.unit_meas_lookup_code Unit , round(prl.quantity,:P_qty_precision) Required , round(nvl(prl.quantity_delivered,null),:P_qty_precision) Delivered , round(sum(&C_backordered), :P_qty_precision) Backordered , decode(nvl(prl.cancel_flag,'N'), 'Y', round((prl.quantity - nvl(prl.quantity_delivered,0)),:P_qty_precision), to_number(NULL)) Cancelled , nvl(prl.unit_price, 0) unit_price , round(&C_ship_qty, :P_qty_precision) Shipped, 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_POXRQSIN_XMLP_PKG.c_ship_amountformula(round ( prl.quantity , :P_qty_precision ), nvl ( prl.unit_price , 0 )) C_ship_amount FROM po_requisition_lines prl , po_requisition_headers prh , mtl_system_items msi , per_all_people_f papf &C_from , po_system_parameters_all psp1 WHERE &P_WHERE_QUERY AND 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 psp1.ORG_ID = prh.ORG_ID 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 msi.inventory_item_id = prl.item_id AND nvl(msi.organization_id,prl.source_organization_id) = prl.source_organization_id &C_where AND papf.person_id = prl.to_person_id AND prh.authorization_status = nvl(:P_status,prh.authorization_status) 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 AND &P_WHERE_ITEM GROUP BY prh.segment1, prl.creation_date, papf.full_name, prl.source_subinventory, 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'), prl.item_revision, prl.item_description, prl.unit_meas_lookup_code, prl.quantity, prl.quantity_delivered, &C_backordered, prl.cancel_flag, prl.unit_price, &C_ship_qty UNION SELECT prh.segment1 Req_Number , trunc(prl.creation_date) CDate , papf.full_name Requestor , prl.source_subinventory Subinventory , null C_FLEX_ITEM , prl.item_revision Rev , prl.item_description Description , prl.unit_meas_lookup_code Unit , round(prl.quantity,:P_qty_precision) Required , round(nvl(prl.quantity_delivered,0),:P_qty_precision) Delivered , to_number(null) Backordered , decode(nvl(prl.cancel_flag,'N'), 'Y', round((prl.quantity - nvl(prl.quantity_delivered,0)),:P_qty_precision), to_number(NULL)) Cancelled , nvl(prl.unit_price, 0) unit_price , to_number(NULL) Shipped, 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_POXRQSIN_XMLP_PKG.c_ship_amountformula(round ( prl.quantity , :P_qty_precision ), nvl ( prl.unit_price , 0 )) C_ship_amount FROM po_requisition_lines prl , po_requisition_headers prh , mtl_system_items msi , per_all_people_f papf , po_system_parameters_all psp1 WHERE &P_WHERE_QUERY AND psp1.ORG_ID = prh.ORG_ID AND 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') = 'N' OR (nvl(prh.transferred_to_oe_flag,'N') = 'Y' &C_interface_where)) AND msi.inventory_item_id(+) = prl.item_id AND nvl(msi.organization_id,prl.source_organization_id) = prl.source_organization_id AND papf.person_id = prl.to_person_id AND prh.authorization_status = nvl(:P_status,prh.authorization_status) 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 AND &P_WHERE_ITEM ORDER BY &ORDERBY_CLAUSE PO POXRQSIN_XML AR PO تقرير موقف طلب الشراء الداخلي (بتنسيق XML) Application: المشتريات Source: تقرير موقف طلب الشراء الداخلي (بتنسيق XML) Short Name: POXRQSIN_XML DB package: PO_POXRQSIN_XMLP_PKG D PO Interne Anforderungen - Status Application: Einkauf Source: Interne Anforderungen - Status (XML) Short Name: POXRQSIN_XML DB package: PO_POXRQSIN_XMLP_PKG F PO Etat Statut des demandes internes Application: Purchasing Source: Etat Statut des demandes internes (XML) Short Name: POXRQSIN_XML DB package: PO_POXRQSIN_XMLP_PKG US PO Internal Requisition Status Application: Purchasing Source: Internal Requisition Status Report (XML) Short Name: POXRQSIN_XML DB package: PO_POXRQSIN_XMLP_PKG ZHS PO 内部申请状态报表 Application: 采购管理系统 Source: 内部申请状态报表 (XML) Short Name: POXRQSIN_XML DB package: PO_POXRQSIN_XMLP_PKG BI Publisher &c_backordered &c_from &c_interface_where &c_ship_qty &c_where &orderby_clause &p_where_item &p_where_query :format_mask :operating_unit :p_conc_request_id :p_creation_date_from :p_creation_date_from1 :p_creation_date_to :p_creation_date_to1 :p_flex_item :p_item_from :p_item_to :p_oe_status :p_orderby :p_orderby_displayed :p_qty_precision :p_req_num_type :p_req_number_from :p_req_number_to :p_requestor :p_single_po_print :p_status :p_status_displayed :p_struct_num :p_subinventory_from :p_subinventory_to :p_title :p_where_item :p_where_query 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 110 :p_req_number_to LOV Oracle PO_SRS_REQUISITION_NUMBER Y select prh.segment1 id, prh.segment1 value, null description from po_requisition_headers prh,po_system_parameters psp where (nvl(prh.authorization_status,'INCOMPLETE')<>'SYSTEM_SAVED') and nvl(prh.conformed_header_id,0)=0 order by decode(psp.manual_req_num_type,'NUMERIC', to_number(prh.segment1)) ,decode(psp.manual_req_num_type,'ALPHANUMERIC', prh.segment1) AR إلى D Bis F A US To ZHS 至 5 80 :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 至 6 40 :p_item_from Char AR الأصناف من D Von Artikel F Articles - De US Items From ZHS 物料自 7 50 :p_item_to Char AR إلى D bis F à US to ZHS 至 8 60 :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 申请人 9 70 :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 子库存自 10 90 :p_status LOV Oracle PO_SRS_AUTHORIZATION_STATUS Y select lookup_code id, displayed_field value, null description from po_lookup_codes where lookup_type='DOCUMENT STATE' and lookup_code in ('RETURNED','RESERVED','APPROVED', 'REQUIRES REAPPROVAL','REJECTED','PRE-APPROVED', 'IN PROCESS','INCOMPLETE') order by displayed_field AR الموقف F Statut US Status ZHS 状态 11 100 :p_req_number_from LOV Oracle PO_SRS_REQUISITION_NUMBER Y select prh.segment1 id, prh.segment1 value, null description from po_requisition_headers prh,po_system_parameters psp where (nvl(prh.authorization_status,'INCOMPLETE')<>'SYSTEM_SAVED') and nvl(prh.conformed_header_id,0)=0 order by decode(psp.manual_req_num_type,'NUMERIC', to_number(prh.segment1)) ,decode(psp.manual_req_num_type,'ALPHANUMERIC', prh.segment1) AR أرقام طلب الشراء من D Von Anforderungsnummer F Numéros de demande d'approvisionnement - De US Requisition Numbers From ZHS 申请编号自 12 120 :p_orderby LOV Oracle PO_SRS_POXRQSIN_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 ('CREATION DATE','SUBINVENTORY', 'REQUESTOR') order by displayed_field AR فرز بواسطة D Sortieren nach F Tri par US Sort By ZHS 排序依据 13 130 :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 动态精确度选项