View: CE_INTERNAL_BANK_ACCOUNTS_V

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

View Text

SELECT BA.BANK_ACCOUNT_ID
, BA.BANK_ACCOUNT_NAME
, BA.BANK_ACCOUNT_NUM
, BA.CURRENCY_CODE
, BA.MULTI_CURRENCY_ALLOWED_FLAG
, BA.ASSET_CODE_COMBINATION_ID
, BB.BANK_NAME
, BB.BANK_BRANCH_NAME
, BA.BANK_BRANCH_ID
, BA.BANK_ACCOUNT_NUM||'
, '||BA.BANK_ACCOUNT_NAME BANK_ACCOUNT_NUM_NAME
, BA.END_DATE
, BA.CHECK_DIGITS
, BB.END_DATE
, CL.MEANING
FROM CE_BANK_BRANCHES_V BB
, CE_BANK_ACCOUNTS_V BA
, CE_LOOKUPS CL
WHERE BA.BANK_BRANCH_ID = BB.BRANCH_PARTY_ID
AND CL.LOOKUP_TYPE = 'ACCOUNT_CLASSIFICATION'
AND CL.LOOKUP_CODE = 'INTERNAL'

Columns