Friday, December 14, 2012

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

No comments:

Post a Comment

Best Blogger TipsGet Flower Effect