Not able to get AR Customer contact information in case of multiple sites
Summary:
I am trying to fetch AR Customer contact information which is displayed on Oracle Fusion screen. In case of multiple sites with each site having it's each contact person, I am getting cross joins between tables and not able to fetch the correct data. These type of customers do not have data in HZ_CONTACT_POINTS table for their corresponding sites. Hence, I am finding no way to join the contact person with the individual site.
With below query, in case of multiple sites with each site having it's individual contact person, I am data with cross join
SELECT hp.party_name
Tagged:
0