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