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_OPERATION_RESOURCE_SEQS

Product:	MSC - Advanced Supply Chain Planning
Description:	This tables stores the operation resources for each routing operation.
Implementation/DBA Data:	MSC.MSC_OPERATION_RESOURCE_SEQS

Primary Key: MSC_OPERATION_RESOURCE_SEQS_PK

PLAN_ID
ROUTING_SEQUENCE_ID
SR_INSTANCE_ID
OPERATION_SEQUENCE_ID
RESOURCE_SEQ_NUM

Foreign Keys

Table	Foreign Table	Foreign Key Column
MSC_OPERATION_RESOURCE_SEQS	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
MSC_OPERATION_RESOURCES	MSC_OPERATION_RESOURCE_SEQS	MSC_OPERATION_RESOURCES.PLAN_ID MSC_OPERATION_RESOURCES.ROUTING_SEQUENCE_ID MSC_OPERATION_RESOURCES.SR_INSTANCE_ID MSC_OPERATION_RESOURCES.OPERATION_SEQUENCE_ID MSC_OPERATION_RESOURCES.RESOURCE_SEQ_NUM
MSC_RESOURCE_REQUIREMENTS	MSC_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