Table: MSC_DEMANDS

Product:	MSC - Advanced Supply Chain Planning
Description:	This table stores all the demands taken into account for planning. Disposition_id would be a foreign key to MSC_SUPPLIES for dependent demands. For independent demands, disposition_id holds MRP_SCHEDULE_DATES.MPS_TRANSACTION_ID.
Implementation/DBA Data:	MSC.MSC_DEMANDS

Primary Key: MSC_DEMANDS_PK

1. PLAN_ID
2. SR_INSTANCE_ID
3. DEMAND_ID

Foreign Keys

Table		Foreign Table	Foreign Key Column
MSC_DEMANDS		MSC_SYSTEM_ITEMS	MSC_DEMANDS.INVENTORY_ITEM_ID MSC_DEMANDS.PLAN_ID MSC_DEMANDS.SR_INSTANCE_ID MSC_DEMANDS.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_DEMANDS		MSC_TRADING_PARTNER_SITES	MSC_DEMANDS.SHIP_TO_SITE_ID
MSC_DEMANDS		MSC_DESIGNATORS	MSC_DEMANDS.SCHEDULE_DESIGNATOR_ID
MSC_DEMANDS		MSC_SUPPLIES	MSC_DEMANDS.PLAN_ID MSC_DEMANDS.DISPOSITION_ID
MSC_DEMANDS		MSC_TRADING_PARTNERS	MSC_DEMANDS.CUSTOMER_ID
MSC_DEMANDS		MSC_TRADING_PARTNER_SITES	MSC_DEMANDS.CUSTOMER_SITE_ID
MSC_DEMANDS		MSC_SYSTEM_ITEMS	MSC_DEMANDS.USING_ASSEMBLY_ITEM_ID MSC_DEMANDS.PLAN_ID MSC_DEMANDS.SR_INSTANCE_ID MSC_DEMANDS.ORGANIZATION_ID
MSC_DEMANDS		MSC_PROJECTS	MSC_DEMANDS.PLAN_ID MSC_DEMANDS.SR_INSTANCE_ID MSC_DEMANDS.PROJECT_ID MSC_DEMANDS.ORGANIZATION_ID
MSC_DEMANDS		MSC_DEMANDS	MSC_DEMANDS.PLAN_ID MSC_DEMANDS.PARENT_ID
MSC_DEMANDS		MSC_DEMANDS	MSC_DEMANDS.PLAN_ID MSC_DEMANDS.PARENT_ID
MSC_FORECAST_UPDATES		MSC_DEMANDS	MSC_FORECAST_UPDATES.PLAN_ID MSC_FORECAST_UPDATES.FORECAST_DEMAND_ID MSC_FORECAST_UPDATES.SR_INSTANCE_ID
MSC_FULL_PEGGING		MSC_DEMANDS	MSC_FULL_PEGGING.PLAN_ID MSC_FULL_PEGGING.DEMAND_ID