VIEW: APPS.CEBV_BANK_ACCOUNTS

Source

View Text - Preformatted

SELECT ACC.BANK_ACCOUNT_ID , ACC.BANK_ACCOUNT_NAME , ACC.BANK_ACCOUNT_NAME_ALT , ACC.BANK_ACCOUNT_NUM , ACC.BANK_ACCOUNT_TYPE , 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 , 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 , 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 , TO_DATE(NULL) , TO_NUMBER(NULL) , TO_DATE(NULL) , TO_NUMBER(NULL) FROM IBY_EXT_BANK_ACCOUNTS_V ACE WITH READ ONLY

View Text - HTML Formatted

SELECT ACC.BANK_ACCOUNT_ID
, ACC.BANK_ACCOUNT_NAME
, ACC.BANK_ACCOUNT_NAME_ALT
, ACC.BANK_ACCOUNT_NUM
, ACC.BANK_ACCOUNT_TYPE
, 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
, 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
, 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
, TO_DATE(NULL)
, TO_NUMBER(NULL)
, TO_DATE(NULL)
, TO_NUMBER(NULL)
FROM IBY_EXT_BANK_ACCOUNTS_V ACE WITH READ ONLY