VIEW: APPS.MSD_DP_SCN_LOV_V

Source

View Text - Preformatted

SELECT revision id, input_demand_plan_name || ':' || input_scenario_name|| ':' || revision_name cs_name from msd_dp_scn_revisions_v order by upper(input_demand_plan_name || ':' || input_scenario_name|| ':' || revision_name)

View Text - HTML Formatted

SELECT REVISION ID
, INPUT_DEMAND_PLAN_NAME || ':' || INPUT_SCENARIO_NAME|| ':' || REVISION_NAME CS_NAME
FROM MSD_DP_SCN_REVISIONS_V ORDER BY UPPER(INPUT_DEMAND_PLAN_NAME || ':' || INPUT_SCENARIO_NAME|| ':' || REVISION_NAME)