ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F3B13869E053B46B63588994Y SELECT PHA.CLM_DOCUMENT_NUMBER, PHA.clm_issuing_office, PHA.AUTHORIZATION_STATUS, PHA.APPROVED_DATE, PHA.TYPE_LOOKUP_CODE, PHA.ORG_ID, PHA.CLM_COTR_OFFICE, PHA.CLM_SUPPLIER_NAME, PHA.AGENT_ID DOCUMENT_BUYER_AGENT_ID, PHA.VENDOR_ID, PDS.DISPLAY_NAME,PHA.CURRENCY_CODE, (Select PVN.VENDOR_NAME FROM PO_VENDORS PVN WHERE PVN.VENDOR_ID = PHA.VENDOR_ID)VENDOR_NAME, (SELECT PPF.FULL_NAME FROM PER_PEOPLE_F PPF WHERE PPF.PERSON_ID = PHA.CLM_CONTRACT_OFFICER AND TRUNC(SYSDATE) BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE) CONTRACT_OFC_CONTACT, PO_UDA_PUB.GET_ADDRESS_ATTR_VALUE(PHA.UDA_TEMPLATE_ID, NULL, PHA.PO_HEADER_ID, -1, NULL, NULL, NULL, NULL, 'addresses', NULL, 'addresscode', 'ISSUING_OFFICE', 'DISPLAY_VALUE')ISSUE_OFFICE_CODE, PO_UDA_PUB.GET_ADDRESS_ATTR_VALUE(PHA.UDA_TEMPLATE_ID, NULL, PHA.PO_HEADER_ID, -1, NULL, NULL, NULL, NULL, 'addresses', NULL, 'location', 'ISSUING_OFFICE', 'DISPLAY_VALUE')ISSUE_OFFICE_NAME, PO_DOCUMENT_TOTALS_PVT.getAmountOrdered('HEADER',PHA.PO_HEADER_ID, 'TRANSACTION' , NULL, -1) TOTAL_AMOUNT, PO_PARTIAL_FUNDING_PKG.GET_FUNDED_VALUE('PO', PHA.PO_HEADER_ID) TOTAL_FUNDED_AMOUNT, PO_DOCUMENT_TOTALS_PVT.getAmountBilledForHeader(PHA.PO_HEADER_ID, 'TRANSACTION' , NULL) TOTAL_BILLED_AMOUNT, PO_DOCUMENT_TOTALS_PVT.getAmountDeliveredForHeader(PHA.PO_HEADER_ID, 'TRANSACTION' , NULL) TOTAL_RECEIVED_AMOUNT, (Select flv1.displayed_field FROM po_lookup_codes flv1 WHERE flv1.lookup_type = 'POXMUB_DOCUMENT_TYPE' AND flv1.LOOKUP_CODE = PHA.TYPE_LOOKUP_CODE) DOCUMENT_TYPE_DESC, (Select flv2.displayed_field FROM po_lookup_codes flv2 WHERE flv2.lookup_type = 'AUTHORIZATION STATUS' AND flv2.LOOKUP_CODE = nvl(PHA.AUTHORIZATION_STATUS,'INCOMPLETE')) DOCUMENT_STATUS_DESC FROM PO_HEADERS PHA, po_doc_style_lines_vl PDS, PO_DOC_STYLE_HEADERS pdsh WHERE &doc_iss_off_where AND &doc_num_where AND &doc_date_where AND PDS.STYLE_ID = PHA.STYLE_ID AND PDS.document_subtype = PHA.TYPE_LOOKUP_CODE AND PDSH.STYLE_ID = PHA.STYLE_ID AND PDSH.CLM_FLAG = 'Y' order by pha.clm_issuing_office, pha.clm_document_number PO POXAWDSTA_XML AR PO الإرساءات حسب الموقف Application: المشتريات Source: الإرساءات حسب الموقف Short Name: POXAWDSTA_XML DB package: PO_POXAWDSTA_XMLP_PKG D PO Zuschläge nach Status Application: Einkauf Source: Zuschläge nach Status Short Name: POXAWDSTA_XML DB package: PO_POXAWDSTA_XMLP_PKG F PO Adjudications par statut Application: Purchasing Source: Adjudications par statut Short Name: POXAWDSTA_XML DB package: PO_POXAWDSTA_XMLP_PKG US PO Awards by Status Application: Purchasing Source: Awards by Status Short Name: POXAWDSTA_XML DB package: PO_POXAWDSTA_XMLP_PKG ZHS PO 按状态列出决标 Application: 采购管理系统 Source: 按状态列出决标 Short Name: POXAWDSTA_XML DB package: PO_POXAWDSTA_XMLP_PKG BI Publisher &doc_date_where &doc_iss_off_where &doc_num_where :doc_date_where :doc_iss_off_where :doc_num_where :operating_unit :p_clm_doc_num_from :p_clm_doc_num_to :p_date_from :p_date_to :p_issue_office :t_date_to 1 10 :p_issue_office LOV Oracle PO_CLM_ISS_OFC_LOCATION Y select hrall.location_id id, hrall.location_code value, loceit.lei_information1 description from hr_locations_all hrall,hr_location_extra_info loceit where loceit.location_id=hrall.location_id and loceit.information_type='CLM_OFFICE_CODE' and po_uda_data_util.is_location_valid(hrall.location_id,'ISSUING_OFFICE')='Y' order by value,description AR مكتب الإصدار D Ausstellende Geschäftsstelle F Bureau d'émission US Issue Office ZHS 签发机构 2 20 :p_clm_doc_num_from LOV Oracle PO_CLM_DOCNUM Y select segment1 id, clm_document_number value, null description from po_headers where po_clm_clo_util.getclmstatus()='Y' order by clm_document_number AR رقم المستند من D Von Dokumentnummer F Numéro de document - De US Document Number From ZHS 单据编号自 3 30 :p_clm_doc_num_to LOV Oracle PO_CLM_DOCNUM Y select segment1 id, clm_document_number value, null description from po_headers where po_clm_clo_util.getclmstatus()='Y' order by clm_document_number AR رقم المستند إلى D Bis Dokumentnummer F Numéro de document - A US Document Number To ZHS 单据编号至 4 40 :p_date_from Date AR من تاريخ D Von Datum F Date de début US Date From ZHS 起始日期 5 50 :p_date_to Date AR إلى تاريخ D Bis Datum F Date de fin US Date To ZHS 终止日期