客户信息表 自我汇总 待确认

--BILL TO 和SHIP TO
select *
  from hz_parties             hz,
       hz_cust_accounts       hca,
       hz_cust_acct_sites_all acct_site,
       hz_cust_site_uses_all  site_uses
 where hz.party_id = hca.party_id
   and hca.cust_account_id = acct_site.cust_account_id
   and acct_site.cust_acct_site_id = site_uses.cust_acct_site_id
   and hz.party_id=29562  --客户ID 
and acct_site.org_id = 83 --ORG

 

--客户银行
select *
  from iby_external_payers_all iepa,
       iby_pmt_instr_uses_all  ipiua,
       iby_ext_bank_accounts   ibybanks
 where iepa.acct_site_use_id(+) in (39935, 48125)--hz_cust_site_uses_all.site_use_id
   AND iepa.payment_function(+) = 'CUSTOMER_PAYMENT'
   AND ipiua.instrument_type(+) = 'BANKACCOUNT'
   AND ipiua.ext_pmt_party_id(+) = iepa.ext_payer_id
   AND ipiua.payment_function(+) = 'CUSTOMER_PAYMENT'
   AND ibybanks.ext_bank_account_id(+) = ipiua.instrument_id

 

转载于:https://www.cnblogs.com/toowang/p/3615753.html