View: CE_CP_XTR_BANK_ACCOUNTS_V

Product:	CE - Cash Management
Description:	Bank accounts for treasury users
Implementation/DBA Data:	APPS.CE_CP_XTR_BANK_ACCOUNTS_V

View Text

SELECT CBA.BANK_ACCOUNT_ID
, CBA.BANK_ACCOUNT_NUM
, NULL
, CBA.BANK_ACCOUNT_NAME
, CBA.BANK_ACCOUNT_NAME_ALT
, CBB.BANK_NAME
, CBA.CURRENCY_CODE
, CBA.ACCOUNT_OWNER_ORG_ID
, XFP.NAME
, NULL
, NULL
, CBA.END_DATE FROM CE_BANK_ACCTS_GT_V CBA
, CE_BANK_BRANCHES_V CBB
, XLE_ENTITY_PROFILES XFP
WHERE CBA.ACCOUNT_CLASSIFICATION IN('INTERNAL'
, 'SUBSIDIARY') AND NVL(CBA.END_DATE
, SYSDATE) >= SYSDATE AND CBA.BANK_BRANCH_ID = CBB.BRANCH_PARTY_ID
AND XFP.LEGAL_ENTITY_ID = CBA.ACCOUNT_OWNER_ORG_ID

Columns