eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

Table: MSC_ROUTINGS

Product:	MSC - Advanced Supply Chain Planning
Description:	This table stores the different routings available for a bill of material.
Implementation/DBA Data:	MSC.MSC_ROUTINGS

Primary Key: MSC_ROUTINGS_PK

PLAN_ID
ROUTING_SEQUENCE_ID
SR_INSTANCE_ID

Foreign Keys

Table	Foreign Table	Foreign Key Column
MSC_ROUTINGS	MSC_SYSTEM_ITEMS	MSC_ROUTINGS.ASSEMBLY_ITEM_ID MSC_ROUTINGS.PLAN_ID MSC_ROUTINGS.SR_INSTANCE_ID MSC_ROUTINGS.ORGANIZATION_ID
MSC_ROUTINGS	MSC_PROJECTS	MSC_ROUTINGS.PLAN_ID MSC_ROUTINGS.SR_INSTANCE_ID MSC_ROUTINGS.PROJECT_ID MSC_ROUTINGS.ORGANIZATION_ID
MSC_ROUTINGS	MSC_PROJECT_TASKS	MSC_ROUTINGS.ORGANIZATION_ID MSC_ROUTINGS.TASK_ID MSC_ROUTINGS.PROJECT_ID MSC_ROUTINGS.SR_INSTANCE_ID MSC_ROUTINGS.PLAN_ID
MSC_PROCESS_EFFECTIVITY	MSC_ROUTINGS	MSC_PROCESS_EFFECTIVITY.PLAN_ID MSC_PROCESS_EFFECTIVITY.ROUTING_SEQUENCE_ID MSC_PROCESS_EFFECTIVITY.SR_INSTANCE_ID
MSC_RESOURCE_REQUIREMENTS	MSC_ROUTINGS	MSC_RESOURCE_REQUIREMENTS.PLAN_ID MSC_RESOURCE_REQUIREMENTS.ROUTING_SEQUENCE_ID MSC_RESOURCE_REQUIREMENTS.SR_INSTANCE_ID
MSC_ROUTING_OPERATIONS	MSC_ROUTINGS	MSC_ROUTING_OPERATIONS.PLAN_ID MSC_ROUTING_OPERATIONS.ROUTING_SEQUENCE_ID MSC_ROUTING_OPERATIONS.SR_INSTANCE_ID