FND Design Data [Home] [Help]

Table: MTL_RELATED_ITEMS

Product: INV - Inventory
Description: Item Relationships
Implementation/DBA Data: TableINV.MTL_RELATED_ITEMS
Primary Key: MTL_RELATED_ITEMS_PK
  1. ColumnINVENTORY_ITEM_ID
  2. ColumnRELATED_ITEM_ID
  3. ColumnRELATIONSHIP_TYPE_ID
  4. ColumnORGANIZATION_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
MTL_RELATED_ITEMS FK Joins to TableMTL_SYSTEM_ITEMS_B MTL_RELATED_ITEMS.INVENTORY_ITEM_ID
MTL_RELATED_ITEMS.ORGANIZATION_ID
MTL_RELATED_ITEMS FK Joins to TableMTL_SYSTEM_ITEMS_B MTL_RELATED_ITEMS.RELATED_ITEM_ID
MTL_RELATED_ITEMS.ORGANIZATION_ID
MTL_RELATED_ITEMS FK Joins to TableMTL_PARAMETERS MTL_RELATED_ITEMS.ORGANIZATION_ID
TableQP_LIST_LINES FK Joins to MTL_RELATED_ITEMS QP_LIST_LINES.INVENTORY_ITEM_ID
QP_LIST_LINES.RELATED_ITEM_ID
QP_LIST_LINES.RELATIONSHIP_TYPE_ID
QP_LIST_LINES.ORGANIZATION_ID