PO_XLA_TRANSACTIONS_V

Details

• Schema: FUSION

• Object owner: PO

• Object type: VIEW

Columns

Name
PO_HEADER_ID CURRENT_VERSION_ID POH_TYPE_LOOKUP_CODE PO_NUMBER DOCUMENT_STATUS POH_CURRENCY_CODE DESCRIPTION POH_REFERENCE_NUM SUPPLIER

Query

SQL_Statement

SELECT PO_HEADERS_ALL.PO_HEADER_ID PO_HEADER_ID, PO_HEADERS_ALL.CURRENT_VERSION_ID CURRENT_VERSION_ID, DOC_TYPE.DISPLAYED_FIELD POH_TYPE_LOOKUP_CODE, PO_HEADERS_ALL.SEGMENT1 PO_NUMBER, DOC_STATUS.DISPLAYED_FIELD DOCUMENT_STATUS, PO_HEADERS_ALL.CURRENCY_CODE POH_CURRENCY_CODE, PO_HEADERS_ALL.COMMENTS DESCRIPTION, PO_HEADERS_ALL.REFERENCE_NUM POH_REFERENCE_NUM, PS.vendor_name SUPPLIER FROM PO_HEADERS_ALL PO_HEADERS_ALL, POZ_SUPPLIERS_SIMPLE_V PS, PO_LOOKUP_CODES DOC_STATUS, PO_LOOKUP_CODES DOC_TYPE WHERE PS.vendor_id = PO_HEADERS_ALL.vendor_id AND nvl(PO_HEADERS_ALL.document_status,'INCOMPLETE') = DOC_STATUS.lookup_code AND DOC_STATUS.lookup_type = 'ORDER_STATUS' AND PO_HEADERS_ALL.type_lookup_code = DOC_TYPE.lookup_code AND DOC_TYPE.lookup_type = 'DOCUMENT_SUBTYPE'