Receivables - EBS (MOSC)

MOSC Banner

party_site_id is not stored for site data in HZ_org_contacts

edited Sep 7, 2015 3:57AM in Receivables - EBS (MOSC) Question

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center