AR Customer 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';