View: MSC_CONSTRAINED_FORECAST_V

Product:	MSC - Advanced Supply Chain Planning
Description:
Implementation/DBA Data:	APPS.MSC_CONSTRAINED_FORECAST_V

View Text

SELECT TOTAL.DEMAND_ID
, TOTAL.PLAN_ID
, TOTAL.COMPILE_DESIGNATOR
, TOTAL.SR_INSTANCE_ID
, TOTAL.ORGANIZATION_ID
, TOTAL.INVENTORY_ITEM_ID
, TOTAL.CUSTOMER_ID
, TOTAL.CUSTOMER_SITE_ID
, TOTAL.ITEM_NAME
, TOTAL.DESCRIPTION
, TOTAL.UOM_CODE
, TOTAL.PLANNER_CODE
, TOTAL.ABC_CLASS_NAME
, TOTAL.QUANTITY QUANTITY
, TOTAL.END_DATE
, TOTAL.PROJECT_ID
, TOTAL.TASK_ID
, TOTAL.PLANNING_GROUP
, TOTAL.ORIGINATION_TYPE
, TOTAL.ORDER_NUMBER
FROM (SELECT DEM.DEMAND_ID
, DEM.PLAN_ID PLAN_ID
, PLANS.COMPILE_DESIGNATOR
, DEM.SR_INSTANCE_ID
, DEM.ORGANIZATION_ID
, DEM.INVENTORY_ITEM_ID
, DEM.CUSTOMER_ID
, DEM.CUSTOMER_SITE_ID
, MSI.ITEM_NAME
, MSI.DESCRIPTION
, MSI.UOM_CODE
, MSI.PLANNER_CODE
, MSI.ABC_CLASS_NAME
, DEM.QUANTITY_BY_DUE_DATE QUANTITY
, DEM.USING_ASSEMBLY_DEMAND_DATE END_DATE
, DEM.PROJECT_ID
, DEM.TASK_ID
, DEM.PLANNING_GROUP
, DEM.ORIGINATION_TYPE
, DEM.ORDER_NUMBER
FROM MSC_PLANS PLANS
, MSC_SYSTEM_ITEMS MSI
, MSC_DEMANDS DEM
WHERE DEM.PLAN_ID != -1
AND DEM.PLAN_ID = PLANS.PLAN_ID
AND DEM.INVENTORY_ITEM_ID = DEM.USING_ASSEMBLY_ITEM_ID
AND DEM.ORIGINATION_TYPE IN (6
, 7
, 8
, 9
, 11
, 29
, 30
, 42)
AND DEM.PLAN_ID = MSI.PLAN_ID
AND DEM.SR_INSTANCE_ID = MSI.SR_INSTANCE_ID
AND DEM.ORGANIZATION_ID = MSI.ORGANIZATION_ID
AND DEM.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID
AND NVL(DEM.QUANTITY_BY_DUE_DATE
, 0) <> 0 UNION ALL SELECT DEM.DEMAND_ID
, DEM.PLAN_ID PLAN_ID
, PLANS.COMPILE_DESIGNATOR
, DEM.SR_INSTANCE_ID
, DEM.ORGANIZATION_ID
, DEM.INVENTORY_ITEM_ID
, DEM.CUSTOMER_ID
, DEM.CUSTOMER_SITE_ID
, MSI.ITEM_NAME
, MSI.DESCRIPTION
, MSI.UOM_CODE
, MSI.PLANNER_CODE
, MSI.ABC_CLASS_NAME
, (DEM.USING_REQUIREMENT_QUANTITY - NVL(DEM.QUANTITY_BY_DUE_DATE
, 0)) QUANTITY
, DEM.DMD_SATISFIED_DATE DUE_DATE
, DEM.PROJECT_ID
, DEM.TASK_ID
, DEM.PLANNING_GROUP
, DEM.ORIGINATION_TYPE
, DEM.ORDER_NUMBER
FROM MSC_PLANS PLANS
, MSC_SYSTEM_ITEMS MSI
, MSC_DEMANDS DEM
WHERE DEM.PLAN_ID != -1
AND DEM.PLAN_ID = PLANS.PLAN_ID
AND DEM.INVENTORY_ITEM_ID = DEM.USING_ASSEMBLY_ITEM_ID
AND DEM.ORIGINATION_TYPE IN (6
, 7
, 8
, 9
, 11
, 29
, 30
, 42)
AND DEM.PLAN_ID = MSI.PLAN_ID
AND DEM.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID
AND DEM.SR_INSTANCE_ID = MSI.SR_INSTANCE_ID
AND DEM.ORGANIZATION_ID = MSI.ORGANIZATION_ID
AND DEM.DMD_SATISFIED_DATE IS NOT NULL
AND (DEM.USING_REQUIREMENT_QUANTITY - NVL(DEM.QUANTITY_BY_DUE_DATE
, 0)) <> 0 ) TOTAL

Columns