1. Tables and Views for Financials
  2. CE_INTERNAL_BANK_ACCOUNTS_V

CE_INTERNAL_BANK_ACCOUNTS_V

Details

  • Schema: FUSION

  • Object owner: CE

  • Object type: VIEW

Query

SQL_Statement

SELECT

BA.BANK_ACCOUNT_ID,

BA.BANK_ACCOUNT_NAME,

BA.BANK_ACCOUNT_NUM,

BA.CURRENCY_CODE,

BA.MULTI_CURRENCY_ALLOWED_FLAG MULTI_CURRENCY_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 INACTIVE_DATE,

BA.CHECK_DIGITS,

BB.END_DATE BRANCH_END_DATE,

cl.MEANING ACCOUNT_TYPE

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'