FND Design Data [Home] [Help]

Table: MRP_SUB_INVENTORIES

Product: MRP - Master Scheduling/MRP
Description: Subinventory netting information
Implementation/DBA Data: TableMRP.MRP_SUB_INVENTORIES
Primary Key: MRP_SUB_INVENTORIES_PK
  1. ColumnSUB_INVENTORY_CODE
  2. ColumnORGANIZATION_ID
  3. ColumnCOMPILE_DESIGNATOR
Foreign Keys
Table
Foreign Table Foreign Key Column
MRP_SUB_INVENTORIES FK Joins to TableMTL_SECONDARY_INVENTORIES MRP_SUB_INVENTORIES.SUB_INVENTORY_CODE
MRP_SUB_INVENTORIES.ORGANIZATION_ID
TableMRP_INVENTORY_LOTS FK Joins to MRP_SUB_INVENTORIES MRP_INVENTORY_LOTS.LOT_SUB_INVENTORY_CODE
MRP_INVENTORY_LOTS.ORGANIZATION_ID
MRP_INVENTORY_LOTS.COMPILE_DESIGNATOR
TableMRP_RESERVATIONS FK Joins to MRP_SUB_INVENTORIES MRP_RESERVATIONS.SUBINVENTORY
MRP_RESERVATIONS.ORGANIZATION_ID
MRP_RESERVATIONS.COMPILE_DESIGNATOR