Customer List in Oracle Apps R12.1.3

SELECT hp.party_name Customer_Name
     , hca.account_number Customer_Number
     , hl.address1
     , hl.address2
     , hl.address3
     , hl.city
     , hl.state
     , hl.postal_code ZIP
     , hl.country
FROM   hz_parties hp
     , hz_party_sites hps
     , hz_locations hl
     , hz_cust_accounts_all hca
     , hz_cust_acct_sites_all hcsa
     , hz_cust_site_uses_all hcsu
WHERE  hp.party_id = hps.party_id
AND    hps.location_id = hl.location_id
AND    hp.party_id = hca.party_id
AND    hcsa.party_site_id = hps.party_site_id
AND    hcsu.cust_acct_site_id = hcsa.cust_acct_site_id
AND    hca.cust_account_id = hcsa.cust_account_id
AND    hp.status = 'A'
AND    hps.status = 'A';