FND Design Data [Home] [Help]

Table: MTL_CUSTOMER_ITEM_XREFS

Product: INV - Inventory
Description: Relationships between customer items and inventory items
Implementation/DBA Data: TableINV.MTL_CUSTOMER_ITEM_XREFS
Primary Key: MTL_CUSTOMER_ITEM_XREFS_PK
  1. ColumnCUSTOMER_ITEM_ID
  2. ColumnINVENTORY_ITEM_ID
  3. ColumnMASTER_ORGANIZATION_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
MTL_CUSTOMER_ITEM_XREFS FK Joins to TableMTL_PARAMETERS MTL_CUSTOMER_ITEM_XREFS.MASTER_ORGANIZATION_ID
MTL_CUSTOMER_ITEM_XREFS FK Joins to TableMTL_SYSTEM_ITEMS_B MTL_CUSTOMER_ITEM_XREFS.INVENTORY_ITEM_ID
MTL_CUSTOMER_ITEM_XREFS.MASTER_ORGANIZATION_ID
MTL_CUSTOMER_ITEM_XREFS FK Joins to TableMTL_CUSTOMER_ITEMS MTL_CUSTOMER_ITEM_XREFS.CUSTOMER_ITEM_ID