FND Design Data [Home] [Help]

Table: MTL_ITEM_SUB_DEFAULTS

Product: INV - Inventory
Description: Inventory item receiving and shipping subinventory default values
Implementation/DBA Data: TableINV.MTL_ITEM_SUB_DEFAULTS
Primary Key: MTL_ITEM_SUB_DEFAULTS_PK
  1. ColumnINVENTORY_ITEM_ID
  2. ColumnORGANIZATION_ID
  3. ColumnSUBINVENTORY_CODE
  4. ColumnDEFAULT_TYPE
Foreign Keys
Table
Foreign Table Foreign Key Column
MTL_ITEM_SUB_DEFAULTS FK Joins to TableMTL_SYSTEM_ITEMS_B MTL_ITEM_SUB_DEFAULTS.INVENTORY_ITEM_ID
MTL_ITEM_SUB_DEFAULTS.ORGANIZATION_ID
MTL_ITEM_SUB_DEFAULTS FK Joins to TableMTL_SECONDARY_INVENTORIES MTL_ITEM_SUB_DEFAULTS.SUBINVENTORY_CODE
MTL_ITEM_SUB_DEFAULTS.ORGANIZATION_ID