ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F3DA3869E053B46B63588994Y select req.operating_unit, req.req_number, req.req_type, req.req_date, req.destination_oganization, req.requestor, req.line_number, req.item, req.item_revision, req.item_description, req.source_organization, req.source_subinventory, req.unit_price, req.uom, req.quantity_requested, shp.quantity_shipped, shp.amount_shipped, req.quantity_delivered, req.amount_delivered, shp.quantity_shipped-nvl(req.quantity_delivered,0) quantity_variance, shp.amount_shipped-nvl(req.amount_delivered,0) cost_variance from ( select hou.name operating_unit, prha.segment1 req_number, xxen_util.meaning(prha.type_lookup_code,'REQUISITION TYPE',201) req_type, prla.creation_date req_date, mp.organization_code destination_oganization, papf.full_name requestor, prla.line_num line_number, pspa.order_source_id, msiv.concatenated_segments item, prla.item_revision, msiv.description item_description, ood.organization_name source_organization, prla.source_subinventory, prla.unit_meas_lookup_code uom, prla.unit_price, prla.quantity-nvl(prla.quantity_cancelled,0) quantity_requested, prla.quantity_delivered, prla.quantity_delivered*nvl(prla.unit_price,0) amount_delivered, prla.requisition_header_id, prla.requisition_line_id from po_requisition_headers prha, po_requisition_lines prla, mtl_system_items_vl msiv, per_all_people_f papf, org_organization_definitions ood, po_system_parameters pspa, hr_operating_units hou, mtl_parameters mp where 1=1 and prla.quantity_delivered>0 and hou.organization_id=prha.org_id and pspa.org_id=prha.org_id and prla.requisition_header_id=prha.requisition_header_id and prla.source_type_code='INVENTORY' and nvl(prha.transferred_to_oe_flag,'N')='Y' and prla.source_organization_id=ood.organization_id and papf.person_id=prla.to_person_id and msiv.inventory_item_id=prla.item_id and nvl(msiv.organization_id,prla.source_organization_id)=prla.source_organization_id and trunc(sysdate) between papf.effective_start_date and papf.effective_end_date and prla.destination_organization_id=mp.organization_id ) req, ( select oola.order_source_id, oola.orig_sys_document_ref, oola.orig_sys_line_ref, oola.source_document_id, oola.source_document_line_id, sum(oola.shipped_quantity) quantity_shipped, sum(nvl(oola.unit_selling_price,0) * nvl(oola.shipped_quantity,0)) amount_shipped from oe_order_lines_all oola, oe_order_headers_all ooha where oola.header_id=ooha.header_id and oola.shipped_quantity is not null group by oola.order_source_id, oola.orig_sys_document_ref, oola.orig_sys_line_ref, oola.source_document_id, oola.source_document_line_id ) shp where req.order_source_id=shp.order_source_id(+) and req.req_number=shp.orig_sys_document_ref(+) and req.line_number=shp.orig_sys_line_ref(+) and req.requisition_header_id=shp.source_document_id(+) and req.requisition_line_id=shp.source_document_line_id(+) order by case :p_orderby when 'REQUESTOR' then req.requestor when 'SUBINVENTORY' then req.source_subinventory end, req.req_date, req.req_number PO AR PO تقرير متناقضات طلبات الشراء/التسليمات الداخلية (بتنسيق XML) Application: المشتريات Source: تقرير متناقضات طلبات الشراء/التسليمات الداخلية (بتنسيق XML) Short Name: POXRQSDD_XML DB package: PO_POXRQSDD_XMLP_PKG D PO Interne Anforderungen/Lieferungen - Differenzen Application: Einkauf Source: Interne Anforderungen/Lieferungen - Differenzen (XML) Short Name: POXRQSDD_XML DB package: PO_POXRQSDD_XMLP_PKG F PO Etat Ecarts demandes internes/mises à disposition Application: Purchasing Source: Etat Ecarts demandes internes/mises à disposition (XML) Short Name: POXRQSDD_XML DB package: PO_POXRQSDD_XMLP_PKG US PO Internal Requisitions/Deliveries Discrepancy Application: Purchasing Description: Internal Requisitions/Deliveries Discrepancy Report Source: Internal Requisitions/Deliveries Discrepancy Report (XML) Short Name: POXRQSDD_XML ZHS PO 内部申请/交货差异报表 Application: 采购管理系统 Source: 内部申请/交货差异报表 (XML) Short Name: POXRQSDD_XML DB package: PO_POXRQSDD_XMLP_PKG Enginatics 1=1 :p_orderby 1 10 1=1 hou.name=:p_operating_unit LOV HR Operating Unit 8E2FF36EDEB979D2E0530100007F1FF2 Y select hou.name value, null description from hr_operating_units hou where sysdate between hou.date_from and nvl(hou.date_to,sysdate) and (:$flex$.ledger is null or hou.set_of_books_id in (select gl.ledger_id from gl_ledgers gl where xxen_util.contains(:$flex$.ledger,gl.name)='Y')) and hou.organization_id in (select mgoat.organization_id from mo_glob_org_access_tmp mgoat union select fnd_global.org_id from dual where fnd_release.major_version=11) order by hou.name F Unité d'exploitation US Operating Unit 2 20 1=1 prha.segment1>=:p_req_number_from LOV custom Y select prh.segment1 value, null description from po_requisition_headers prh ,po_system_parameters psp ,hr_operating_units hou where psp.org_id=prh.org_id and hou.organization_id=prh.org_id and (:$flex$.operating_unit is null or xxen_util.contains(:$flex$.operating_unit,hou.name) = 'Y') and (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éro de demande d'emploi De US Requisition Number From ZHS 申请编号自 3 30 1=1 prha.segment1<=:p_req_number_to LOV custom Y select prh.segment1 value, null description from po_requisition_headers prh ,po_system_parameters psp ,hr_operating_units hou where psp.org_id=prh.org_id and hou.organization_id=prh.org_id and (:$flex$.operating_unit is null or xxen_util.contains(:$flex$.operating_unit,hou.name) = 'Y') and (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) :$flex$.Requisition_Number_From AR إلى D Bis F Numéro de demande à US Requisition Number To ZHS 至 4 40 1=1 papf.full_name=: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 申请人 5 50 1=1 prla.creation_date>=:p_creation_date_from Date AR تواريخ تكوين طلب الشراء من D Von Erstellungsdatum Anforderung F Date de la demande du US Requisition Date From ZHS 申请创建日期自 6 60 1=1 prla.creation_date<:p_creation_date_to+1 Date last_day(:$flex$.Requisition_Date_From) AR إلى D Bis F Date de la demande au US Requisition Date To ZHS 至 7 70 1=1 prla.destination_organization_id in (select mp.organization_id from mtl_parameters mp where mp.organization_code=:ship_from_warehouse) LOV INV Organization Code 8E2FF36EDEB279D2E0530100007F1FF2 Y select ood.organization_code value, ood.organization_name||' ('||ftv.territory_short_name||', '||hla.town_or_city||decode(mp.organization_id,mp.master_organization_id,null,', '||mp0.organization_code)||')' description from org_organization_definitions ood, mtl_parameters mp, mtl_parameters mp0, hr_all_organization_units haou, hr_locations_all hla, fnd_territories_vl ftv where ood.organization_id=mp.organization_id and mp.organization_id<>mp.master_organization_id and ( ood.organization_id in (select oav.organization_id from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) or not exists (select null from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) and ood.operating_unit in (select mgoat.organization_id from mo_glob_org_access_tmp mgoat union select fnd_global.org_id from dual where fnd_release.major_version=11) ) and (:$flex$.operating_unit is null or ood.operating_unit in (select haouv.organization_id from hr_all_organization_units_vl haouv where xxen_util.contains(:$flex$.operating_unit,haouv.name)='Y')) and (:$flex$.ledger is null or ood.set_of_books_id in (select gl.ledger_id from gl_ledgers gl where xxen_util.contains(:$flex$.ledger,gl.name)='Y')) and nvl(ood.disable_date,sysdate)>=sysdate and mp.master_organization_id=mp0.organization_id and ood.organization_id=haou.organization_id(+) and haou.location_id=hla.location_id(+) and hla.country=ftv.territory_code(+) order by ood.organization_code US Destination Organization 8 80 :p_orderby LOV Oracle PO_SRS_POXRQSDD_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 ('REQUESTOR','CREATION DATE', 'SUBINVENTORY') order by displayed_field CREATION DATE AR فرز بواسطة D Sortieren nach F Trier par US Sort By ZHS 排序依据