Query : Bank | Branch | Account

Bank:  CE_INDEX_BANKS
Branch:  CE_INDEX_BANK_BRANCHES
Account:  CE_BANK_ACCOUNTS


______



SELECT
BANK.BANK_PARTY_ID,
BANK.BANK_NAME,
BRANCH.PARTY_ID,
BRANCH.BANK_PARTY_ID,
BRANCH.BANK_BRANCH_NAME,
BRANCH.BRANCH_NUMBER,
ACCOUNT.BANK_ACCOUNT_ID,
ACCOUNT.BANK_ACCOUNT_NAME,
ACCOUNT.BANK_BRANCH_ID
ACCOUNT.BANK_ID

FROM
CE_INDEX_BANKS BANK,
CE_INDEX_BANK_BRANCHES BRANCH,
CE_BANK_ACCOUNTS, ACCOUNT

WHERE
BANK.BANK_PARTY_ID = BRANCH.BANK_PARTY_ID
BANK.BANK_PARTY_ID = ACCOUNT.BANK_ID
BRANCH.BRANCH_PARTY_ID = ACCOUNT.BANK_BRANCH_ID