FND Design Data [Home] [Help]

Table: MTL_ITEM_SUB_INVENTORIES

Product: INV - Inventory
Description: Item-subinventory assignments
Implementation/DBA Data: TableINV.MTL_ITEM_SUB_INVENTORIES
Primary Key: MTL_ITEM_SUB_INVENTORIES_PK
  1. ColumnINVENTORY_ITEM_ID
  2. ColumnORGANIZATION_ID
  3. ColumnSECONDARY_INVENTORY
Foreign Keys
Table
Foreign Table Foreign Key Column
MTL_ITEM_SUB_INVENTORIES FK Joins to TableMTL_SECONDARY_INVENTORIES MTL_ITEM_SUB_INVENTORIES.SECONDARY_INVENTORY
MTL_ITEM_SUB_INVENTORIES.ORGANIZATION_ID
MTL_ITEM_SUB_INVENTORIES FK Joins to TableMTL_SYSTEM_ITEMS_B MTL_ITEM_SUB_INVENTORIES.INVENTORY_ITEM_ID
MTL_ITEM_SUB_INVENTORIES.ORGANIZATION_ID
MTL_ITEM_SUB_INVENTORIES FK Joins to TableMTL_SECONDARY_INVENTORIES MTL_ITEM_SUB_INVENTORIES.SOURCE_SUBINVENTORY
MTL_ITEM_SUB_INVENTORIES.SOURCE_ORGANIZATION_ID
MTL_ITEM_SUB_INVENTORIES FK Joins to TableMTL_PARAMETERS MTL_ITEM_SUB_INVENTORIES.SOURCE_ORGANIZATION_ID
TableMTL_SECONDARY_LOCATORS FK Joins to MTL_ITEM_SUB_INVENTORIES MTL_SECONDARY_LOCATORS.INVENTORY_ITEM_ID
MTL_SECONDARY_LOCATORS.ORGANIZATION_ID
MTL_SECONDARY_LOCATORS.SUBINVENTORY_CODE
TableWIP_DISCRETE_JOBS FK Joins to MTL_ITEM_SUB_INVENTORIES WIP_DISCRETE_JOBS.PRIMARY_ITEM_ID
WIP_DISCRETE_JOBS.ORGANIZATION_ID
WIP_DISCRETE_JOBS.COMPLETION_SUBINVENTORY
TableWIP_FLOW_SCHEDULES FK Joins to MTL_ITEM_SUB_INVENTORIES WIP_FLOW_SCHEDULES.PRIMARY_ITEM_ID
WIP_FLOW_SCHEDULES.ORGANIZATION_ID
WIP_FLOW_SCHEDULES.COMPLETION_SUBINVENTORY
TableWIP_REPETITIVE_ITEMS FK Joins to MTL_ITEM_SUB_INVENTORIES WIP_REPETITIVE_ITEMS.PRIMARY_ITEM_ID
WIP_REPETITIVE_ITEMS.ORGANIZATION_ID
WIP_REPETITIVE_ITEMS.COMPLETION_SUBINVENTORY
TableWIP_REQUIREMENT_OPERATIONS FK Joins to MTL_ITEM_SUB_INVENTORIES WIP_REQUIREMENT_OPERATIONS.INVENTORY_ITEM_ID
WIP_REQUIREMENT_OPERATIONS.ORGANIZATION_ID
WIP_REQUIREMENT_OPERATIONS.SUPPLY_SUBINVENTORY