获取客户信息SQL

/*取客户信息SQL*/
--客户信息
SELECT hou.name 业务实体,
       hca.account_number 客户编号,
       hp.party_name 客户名称,
       arp_addr_pkg.format_address(hl.address_style,
                                   hl.address1,
                                   hl.address2,
                                   hl.address3,
                                   hl.address4,
                                   hl.city,
                                   hl.county,
                                   hl.state,
                                   hl.province,
                                   hl.postal_code,
                                   ftv.territory_short_name) 地址,
       flv.meaning 用途,
       gcc_rec.concatenated_segments 应收帐户,
       gcc_rev.concatenated_segments 收入帐户
  FROM hz_parties               hp,
       hz_party_sites           hps,
       hz_locations             hl,
       hz_cust_accounts         hca,
       hz_cust_acct_sites_all   hcas,
       hz_cust_site_uses_all