We'd love to hear from you! Provide  feedback  to earn a badge today. Take our quick survey
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Relationship between item table and trading partner table

Received Response
18
Views
1
Comments
edited Feb 10, 2020 5:38AM in Inventory Management 1 comment

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

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!