View: MSD_DP_SCN_REVISIONS_V

Product:	MSD - Demand Planning
Description:	This view to show scenario revisions
Implementation/DBA Data:	APPS.MSD_DP_SCN_REVISIONS_V

View Text

SELECT MDSR.REVISION
, MDSR.REVISION_NAME
, A.SCENARIO_ID
, A.SCENARIO_NAME
, MDP.DEMAND_PLAN_ID
, MDP.DEMAND_PLAN_NAME
, MDP.DEMAND_PLAN_NAME || ':' || A.SCENARIO_NAME || ':' || MDSR.REVISION_NAME
FROM MSD_DP_SCENARIOS A
, MSD_DP_SCENARIO_REVISIONS MDSR
, MSD_DEMAND_PLANS MDP
WHERE MDSR.DEMAND_PLAN_ID = A.DEMAND_PLAN_ID
AND MDSR.SCENARIO_ID = A.SCENARIO_ID
AND MDSR.DEMAND_PLAN_ID = MDP.DEMAND_PLAN_ID

Columns