FND Design Data [Home] [Help]

Table: MTL_MFG_PART_NUMBERS

Product: INV - Inventory
Description: Define manufacturer part numbers
Implementation/DBA Data: TableINV.MTL_MFG_PART_NUMBERS
Primary Key: MTL_MFG_PART_NUMBERS_PK
  1. ColumnMANUFACTURER_ID
  2. ColumnMFG_PART_NUM
Foreign Keys
Table
Foreign Table Foreign Key Column
MTL_MFG_PART_NUMBERS FK Joins to TableMTL_MANUFACTURERS MTL_MFG_PART_NUMBERS.MANUFACTURER_ID
MTL_MFG_PART_NUMBERS FK Joins to TableMTL_SYSTEM_ITEMS_B MTL_MFG_PART_NUMBERS.INVENTORY_ITEM_ID
MTL_MFG_PART_NUMBERS.ORGANIZATION_ID
MTL_MFG_PART_NUMBERS FK Joins to TableMTL_PARAMETERS MTL_MFG_PART_NUMBERS.ORGANIZATION_ID