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_RESOURCES

Product:	MSC - Advanced Supply Chain Planning
Description:	This table stores operation resources from a resource sequence. For each resource sequence, we have an alternative between different set of operation resources. This is described by the Alternate Number. Resources with the same Alternate
Implementation/DBA Data:	MSC.MSC_OPERATION_RESOURCES

Primary Key: MSC_OPERATION_RESOURCES_PK

PLAN_ID
OPERATION_SEQUENCE_ID
ROUTING_SEQUENCE_ID
RESOURCE_SEQ_NUM
RESOURCE_ID
ALTERNATE_NUMBER
SR_INSTANCE_ID

Foreign Keys

Table		Foreign Table	Foreign Key Column
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_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