View: CE_BANK_TRX_CODES_V

Product:	CE - Cash Management
Description:	- Retrofitted
Implementation/DBA Data:	APPS.CE_BANK_TRX_CODES_V

View Text

SELECT TC.ROWID ROW_ID
, TC.TRX_CODE TRX_CODE
, TC.DESCRIPTION DESCRIPTION
, CBL.MEANING TRX_TYPE_DSP
, BB.BANK_NAME BANK_NAME
, BB.BANK_BRANCH_NAME BANK_BRANCH_NAME
, SYS.SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, BA.CURRENCY_CODE CURRENCY_CODE
, BA.BANK_ACCOUNT_NAME BANK_ACCOUNT_NAME
, BA.BANK_ACCOUNT_NUM BANK_ACCOUNT_NUM FROM CE_BANK_BRANCHES_V BB
, CE_BANK_ACCOUNTS_V BA
, CE_SYSTEM_PARAMETERS SYS
, CE_LOOKUPS CBL
, CE_TRANSACTION_CODES TC
WHERE BB.BRANCH_PARTY_ID = BA.BANK_BRANCH_ID
AND BA.BANK_ACCOUNT_ID = TC.BANK_ACCOUNT_ID
AND BA.ACCOUNT_OWNER_ORG_ID = SYS.LEGAL_ENTITY_ID (+) AND CBL.LOOKUP_TYPE = 'BANK_TRX_TYPE'
AND CBL.LOOKUP_CODE = TC.TRX_TYPE

Columns