View: CEFV_BANK_ACCOUNTS

Product:	CE - Cash Management
Description:	Business view
Implementation/DBA Data:	APPS.CEFV_BANK_ACCOUNTS

View Text

SELECT ACC.BANK_ACCOUNT_ID
, ACC.BANK_ACCOUNT_NAME
, ACC.BANK_ACCOUNT_NAME_ALT
, ACC.BANK_ACCOUNT_NUM
, ACC.BANK_ACCOUNT_TYPE
, 'INTERNAL'
, ACC.MULTI_CURRENCY_ALLOWED_FLAG
, ACC.POOLED_FLAG
, ACC.DESCRIPTION
, ACC.MAX_OUTLAY
, ACC.MIN_CHECK_AMOUNT
, ACC.MAX_CHECK_AMOUNT
, ACC.ZERO_AMOUNT_ALLOWED
, TO_CHAR(NULL)
, TO_CHAR(NULL)
, TO_CHAR(NULL)
, TO_CHAR(NULL)
, TO_CHAR(NULL)
, TO_CHAR(NULL)
, TO_CHAR(NULL)
, ACC.END_DATE
, ACC.ACCOUNT_HOLDER_NAME
, ACC.ACCOUNT_HOLDER_NAME_ALT
, ACC.EFT_USER_NUM
, ACC.BANK_BRANCH_ID
, ACC.CURRENCY_CODE
, '_DF:CE:CE_BANK_ACCOUNTS:ACC'
, ACC.CREATION_DATE
, ACC.CREATED_BY
, ACC.LAST_UPDATE_DATE
, ACC.LAST_UPDATED_BY
FROM CE_BANK_ACCOUNTS ACC UNION ALL SELECT ACE.EXT_BANK_ACCOUNT_ID
, ACE.BANK_ACCOUNT_NAME
, ACE.ALTERNATE_ACCOUNT_NAME
, ACE.BANK_ACCOUNT_NUMBER
, ACE.BANK_ACCOUNT_TYPE
, 'EXTERNAL'
, ACE.MULTI_CURRENCY_ALLOWED_FLAG
, TO_CHAR(NULL)
, ACE.DESCRIPTION
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_CHAR(NULL)
, TO_CHAR(NULL)
, TO_CHAR(NULL)
, TO_CHAR(NULL)
, TO_CHAR(NULL)
, TO_CHAR(NULL)
, TO_CHAR(NULL)
, TO_CHAR(NULL)
, ACE.END_DATE
, TO_CHAR(NULL)
, TO_CHAR(NULL)
, TO_CHAR(NULL)
, ACE.BRANCH_PARTY_ID
, ACE.CURRENCY_CODE
, '_DF:IBY:IBY_EXT_BANK_ACCOUNTS:ACE'
, TO_DATE(NULL)
, TO_NUMBER(NULL)
, TO_DATE(NULL)
, TO_NUMBER(NULL)
FROM IBY_EXT_BANK_ACCOUNTS_V ACE WITH READ ONLY

Columns