VIEW: APPS.MSD_DP_SCN_REVISIONS_V

Source

View Text - Preformatted

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, mdp.plan_type 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 and nvl(mdp.plan_type, 'DP') <> 'LIABILITY'

View Text - HTML Formatted

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
, MDP.PLAN_TYPE
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
AND NVL(MDP.PLAN_TYPE
, 'DP') <> 'LIABILITY'