ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F3AC3869E053B46B63588994Y SELECT PO_HEADER_ID phi, CLM_DOCUMENT_NUMBER, RTrim(replace(replace(replace(replace((address_line_1||','|| ADDRESS_LINE_2 ||',' ||TOWN_OR_CITY ||','||REGION_2||','||POSTAL_CODE||','||COUNTRY),',,,,,',','),',,,,',','),',,,',','),',,',','),',') ISSUING_OFFICE, HRE.FULL_NAME BUYER_NAME, PV.VENDOR_NAME, CURRENCY_CODE CURRENCY, APPROVED_DATE, PO_UCA.get_header_amount_ordered_uca(PHA.PO_HEADER_ID,-1,PHA.AUTHORIZATION_STATUS) AWARD_TOTAL FROM PO_HEADERS_ALL PHA, HR_LOCATIONS_ALL HRL, HR_EMPLOYEES HRE, PO_VENDORS PV WHERE PHA.ORG_ID = :operatingUnit AND PHA.AUTHORIZATION_STATUS = 'APPROVED' AND (:docNum IS NULL OR :docNum = PHA.CLM_DOCUMENT_NUMBER) AND (:issuingOffice IS NULL OR :issuingOffice = PHA.CLM_ISSUING_OFFICE) AND (:buyer IS NULL OR :buyer = PHA.AGENT_ID) AND (:supplier IS NULL OR :supplier = PHA.VENDOR_ID) AND (:dateFrom IS NULL OR :dateFrom <= PHA.APPROVED_DATE) AND (:dateTo IS NULL OR :dateTo >= PHA.APPROVED_DATE) AND EXISTS (SELECT 1 FROM po_line_ucas PLC WHERE PLC.PO_HEADER_ID = PHA.PO_HEADER_ID AND ((NVL(:defType,'UNDEFINITIZED') = 'UNDEFINITIZED' AND undef_approved_date IS NOT NULL AND def_approved_date IS NULL) OR (NVL(:defType,'DEFINITIZED') = 'DEFINITIZED' AND def_approved_date IS NOT NULL) ) ) AND HRL.LOCATION_ID (+) = PHA.CLM_ISSUING_OFFICE AND HRE.EMPLOYEE_ID (+) = PHA.AGENT_ID AND PV.VENDOR_ID (+) = PHA.VENDOR_ID PO POUCA AR PO تقرير إجراءات العقد غير المحددة بشكل نهائي Application: المشتريات Source: تقرير إجراءات العقد غير المحددة بشكل نهائي Short Name: POUCA DB package: PO_UCA D PO Nicht in Kraft gesetzte Vertragsvorgänge Application: Einkauf Source: Nicht in Kraft gesetzte Vertragsvorgänge Short Name: POUCA DB package: PO_UCA F PO Etat des actions de contrat non finalisées Application: Purchasing Source: Etat des actions de contrat non finalisées Short Name: POUCA DB package: PO_UCA US PO Undefinitized Contract Actions Application: Purchasing Source: Undefinitized Contract Actions Report Short Name: POUCA DB package: PO_UCA ZHS PO 未最终确定的合同活动报表 Application: 采购管理系统 Source: 未最终确定的合同活动报表 Short Name: POUCA DB package: PO_UCA BI Publisher :buyer :datefrom :dateto :deftype :docnum :issuingoffice :operatingunit :supplier 1 10 :operatingunit LOV Oracle Operating Unit Y select organization_id id, name value, null description from hr_operating_units order by value,description Y US operatingUnit 2 20 :issuingoffice LOV Oracle ISSUING_OFFICE_BY_OU Y select location_id id, location_code value, rtrim(replace(replace(replace(replace((address_line_1||','|| address_line_2 ||',' ||town_or_city ||','||region_2||','||postal_code||','||country),',,,,,',','),',,,,',','),',,,',','),',,',','),',') description from hr_locations_all where nvl(inactive_date,sysdate+1)>sysdate and :$flex$.operatingunit=inventory_organization_id order by value,description AR مكتب الإصدار D Ausstellende Geschäftsstelle F Bureau émetteur US Issuing Office ZHS 发行处 3 30 :docnum LOV Oracle PO_CLM_DOCNUM_BY_OU Y select pha.clm_document_number id, pha.clm_document_number value, null description from po_headers_all pha where pha.authorization_status='APPROVED' and :$flex$.operatingunit=pha.org_id order by clm_document_number AR رقم المستند D Dokumentnummer F Numéro du document US Document Number ZHS 单据编号 4 40 :buyer LOV Oracle PO_SRS_BUYER_ID Y select hre.employee_id id, hre.full_name value, null description from po_agents poa,hr_employees hre where poa.agent_id=hre.employee_id order by full_name AR المشتري D Einkäufer F Acheteur US Buyer ZHS 采购员 5 50 :deftype LOV Oracle PO_DEFINITIZATION_INDICATOR Y select lookup_code id, displayed_field value, displayed_field description from po_lookup_codes where lookup_type='DEFINITIZATION_INDICATOR' and enabled_flag='Y' order by value,description AR مؤشر التحديد النهائي D Inkraftsetzungsindikator F Indicateur de finalisation US Defnitization Indicator ZHS 最终确定指示符 6 60 :supplier LOV Oracle AP_SRS_1099_VENDOR_NAME_ALL Y select vendor_id id, vendor_name value, null description from po_vendors order by vendor_name AR المورِّد D Lieferant F Fournisseur US Supplier ZHS 供应商 7 70 :datefrom Date AR من تاريخ الاعتماد D Von Genehmigungsdatum F Date d'approbation - Du US Approval Date From ZHS 审批日期自 8 80 :dateto Date AR إلى تاريخ الاعتماد D Bis Genehmigungsdatum F Date d'approbation - Au US Approval Date To ZHS 审批日期至