供应商银行信息代码,OracleEBS代码库,德仔网

代码语言

代码分类

【OracleEBS】供应商银行信息

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

SELECT ass.vendor_id         vendor_id,
       ass.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 ap_suppliers          ass,
       hz_parties            hp,
       iby_account_owners    iao,
       iby_ext_bank_accounts ieba,
       hz_parties            bank,
       hz_parties            branch
  WHERE ass.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)