Relationship between item table and trading partner table

Summary

linking table for trading partner_id and inventory_item_id

Content

We have the item created in the system and added the manufacturer and manufacturer part number under trading partner items tab of item. However we are not able to retrieve the information via sql query

Item information : egp_system_items_b, egp_system_items_tl

Manufacturer part number table : EGP_TRADING_PARTNER_ITEMS

Manufacturer table : select party_id,party_name from fusion.hz_parties where party_id in (select party_id 
 from fusion.HZ_PARTY_USG_ASSIGNMENTS where PARTY_USAGE_CODE = 'MANUFACTURER');

Party Id is nothing but trading_partner_id from egp_trading partner_items