Manufacturer Part Numbers (MPNs) are used to uniquely identify parts from specific manufacturers, distinguishing them from internal item numbers. You can use this information for reporting purposes, communicating with the manufacturers using their own part numbers and and in catalog searches for particular items.
We can create a manufacturer part, then assign it to an internal item in the Product Development work area.
Navigation: Product Management > Product Development
Use Create Manufacturer and Create Manufacturer Part task in the Product Development work area to define manufacturers and manufacturer part number (MPNS).
- Define Manufacturer
2. Define Manufacturer Part Number
3. Item Association -> Product Use Manage Item to Query the internal item >
Product Development Work Area > Manage Item > Query for internal >> AML Tab
- Associate the item with the existing Manufacturer Part number (Actions > Select & Add) or associate an item with new manufacturer part number (Actions > Add)
Manage Trade Partner Items in PLM:
Query for Manufacturer Part number
There is no standard UI screen to get item on-hand quantities by manufacturer part numbers (MPNS). Here is the SQL Query to develop the custom report to get on-hand quantities in the specific org by Manufacturer Part Numbers.
SELECT iop.organization_code, MPN.MFG_PART_NUM, hp.party_name Manufacturer,
item.item_number, oh.TRANSACTION_UOM_CODE UOM,
SUM(NVL(oh.transaction_quantity,0)) onhand_qty
FROM egp_system_items_B item,
inv_onhand_quantities_detail oh,
inv_org_parameters iop,
EGP_MFG_PART_NUMBERS MPN, HZ_PARTIES HP
WHERE oh.inventory_item_id = item.inventory_item_id
AND oh.organization_id = item.organization_id
AND iop.organization_id = item.organization_id
and HP.party_id = MPN.MANUFACTURER_ID
and mpn.INVENTORY_ITEM_ID = item.inventory_item_id
AND MPN.MFG_PART_NUM = nvl(:P_MFG_PART_NUM,MPN.MFG_PART_NUM)
and iop.organization_code = :p_org_code
–and mpn.MASTER_ORGANIZATION_ID = item.MASTER_ORG_ID
GROUP BY iop.organization_code, MPN.MFG_PART_NUM, hp.party_name, Item.item_number, oh.TRANSACTION_UOM_CODE
Sample Report output
