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_SUPPLIES

Product:	MSC - Advanced Supply Chain Planning
Description:	This table lists all the supplies for this plan. The supplies created by the planning process are added to this table.
Implementation/DBA Data:	MSC.MSC_SUPPLIES

Primary Key: MSC_SUPPLIES_PK

PLAN_ID
SR_INSTANCE_ID
TRANSACTION_ID

Foreign Keys

Table	Foreign Table	Foreign Key Column
MSC_SUPPLIES	MSC_SYSTEM_ITEMS	MSC_SUPPLIES.INVENTORY_ITEM_ID MSC_SUPPLIES.PLAN_ID MSC_SUPPLIES.SR_INSTANCE_ID MSC_SUPPLIES.ORGANIZATION_ID
MSC_SUPPLIES	MSC_DESIGNATORS	MSC_SUPPLIES.SCHEDULE_DESIGNATOR_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_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_PROJECTS	MSC_SUPPLIES.PLAN_ID MSC_SUPPLIES.SR_INSTANCE_ID MSC_SUPPLIES.IMPLEMENT_PROJECT_ID MSC_SUPPLIES.ORGANIZATION_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
MSC_DEMANDS	MSC_SUPPLIES	MSC_DEMANDS.PLAN_ID MSC_DEMANDS.DISPOSITION_ID
MSC_FULL_PEGGING	MSC_SUPPLIES	MSC_FULL_PEGGING.PLAN_ID MSC_FULL_PEGGING.TRANSACTION_ID
MSC_RESOURCE_REQUIREMENTS	MSC_SUPPLIES	MSC_RESOURCE_REQUIREMENTS.PLAN_ID MSC_RESOURCE_REQUIREMENTS.SUPPLY_ID