Here are the tables that we can refer supplier Information.
Suppliers - POZ_SUPPLIERS
Contacts - HZ_PARTIES
Addresses - HZ_PARTY_SITES
Contact Addresses - POZ_SUPPLIER_CONTACTS (Join to HZ_PARTIES on per_party_id - POZ_SUPPLIER_CONTACTS.PER_PARTY_ID = HZ_PARTIES.PARTY_ID )
(Join to HZ_PARTY_SITES on party_site_id - POZ_SUPPLIER_CONTACTS.PARTY_SITE_ID = HZ_PARTY_SITES.PARTY_SITE_ID)
No comments:
Post a Comment
Please review my topic and update your comments
Note: only a member of this blog may post a comment.