FND Design Data [Home] [Help]

Table: MSC_RESOURCE_REQUIREMENTS

Product: MSC - Advanced Supply Chain Planning
Description: This table stores the resource requirments generated by existing supplies.
Implementation/DBA Data: TableMSC.MSC_RESOURCE_REQUIREMENTS
Primary Key: MSC_RESOURCE_REQUIREMENTS_PK
  1. ColumnPLAN_ID
  2. ColumnSR_INSTANCE_ID
  3. ColumnTRANSACTION_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
MSC_RESOURCE_REQUIREMENTS FK Joins to TableMSC_SUPPLIES MSC_RESOURCE_REQUIREMENTS.PLAN_ID
MSC_RESOURCE_REQUIREMENTS.SUPPLY_ID
MSC_RESOURCE_REQUIREMENTS FK Joins to TableMSC_ROUTINGS MSC_RESOURCE_REQUIREMENTS.PLAN_ID
MSC_RESOURCE_REQUIREMENTS.ROUTING_SEQUENCE_ID
MSC_RESOURCE_REQUIREMENTS.SR_INSTANCE_ID
MSC_RESOURCE_REQUIREMENTS FK Joins to TableMSC_OPERATION_RESOURCE_SEQS MSC_RESOURCE_REQUIREMENTS.PLAN_ID
MSC_RESOURCE_REQUIREMENTS.ROUTING_SEQUENCE_ID
MSC_RESOURCE_REQUIREMENTS.SR_INSTANCE_ID
MSC_RESOURCE_REQUIREMENTS.OPERATION_SEQUENCE_ID
MSC_RESOURCE_REQUIREMENTS.RESOURCE_SEQ_NUM
MSC_RESOURCE_REQUIREMENTS FK Joins to TableMSC_OPERATION_RESOURCES MSC_RESOURCE_REQUIREMENTS.PLAN_ID
MSC_RESOURCE_REQUIREMENTS.OPERATION_SEQUENCE_ID
MSC_RESOURCE_REQUIREMENTS.ROUTING_SEQUENCE_ID
MSC_RESOURCE_REQUIREMENTS.RESOURCE_SEQ_NUM
MSC_RESOURCE_REQUIREMENTS.RESOURCE_ID
MSC_RESOURCE_REQUIREMENTS.ALTERNATE_NUM
MSC_RESOURCE_REQUIREMENTS.SR_INSTANCE_ID
MSC_RESOURCE_REQUIREMENTS FK Joins to TableMSC_RESOURCE_REQUIREMENTS MSC_RESOURCE_REQUIREMENTS.PLAN_ID
MSC_RESOURCE_REQUIREMENTS.PARENT_ID
TableMSC_RESOURCE_REQUIREMENTS FK Joins to MSC_RESOURCE_REQUIREMENTS MSC_RESOURCE_REQUIREMENTS.PLAN_ID
MSC_RESOURCE_REQUIREMENTS.PARENT_ID