CE_XLA_EXT_TRX_V

Details

• Schema: FUSION

• Object owner: CE

• Object type: VIEW

Columns

Name
EXT_TRANSACTION_ID EXT_BANK_ACCOUNT_NAME EXT_CURRENCY_CODE EXT_RECON_REFERENCE EXT_CLEARED_AMOUNT EXT_TRX_DATE EXT_TRX_TYPE EXT_SOURCE EXT_BUSINESS_UNIT

Query

SQL_Statement

select ext.transaction_id ext_transaction_id, ba.bank_account_name ext_bank_account_name, ext.currency_code ext_currency_code, ext.reference_text ext_recon_reference, ext.amount ext_cleared_amount, ext.transaction_date ext_trx_date, type_lookup.meaning ext_trx_type, source_lookup.meaning ext_source, bu.bu_name ext_business_unit from ce_external_transactions ext, ce_bank_accounts ba, fun_organizations_v bu, ce_lookups type_lookup, ce_lookups source_lookup where ext.bank_account_id = ba.bank_account_id and bu.bu_id(+) = ext.business_unit_id and type_lookup.lookup_code(+) = ext.transaction_type and type_lookup.lookup_type(+) = 'CE_TRX_TYPE' and source_lookup.lookup_code(+) = ext.source and source_lookup.lookup_type (+) = 'CE_EXT_TRANSACTION_SOURCE'