Customer Site Reference Information - Address & Site Use

SELECT b.party_name,
       a.orig_system_reference AS "Customer REF",
       d.site_use_code,
       d.orig_system_reference AS "Site REF",
       d.primary_flag,
       d.status,
       f.COUNTRY,
       f.ADDRESS1,
       f.ADDRESS2,
       f.ADDRESS3,
       f.ADDRESS4,
       f.CITY,
       f.POSTAL_CODE,
       f.STATE,
       f.PROVINCE
FROM HZ_CUST_ACCOUNTS a,
     HZ_PARTIES b,
     HZ_CUST_ACCT_SITES_ALL c,
     HZ_CUST_SITE_USES_ALL d,
     HZ_PARTY_SITES e,
     HZ_LOCATIONS f
WHERE a.party_id = b.party_id
  AND a.cust_account_id = c.cust_account_id
  AND c.cust_acct_site_id = d.cust_acct_site_id
  AND c.PARTY_SITE_ID = e.PARTY_SITE_ID
  AND e.location_id = f.location_id
  AND upper(party_name) LIKE upper('%computer service and rentals%')
ORDER BY 2, 3;