party_site_id is not stored for site data in HZ_org_contacts
For customer, site contact person information is appearing on form(Customer site details) but when we see in the HZ_ORG_CONTACTS table party_site_id is not stored.
Due to the reason we are unable to get the contact person of the SITEE.
Query
--------
SELECT ' Contact:'||TITLE||FIRST_NAME||' '||LAST_NAME
FROM ar_contacts_v
WHERE contact_number IN( SELECT contact_number
FROM hz_parties party, hz_party_sites partys,
hz_locations loc, hz_org_contacts cont
WHERE party.PARTY_ID = partys.PARTY_ID
AND partys.location_id = loc.location_id
AND partys.party_site_id = cont.party_site_id