SQL to fetch Contact information from Procurement -> Suppliers -> Addresses level
We need SQL to fetch Contact information from Procurement -> Suppliers -> Addresses level
We tried 2 options - with POZ_SUPPLIER_CONTACTS and (hz_parties, hz_relationships) tables but when a contact is deleted from Addresses level, the link is still appearing in these tables. Is there any option where this contact can be fetched real-time
0