客户账户层银行账户信息 SQL代码,OracleEBS代码库,德仔网

代码语言

代码分类

【OracleEBS】客户账户层银行账户信息 SQL

作者:Dezai.CN / 发布于2012/12/5/ 821

-- 客户账户层银行账户信息 SQL
SELECT hca.cust_account_id   cust_account_id,
       hp.party_id           party_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;

试试其它关键字

　客户账户层银行账户信息　

同语言下

可能有用的

Dezai.CN贡献的其它代码(4037)