FND Design Data [Home] [Help]

Table: MRP_WIP_RESOURCES

Product: MRP - Master Scheduling/MRP
Description: Resources used for a job
Implementation/DBA Data: TableMRP.MRP_WIP_RESOURCES
Primary Key: MRP_WIP_RESOURCES_PK
  1. ColumnORGANIZATION_ID
  2. ColumnCOMPILE_DESIGNATOR
  3. ColumnWIP_ENTITY_ID
  4. ColumnDEPARTMENT_ID
  5. ColumnRESOURCE_ID
  6. ColumnOPERATION_SEQ_NUM
  7. ColumnRESOURCE_SEQ_NUM
Foreign Keys
Table
Foreign Table Foreign Key Column
MRP_WIP_RESOURCES FK Joins to TableMRP_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
MRP_WIP_RESOURCES FK Joins to TableBOM_DEPARTMENT_RESOURCES MRP_WIP_RESOURCES.DEPARTMENT_ID
MRP_WIP_RESOURCES.RESOURCE_ID