Query to get Customer Information in R12

select  distinct

        hp.party_name "Customer Name",

        hca.account_number,

        hca.status,

        hcsu.location,

        hcsu.site_use_code,

        hcsu.status loc_stat,

        ps.class,

        hcsu.site_use_id,

        hcpc.name profile_name,

        hl.address1,

        hl.address2,

        hl.address3,

        hl.city,

        hl.state,

        hl.postal_code,

        ps.customer_id,

        ps.customer_site_use_id,

        hps.identifying_address_flag,

        ps.trx_date,

        HOU.NAME "Operating Unit"

from    apps.hz_parties hp,

        apps.hz_party_sites hps,

        apps.hz_locations hl,

        apps.hz_cust_accounts hca,

        apps.hz_cust_acct_sites hcas,

        apps.hz_cust_site_uses hcsu,

        apps.hz_customer_profiles hcp,

        apps.hz_cust_profile_classes hcpc,

        apps.ar_payment_schedules_all ps,

        apps.hr_operating_units hou

where   hp.party_id = hca.party_id(+)

        and hp.party_id = hcp.party_id

        and hp.party_id = hps.party_id

        and hps.party_site_id = hcas.party_site_id

        and hps.location_id = hl.location_id

        and hca.cust_account_id = hcas.cust_account_id

        and hcas.cust_acct_site_id = hcsu.cust_acct_site_id

        and hca.cust_account_id = hcp.cust_account_id

        and hca.cust_account_id = ps.customer_id

        and hcp.profile_class_id = hcpc.profile_class_id

        and ps.customer_site_use_id = hcsu.site_use_id

        and hcsu.org_id = hou.organization_id;