取客户账户层银行账户信息

--取客户账户层银行账户信息 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;