Featured post

Functionality of Segment Value Inheritance ESS Process

  The Segment Value Inheritance process simplifies the maintenance of the chart of accounts. When the characteristics of values in the value...

Tuesday 6 September 2022

SQL Query to get the Supplier Contact Address Detail Information

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)
 

By at
Labels: ,

No comments:

Post a Comment

Please review my topic and update your comments

Note: only a member of this blog may post a comment.

Subscribe to: Post Comments (Atom)