R12 Customers Query

SELECT hzp.PARTY_NUMBER customer_number, hzp.party_name customer_name, hzp.party_type,
hzp.address1, hzp.address2, hzp.address3, hzp.address4, hzp.city,
hzp.postal_code, hzp.state, hzp.country, hzp.status,
hzps.party_site_number, hzac.account_number, hzac.account_name,
site.site_use_code
FROM hz_parties hzp,
hz_party_sites hzps,
hz_cust_accounts hzac,
hz_locations hzl,
hz_cust_acct_sites_all acct,
hz_cust_site_uses_all site
WHERE hzp.party_id = hzps.party_id
AND hzp.party_id = hzac.party_id
AND hzps.location_id = hzl.location_id
AND hzps.party_site_id = acct.party_site_id
AND acct.cust_account_id = hzac.cust_account_id
AND acct.cust_acct_site_id = site.cust_acct_site_id