VIEW: APPS.CE_BANK_TRX_CODES_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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