ZX_ACCT_PURCH_EXT_HEADER_V

Details

• Schema: FUSION

• Object owner: ZX

• Object type: VIEW

Columns

Name
EVENT_ID ACCOUNTING_DATE BATCH_SOURCE_ID BATCH_SOURCE_NAME BATCH_SOURCE_SEQ_ID DOC_SEQ_ID DOC_SEQ_NAME DOC_SEQ_VALUE DOCUMENT_TYPE ENTITY_CODE EVENT_CLASS_CODE LEDGER_ID LEGAL_ENTITY_ID THIRD_PTY_REG_ID THIRD_PTY_ACCT_ID THIRD_PTY_ACCT_SITE_ID PARTY_TYPE TRX_CURRENCY_CODE TRX_DATE TRX_DESCRIPTION TRX_ID TRX_NUMBER INTERNAL_ORGANIZATION_ID BU_NAME LEGAL_ENTITY_NAME

Query

SQL_Statement

( select XlaEvent.EVENT_ID, ZxAcctTrxV.ACCOUNTING_DATE, ZxAcctTrxV.BATCH_SOURCE_ID, ZxAcctTrxV.BATCH_SOURCE_NAME, ZxAcctTrxV.BATCH_SOURCE_SEQ_ID, ZxAcctTrxV.DOC_SEQ_ID, ZxAcctTrxV.DOC_SEQ_NAME, ZxAcctTrxV.DOC_SEQ_VALUE, ZxAcctTrxV.DOCUMENT_TYPE, ZxAcctTrxV.ENTITY_CODE, ZxAcctTrxV.EVENT_CLASS_CODE, ZxAcctTrxV.LEDGER_ID, ZxAcctTrxV.LEGAL_ENTITY_ID, ZxAcctTrxV.THIRD_PTY_REG_ID, NVL(ZxAcctTrxV.BILL_THIRD_PTY_ACCT_ID , ZxAcctTrxV.SHIP_THIRD_PTY_ACCT_ID) AS THIRD_PTY_ACCT_ID, NVL(ZxAcctTrxV.BILL_THIRD_PTY_ACCT_SITE_ID , ZxAcctTrxV.SHIP_THIRD_PTY_ACCT_SITE_ID) AS THIRD_PTY_ACCT_SITE_ID, ZxAcctTrxV.PARTY_TYPE, ZxAcctTrxV.TRX_CURRENCY_CODE, ZxAcctTrxV.TRX_DATE, ZxAcctTrxV.TRX_DESCRIPTION, ZxAcctTrxV.TRX_ID, ZxAcctTrxV.TRX_NUMBER, ZxAcctTrxV.INTERNAL_ORGANIZATION_ID, bu.bu_name, xle.name LEGAL_ENTITY_NAME from zx_acct_transactions_v ZxAcctTrxV, xla_events XlaEvent, xla_transaction_entities XlaTransEnt, fun_all_business_units_v bu, xle_entity_profiles xle where ZxAcctTrxV.tax_event_class_code = 'PURCHASE_TRANSACTION' AND XlaTransEnt.source_id_int_1 = ZxAcctTrxV.trx_id AND XlaTransEnt.entity_id = XlaEvent.entity_id AND bu.bu_id (+) = ZxAcctTrxV.INTERNAL_ORGANIZATION_ID AND xle.legal_entity_id = ZxAcctTrxV.LEGAL_ENTITY_ID AND (ZxAcctTrxV.application_id = 235) UNION select XlaEvent.EVENT_ID, XlaEvent.EVENT_DATE, ZxAcctTrxV.BATCH_SOURCE_ID, ZxAcctTrxV.BATCH_SOURCE_NAME, ZxAcctTrxV.BATCH_SOURCE_SEQ_ID, ZxAcctTrxV.DOC_SEQ_ID, ZxAcctTrxV.DOC_SEQ_NAME, ZxAcctTrxV.DOC_SEQ_VALUE, ZxAcctTrxV.DOCUMENT_TYPE, ZxAcctTrxV.ENTITY_CODE, ZxAcctTrxV.EVENT_CLASS_CODE, ZxAcctTrxV.LEDGER_ID, ZxAcctTrxV.LEGAL_ENTITY_ID, ZxAcctTrxV.THIRD_PTY_REG_ID, NVL(ZxAcctTrxV.BILL_THIRD_PTY_ACCT_ID , ZxAcctTrxV.SHIP_THIRD_PTY_ACCT_ID) AS THIRD_PTY_ACCT_ID, NVL(ZxAcctTrxV.BILL_THIRD_PTY_ACCT_SITE_ID , ZxAcctTrxV.SHIP_THIRD_PTY_ACCT_SITE_ID) AS THIRD_PTY_ACCT_SITE_ID, ZxAcctTrxV.PARTY_TYPE, ZxAcctTrxV.TRX_CURRENCY_CODE, ZxAcctTrxV.TRX_DATE, ZxAcctTrxV.TRX_DESCRIPTION, ZxAcctTrxV.TRX_ID, ZxAcctTrxV.TRX_NUMBER, ZxAcctTrxV.INTERNAL_ORGANIZATION_ID, bu.bu_name, xle.name LEGAL_ENTITY_NAME from zx_acct_transactions_v ZxAcctTrxV, xla_events XlaEvent, xla_transaction_entities XlaTransEnt, fun_all_business_units_v bu, xle_entity_profiles xle where ZxAcctTrxV.tax_event_class_code = 'PURCHASE_TRANSACTION' AND XlaTransEnt.source_id_int_1 = ZxAcctTrxV.trx_id AND XlaTransEnt.entity_id = XlaEvent.entity_id AND bu.bu_id (+) = ZxAcctTrxV.INTERNAL_ORGANIZATION_ID AND xle.legal_entity_id = ZxAcctTrxV.LEGAL_ENTITY_ID AND (ZxAcctTrxV.application_id = 200) )