POS_SUPPLIER_MAPPINGS

POS_SUPPLIER_MAPPINGS table holds the mapping between the AP_SUPPLIERS.VENDOR_ID and HZ_PARTIES.PARTY_ID. This is useful in case of two vendors effectively belong to the same HZ_PARTY Record.

SELECT psm.* 

  FROM pos_supplier_mappings  psm

 WHERE psm.party_id = 123456

IBY_EXTERNAL_PAYEES_ALL

This table captures Payment related details of the Supplier. For Example: The Supplier's remittance advice, the default Payment method Code for this supplier or the bank charges in case of SWIFT payments, etc. This information can be setup at Supplier Level or  Supplier Site Level.

SELECT iepa.* 

  FROM iby_external_payees_all iepa 

 WHERE iepa.payee_party_id = 123456

HZ_ORGANIZATION_PROFILES

This table captures additional Supplier information.

Examples are like credit scoring details of Supplier or the No. of Employees working in Supplier Organization.

SELECT hop.* 

  FROM hz_organization_profiles hop

 WHERE hop.party_id = 123456

HZ_PARTY_USG_ASSIGNMENTS

This table stores the Party Usages, for example, party_id of the type SUPPLIER.

SELECT party_id 

      ,party_usg_assignment_id

  ,party_usage_code 

  FROM hz_party_usg_assignments 

 WHERE party_id = 123456;