R12 HZ_RELATIONSHIPS seems not be updated after delete AR contact
Hi everyone.
I'm currently trying to obtain list of email for customers.
Email are defined at several levels.
(besides, if someone has a ready-made sql, I 'm interested. The data model is particularly complex with the TCA
On BILL_TO site (for example), you have the choice between create an email on "communication" tab, or create a contact, that he has an email too.
In my request, i use hz_contact_points and hz_relationships to link BILL_TO site with created contact.
In my differents tests, i created 2 contacts on one BILL_TO site. My request brings me 2 lines, with contacts informations => that's correct.