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

--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