TO GET THE CONTACT PERSONS IN AR(CUSTOMER STANDARD)
--------------------------------

SELECT DISTINCT
--CUST.cust_account_id CUSTOMER_ID,
CUST.ACCOUNT_NUMBER CUSTOMER_NUMBER,
PARTY.PARTY_NAME,
loc.ADDRESS1, loc.ADDRESS2, loc.ADDRESS3, loc.ADDRESS4, loc.CITY,
loc.POSTAL_CODE, loc.STATE,loc.COUNTY, --HCP.EMAIL_ADDRESS,
RAA.SITE_NUMBER, --RAA.ADDRESS_ID,ship.CUST_ACCT_SITE_ID,
RAC.LAST_NAME,
RAC.EMAIL_ADDRESS
FROM hz_cust_accounts cust,
APPS.hz_cust_acct_sites_all acct,
APPS.hz_cust_site_uses_all ship,
APPS.hz_party_sites party_site,
APPS.hz_locations loc,
APPS.hz_parties party,
APPS.HZ_CONTACT_POINTS HCP,
APPS.RA_ADDRESSES_ALL RAA,
APPS.RA_CONTACTS RAC
WHERE cust.cust_account_id = acct.cust_account_id
AND acct.cust_acct_site_id = ship.cust_acct_site_id
AND acct.org_id = ship.org_id
AND cust.status = 'A'
and ship.SITE_USE_CODE ='BILL_TO'
AND loc.location_id = party_site.location_id
AND acct.party_site_id = party_site.party_site_id
AND cust.party_id = party.party_id
--AND RAC.CUSTOMER_ID = cust.CUST_ACCOUNT_ID
AND RAC.ADDRESS_ID = RAA.ADDRESS_ID
AND HCP.OWNER_TABLE_NAME(+) = 'HZ_PARTIES'
 AND HCP.PRIMARY_FLAG(+) = 'Y'
 AND HCP.CONTACT_POINT_TYPE(+) = 'EMAIL'
 AND HCP.OWNER_TABLE_ID(+) = PARTY.PARTY_ID
 AND RAA.PARTY_ID = PARTY.PARTY_ID
 AND ship.CUST_ACCT_SITE_ID = RAA.ADDRESS_ID
--AND CUST.ACCOUNT_NUMBER = 'SN000014'


SELECT * FROM APPS.RA_CONTACTS