FND Design Data [Home] [Help]

Table: MTL_PHYSICAL_SUBINVENTORIES

Product: INV - Inventory
Description: Physical inventory specific subinventories
Implementation/DBA Data: TableINV.MTL_PHYSICAL_SUBINVENTORIES
Primary Key: MTL_PHYSICAL_SUBINVENTORIES_PK
  1. ColumnORGANIZATION_ID
  2. ColumnPHYSICAL_INVENTORY_ID
  3. ColumnSUBINVENTORY
Foreign Keys
Table
Foreign Table Foreign Key Column
MTL_PHYSICAL_SUBINVENTORIES FK Joins to TableMTL_PHYSICAL_INVENTORIES MTL_PHYSICAL_SUBINVENTORIES.ORGANIZATION_ID
MTL_PHYSICAL_SUBINVENTORIES.PHYSICAL_INVENTORY_ID
MTL_PHYSICAL_SUBINVENTORIES FK Joins to TableMTL_SECONDARY_INVENTORIES MTL_PHYSICAL_SUBINVENTORIES.SUBINVENTORY
MTL_PHYSICAL_SUBINVENTORIES.ORGANIZATION_ID
MTL_PHYSICAL_SUBINVENTORIES FK Joins to TableMTL_PARAMETERS MTL_PHYSICAL_SUBINVENTORIES.ORGANIZATION_ID