VIEW: APPS.CE_CP_XTR_BANK_ACCOUNTS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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