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;