View: MSD_DP_SCN_OUTPUT_LEVELS_V

Product:	MSD - Demand Planning
Description:	This view provides the Levels at which the output Scenario for a demand plan is to be generated. This stores the level values for all the dimension except for the time dimensions as the level values for the time dimension are pre-seeded as
Implementation/DBA Data:	APPS.MSD_DP_SCN_OUTPUT_LEVELS_V

View Text

SELECT MDSOL.ROWID
, MDSOL.DEMAND_PLAN_ID
, MDDV.DEMAND_PLAN_NAME
, MDSOL.SCENARIO_ID
, MDSV.SCENARIO_NAME
, MDSV.DESCRIPTION
, MDSV.OUTPUT_PERIOD_TYPE_ID
, MDSV.OUTPUT_PERIOD_TYPE
, MDSV.HORIZON_START_DATE
, MDSV.HORIZON_END_DATE
, MDSV.FORECAST_DATE_USED_ID
, MDSV.FORECAST_DATE_USED
, MDSV.FORECAST_BASED_ON_ID
, MDSV.FORECAST_BASED_ON
, MDSV.PRICE_LIST_NAME
, MDSOL.LEVEL_ID
, MLV.LEVEL_NAME
, MDDV.DP_DIMENSION_CODE
, MDDV.DP_DIMENSION
, MLV.OWNING_DIMENSION_CODE
, MLV.OWNING_DIMENSION
, MDSOL.LAST_UPDATE_DATE
, MDSOL.LAST_UPDATED_BY
, MDSOL.CREATION_DATE
, MDSOL.CREATED_BY
, MDSOL.LAST_UPDATE_LOGIN
, MDSOL.REQUEST_ID
, MDSOL.PROGRAM_APPLICATION_ID
, MDSOL.PROGRAM_ID
, MDSOL.PROGRAM_UPDATE_DATE
FROM MSD_DP_DIMENSIONS_V MDDV
, MSD_LEVELS_V MLV
, MSD_DP_SCENARIOS_V MDSV
, MSD_DP_SCENARIO_OUTPUT_LEVELS MDSOL
WHERE MDDV.DEMAND_PLAN_ID = MDSOL.DEMAND_PLAN_ID
AND MLV.LEVEL_ID = MDSOL.LEVEL_ID
AND MDDV.DIMENSION_CODE = MLV.OWNING_DIMENSION_CODE
AND MDSV.DEMAND_PLAN_ID = MDSOL.DEMAND_PLAN_ID
AND MDSV.SCENARIO_ID = MDSOL.SCENARIO_ID

Columns