FND Design Data [Home] [Help]

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: TableMSC.MSC_DEMANDS
Primary Key: MSC_DEMANDS_PK
  1. ColumnPLAN_ID
  2. ColumnSR_INSTANCE_ID
  3. ColumnDEMAND_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
MSC_DEMANDS FK Joins to TableMSC_SYSTEM_ITEMS MSC_DEMANDS.INVENTORY_ITEM_ID
MSC_DEMANDS.PLAN_ID
MSC_DEMANDS.SR_INSTANCE_ID
MSC_DEMANDS.ORGANIZATION_ID
MSC_DEMANDS FK Joins to TableMSC_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 FK Joins to TableMSC_TRADING_PARTNER_SITES MSC_DEMANDS.SHIP_TO_SITE_ID
MSC_DEMANDS FK Joins to TableMSC_DESIGNATORS MSC_DEMANDS.SCHEDULE_DESIGNATOR_ID
MSC_DEMANDS FK Joins to TableMSC_SUPPLIES MSC_DEMANDS.PLAN_ID
MSC_DEMANDS.DISPOSITION_ID
MSC_DEMANDS FK Joins to TableMSC_TRADING_PARTNERS MSC_DEMANDS.CUSTOMER_ID
MSC_DEMANDS FK Joins to TableMSC_TRADING_PARTNER_SITES MSC_DEMANDS.CUSTOMER_SITE_ID
MSC_DEMANDS FK Joins to TableMSC_SYSTEM_ITEMS MSC_DEMANDS.USING_ASSEMBLY_ITEM_ID
MSC_DEMANDS.PLAN_ID
MSC_DEMANDS.SR_INSTANCE_ID
MSC_DEMANDS.ORGANIZATION_ID
MSC_DEMANDS FK Joins to TableMSC_PROJECTS MSC_DEMANDS.PLAN_ID
MSC_DEMANDS.SR_INSTANCE_ID
MSC_DEMANDS.PROJECT_ID
MSC_DEMANDS.ORGANIZATION_ID
MSC_DEMANDS FK Joins to TableMSC_DEMANDS MSC_DEMANDS.PLAN_ID
MSC_DEMANDS.PARENT_ID
TableMSC_DEMANDS FK Joins to MSC_DEMANDS MSC_DEMANDS.PLAN_ID
MSC_DEMANDS.PARENT_ID
TableMSC_FORECAST_UPDATES FK Joins to MSC_DEMANDS MSC_FORECAST_UPDATES.PLAN_ID
MSC_FORECAST_UPDATES.FORECAST_DEMAND_ID
MSC_FORECAST_UPDATES.SR_INSTANCE_ID
TableMSC_FULL_PEGGING FK Joins to MSC_DEMANDS MSC_FULL_PEGGING.PLAN_ID
MSC_FULL_PEGGING.DEMAND_ID