View: CE_CP_BANK_ACCOUNTS_V

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

View Text

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

Columns