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_PROJECTS

Product:	MSC - Advanced Supply Chain Planning
Description:	This table stores the manufacturing parameters for a given project and organization.
Implementation/DBA Data:	MSC.MSC_PROJECTS

Primary Key: MSC_PROJECTS_PK

SR_INSTANCE_ID
ORGANIZATION_ID
PROJECT_ID
PLAN_ID

Foreign Keys

Table	Foreign Table	Foreign Key Column
MSC_PROJECTS	MSC_PLAN_ORGANIZATIONS	MSC_PROJECTS.PLAN_ID MSC_PROJECTS.ORGANIZATION_ID MSC_PROJECTS.SR_INSTANCE_ID
MSC_DEMANDS	MSC_PROJECTS	MSC_DEMANDS.PLAN_ID MSC_DEMANDS.SR_INSTANCE_ID MSC_DEMANDS.PROJECT_ID MSC_DEMANDS.ORGANIZATION_ID
MSC_ITEM_EXCEPTIONS	MSC_PROJECTS	MSC_ITEM_EXCEPTIONS.PLAN_ID MSC_ITEM_EXCEPTIONS.SR_INSTANCE_ID MSC_ITEM_EXCEPTIONS.PROJECT_ID MSC_ITEM_EXCEPTIONS.ORGANIZATION_ID
MSC_FULL_PEGGING	MSC_PROJECTS	MSC_FULL_PEGGING.PLAN_ID MSC_FULL_PEGGING.SR_INSTANCE_ID MSC_FULL_PEGGING.PROJECT_ID MSC_FULL_PEGGING.ORGANIZATION_ID
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_ROUTINGS	MSC_PROJECTS	MSC_ROUTINGS.PLAN_ID MSC_ROUTINGS.SR_INSTANCE_ID MSC_ROUTINGS.PROJECT_ID MSC_ROUTINGS.ORGANIZATION_ID
MSC_SUPPLIES	MSC_PROJECTS	MSC_SUPPLIES.PLAN_ID MSC_SUPPLIES.SR_INSTANCE_ID MSC_SUPPLIES.PROJECT_ID MSC_SUPPLIES.ORGANIZATION_ID
MSC_SUPPLIES	MSC_PROJECTS	MSC_SUPPLIES.PLAN_ID MSC_SUPPLIES.SR_INSTANCE_ID MSC_SUPPLIES.IMPLEMENT_PROJECT_ID MSC_SUPPLIES.ORGANIZATION_ID