FND Design Data [Home] [Help]

Table: MSC_OPERATION_COMPONENTS

Product: MSC - Advanced Supply Chain Planning
Description: This table is the intersection table between MSC_BOM_COMPONENTS and MSC_ROUTING_OPERATIONS.
Implementation/DBA Data: TableMSC.MSC_OPERATION_COMPONENTS
Primary Key: MSC_OPERATION_COMPONENTS_PK
  1. ColumnORGANIZATION_ID
  2. ColumnROUTING_SEQUENCE_ID
  3. ColumnOPERATION_SEQUENCE_ID
  4. ColumnCOMPONENT_SEQUENCE_ID
  5. ColumnSR_INSTANCE_ID
  6. ColumnPLAN_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
MSC_OPERATION_COMPONENTS FK Joins to TableMSC_BOM_COMPONENTS MSC_OPERATION_COMPONENTS.BILL_SEQUENCE_ID
MSC_OPERATION_COMPONENTS.COMPONENT_SEQUENCE_ID
MSC_OPERATION_COMPONENTS.SR_INSTANCE_ID
MSC_OPERATION_COMPONENTS.PLAN_ID
MSC_OPERATION_COMPONENTS FK Joins to TableMSC_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