AR Customer list Query

Query:

SELECT rc.customer_number,
       rc.CUSTOMER_NAME,
       hp.party_id,
       hp.party_type,
       rc.TAX_REFERENCE,
       hca.cust_account_id,
       hca.PAYMENT_TERM_ID,
       hps.location_id,
       hcsu.location,
       hcsu.site_use_code,
       hcsa.bill_to_flag,
       hcsu.GL_ID_REC Receiving_acc_ccid,
       hl.address1,
       hl.address2,
       hl.address3,
       hl.city,
       hl.state,
       hl.country,
       hl.postal_code
  FROM ra_customers rc,
       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     rc.party_id = hp.party_id
       AND 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 rc.customer_number = '&Customer_Number';