FND Design Data [Home] [Help]

Table: MSC_ROUTING_OPERATIONS

Product: MSC - Advanced Supply Chain Planning
Description: This tables stores the operations composing each routing.
Implementation/DBA Data: TableMSC.MSC_ROUTING_OPERATIONS
Primary Key: MSC_ROUTING_OPERATIONS_PK
  1. ColumnSR_INSTANCE_ID
  2. ColumnROUTING_SEQUENCE_ID
  3. ColumnOPERATION_SEQUENCE_ID
  4. ColumnPLAN_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
MSC_ROUTING_OPERATIONS FK Joins to TableMSC_ROUTINGS MSC_ROUTING_OPERATIONS.PLAN_ID
MSC_ROUTING_OPERATIONS.ROUTING_SEQUENCE_ID
MSC_ROUTING_OPERATIONS.SR_INSTANCE_ID
TableMSC_OPERATION_NETWORKS FK Joins to MSC_ROUTING_OPERATIONS MSC_OPERATION_NETWORKS.PLAN_ID
MSC_OPERATION_NETWORKS.ROUTING_SEQUENCE_ID
MSC_OPERATION_NETWORKS.SR_INSTANCE_ID
MSC_OPERATION_NETWORKS.FROM_OP_SEQ_ID
TableMSC_OPERATION_NETWORKS FK Joins to MSC_ROUTING_OPERATIONS MSC_OPERATION_NETWORKS.PLAN_ID
MSC_OPERATION_NETWORKS.ROUTING_SEQUENCE_ID
MSC_OPERATION_NETWORKS.SR_INSTANCE_ID
MSC_OPERATION_NETWORKS.TO_OP_SEQ_ID
TableMSC_OPERATION_RESOURCE_SEQS FK Joins to MSC_ROUTING_OPERATIONS MSC_OPERATION_RESOURCE_SEQS.PLAN_ID
MSC_OPERATION_RESOURCE_SEQS.ROUTING_SEQUENCE_ID
MSC_OPERATION_RESOURCE_SEQS.SR_INSTANCE_ID
MSC_OPERATION_RESOURCE_SEQS.OPERATION_SEQUENCE_ID
TableMSC_OPERATION_COMPONENTS FK Joins to MSC_ROUTING_OPERATIONS MSC_OPERATION_COMPONENTS.PLAN_ID
MSC_OPERATION_COMPONENTS.ROUTING_SEQUENCE_ID
MSC_OPERATION_COMPONENTS.SR_INSTANCE_ID
MSC_OPERATION_COMPONENTS.OPERATION_SEQUENCE_ID