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_PROJECT_TASKS

Product:	MSC - Advanced Supply Chain Planning
Description:	This table stores the tasks maufacturing parameters.
Implementation/DBA Data:	MSC.MSC_PROJECT_TASKS

Primary Key: MSC_PROJECT_TASKS_PK

SR_INSTANCE_ID
ORGANIZATION_ID
PLAN_ID
PROJECT_ID
TASK_ID

Foreign Keys

Table	Foreign Table	Foreign Key Column
MSC_PROJECT_TASKS	MSC_PROJECTS	MSC_PROJECT_TASKS.PLAN_ID MSC_PROJECT_TASKS.SR_INSTANCE_ID MSC_PROJECT_TASKS.PROJECT_ID MSC_PROJECT_TASKS.ORGANIZATION_ID
MSC_DEMANDS	MSC_PROJECT_TASKS	MSC_DEMANDS.ORGANIZATION_ID MSC_DEMANDS.TASK_ID MSC_DEMANDS.PROJECT_ID MSC_DEMANDS.SR_INSTANCE_ID MSC_DEMANDS.PLAN_ID
MSC_FULL_PEGGING	MSC_PROJECT_TASKS	MSC_FULL_PEGGING.ORGANIZATION_ID MSC_FULL_PEGGING.TASK_ID MSC_FULL_PEGGING.PROJECT_ID MSC_FULL_PEGGING.SR_INSTANCE_ID MSC_FULL_PEGGING.PLAN_ID
MSC_ITEM_EXCEPTIONS	MSC_PROJECT_TASKS	MSC_ITEM_EXCEPTIONS.ORGANIZATION_ID MSC_ITEM_EXCEPTIONS.TASK_ID MSC_ITEM_EXCEPTIONS.PROJECT_ID MSC_ITEM_EXCEPTIONS.SR_INSTANCE_ID MSC_ITEM_EXCEPTIONS.PLAN_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_SUPPLIES	MSC_PROJECT_TASKS	MSC_SUPPLIES.ORGANIZATION_ID MSC_SUPPLIES.TASK_ID MSC_SUPPLIES.PROJECT_ID MSC_SUPPLIES.SR_INSTANCE_ID MSC_SUPPLIES.PLAN_ID
MSC_SUPPLIES	MSC_PROJECT_TASKS	MSC_SUPPLIES.ORGANIZATION_ID MSC_SUPPLIES.IMPLEMENT_TASK_ID MSC_SUPPLIES.IMPLEMENT_PROJECT_ID MSC_SUPPLIES.SR_INSTANCE_ID MSC_SUPPLIES.PLAN_ID