--取客户账户层银行账户信息 SQL
SELECT hca.cust_account_id cust_account_id
,hp.party_id party_id --客户ID
,bank.party_id bank_id
,bank.party_name bank_name --银行名称
,branch.party_id branch_id
,branch.party_name bank_branch_name --分行名称
,ieba.bank_account_num bank_account_num
FROM hz_cust_accounts hca
,hz_parties hp
,iby_account_owners iao
,iby_ext_bank_accounts ieba
,hz_parties bank
,hz_parties branch
WHERE hca.party_id = hp.party_id
AND hp.party_id = iao.account_owner_party_id(+)
AND iao.ext_bank_account_id = ieba.ext_bank_account_id(+)
AND ieba.bank_id = bank.party_id(+)
AND ieba.branch_id = branch.party_id(+)
ORDER BY ieba.creation_date;