Oracle 供应商银行账户查询 

 1 SELECT hp.party_id,
 2        hp.party_number        供应商编号,
 3        hp.party_name          供应商名称,
 4        branch.party_name      分行名称,
 5        branch.status          分行状态,
 6        ieba.bank_id,
 7        ieba.bank_account_num  银行账号,
 8        ieba.bank_account_name 账户名
 9   FROM hz_parties            hp,
10        iby_account_owners    iao,
11        iby_ext_bank_accounts ieba,
12        hz_parties            bank,
13        hz_parties            branch
14  WHERE hp.party_id = iao.account_owner_party_id
15    AND iao.ext_bank_account_id = ieba.ext_bank_account_id
16    AND ieba.bank_id = bank.party_id
17    AND ieba.branch_id = branch.party_id

 

posted @ 2020-09-27 19:50  kiko_0926  阅读(593)  评论(0)  编辑  收藏  举报