FND Design Data [Home] [Help]

Table: MRP_ITEM_WIP_ENTITIES

Product: MRP - Master Scheduling/MRP
Description: Discrete jobs
Implementation/DBA Data: TableMRP.MRP_ITEM_WIP_ENTITIES
Primary Key: MRP_ITEM_WIP_ENTITIES_PK
  1. ColumnINVENTORY_ITEM_ID
  2. ColumnORGANIZATION_ID
  3. ColumnCOMPILE_DESIGNATOR
  4. ColumnWIP_ENTITY_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
MRP_ITEM_WIP_ENTITIES FK Joins to TableWIP_ENTITIES MRP_ITEM_WIP_ENTITIES.WIP_ENTITY_ID
MRP_ITEM_WIP_ENTITIES FK Joins to TableMRP_SYSTEM_ITEMS MRP_ITEM_WIP_ENTITIES.INVENTORY_ITEM_ID
MRP_ITEM_WIP_ENTITIES.ORGANIZATION_ID
MRP_ITEM_WIP_ENTITIES.COMPILE_DESIGNATOR
TableMRP_RECOMMENDATIONS FK Joins to MRP_ITEM_WIP_ENTITIES MRP_RECOMMENDATIONS.INVENTORY_ITEM_ID
MRP_RECOMMENDATIONS.ORGANIZATION_ID
MRP_RECOMMENDATIONS.COMPILE_DESIGNATOR
MRP_RECOMMENDATIONS.DISPOSITION_ID
TableMRP_WIP_RESOURCES FK Joins to MRP_ITEM_WIP_ENTITIES MRP_WIP_RESOURCES.INVENTORY_ITEM_ID
MRP_WIP_RESOURCES.ORGANIZATION_ID
MRP_WIP_RESOURCES.COMPILE_DESIGNATOR
MRP_WIP_RESOURCES.WIP_ENTITY_ID