VIEW: APPS.CE_INTERNAL_BANK_ACCOUNTS_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'