Featured post

General Ledger Revaluation

General Ledger Revaluation Account balances denominated in foreign currencies are adjusted through the revaluation procedure. Revaluat...

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)
 

No comments:

Post a Comment

Please review my topic and update your comments

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