eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.MSD_VALIDATE_DEMAND_PLAN dependencies on MSD_CS_DFN_UTL

Line 302: msd_cs_dfn_utl.get_planning_server_clmn(csd.cs_definition_id, mdp.FORECAST_DATE_USED) date_planning_view_clmn,

298: mdp.forecast_date_used,
299: mdp.start_date prm_start_date,
300: mdp.end_date prm_end_date,
301: nvl(mdp.view_name, nvl(csd.planning_server_view_name,'MSD_CS_DATA_V')) view_name,
302: msd_cs_dfn_utl.get_planning_server_clmn(csd.cs_definition_id, mdp.FORECAST_DATE_USED) date_planning_view_clmn,
303: cdd.collect_level_id
304: FROM msd_dp_scenarios mds,
305: msd_dp_parameters mdp,
306: msd_cs_definitions csd,

Line 434: MSD_CS_DFN_UTL.get_planning_server_clmn(mcd.cs_definition_id, nvl(mdp.FORECAST_DATE_USED, 'END_DATE')) date_clmn,

430: mdp.parameter_name,
431: mdp.start_date,
432: mdp.end_date,
433: mcd.system_flag,
434: MSD_CS_DFN_UTL.get_planning_server_clmn(mcd.cs_definition_id, nvl(mdp.FORECAST_DATE_USED, 'END_DATE')) date_clmn,
435: mdp.input_demand_plan_id,
436: mdp.input_scenario_id,
437: mdp.revision
438: FROM msd_cs_defn_dim_dtls mcdd,

Line 618: DECODE(DEF1.NAME,'MSD_INPUT_SCENARIO','TIME_LVL_VAL_FROM',MSD_CS_DFN_UTL.get_planning_server_clmn(def1.cs_definition_id, mpv1.FORECAST_DATE_USED)) DATE_CLMN1,

614: MPV1.INPUT_SCENARIO_ID INPUT_SCENARIO_ID1,
615: MPV2.INPUT_SCENARIO_ID INPUT_SCENARIO_ID2,
616: DECODE(DEF1.NAME,'MSD_INPUT_SCENARIO',MPV1.REVISION,MPV1.PARAMETER_NAME) PARAM1,
617: DECODE(DEF2.NAME,'MSD_INPUT_SCENARIO',MPV2.REVISION,MPV2.PARAMETER_NAME) PARAM2,
618: DECODE(DEF1.NAME,'MSD_INPUT_SCENARIO','TIME_LVL_VAL_FROM',MSD_CS_DFN_UTL.get_planning_server_clmn(def1.cs_definition_id, mpv1.FORECAST_DATE_USED)) DATE_CLMN1,
619: DECODE(DEF2.NAME,'MSD_INPUT_SCENARIO','TIME_LVL_VAL_FROM',MSD_CS_DFN_UTL.get_planning_server_clmn(def2.cs_definition_id, mpv2.FORECAST_DATE_USED)) DATE_CLMN2,
620: DEF1.SYSTEM_FLAG SYSTEM_FLAG1,
621: DEF2.SYSTEM_FLAG SYSTEM_FLAG2,
622: DEF1.MULTIPLE_STREAM_FLAG MULTI_STREAM_FLAG1,

Line 619: DECODE(DEF2.NAME,'MSD_INPUT_SCENARIO','TIME_LVL_VAL_FROM',MSD_CS_DFN_UTL.get_planning_server_clmn(def2.cs_definition_id, mpv2.FORECAST_DATE_USED)) DATE_CLMN2,

615: MPV2.INPUT_SCENARIO_ID INPUT_SCENARIO_ID2,
616: DECODE(DEF1.NAME,'MSD_INPUT_SCENARIO',MPV1.REVISION,MPV1.PARAMETER_NAME) PARAM1,
617: DECODE(DEF2.NAME,'MSD_INPUT_SCENARIO',MPV2.REVISION,MPV2.PARAMETER_NAME) PARAM2,
618: DECODE(DEF1.NAME,'MSD_INPUT_SCENARIO','TIME_LVL_VAL_FROM',MSD_CS_DFN_UTL.get_planning_server_clmn(def1.cs_definition_id, mpv1.FORECAST_DATE_USED)) DATE_CLMN1,
619: DECODE(DEF2.NAME,'MSD_INPUT_SCENARIO','TIME_LVL_VAL_FROM',MSD_CS_DFN_UTL.get_planning_server_clmn(def2.cs_definition_id, mpv2.FORECAST_DATE_USED)) DATE_CLMN2,
620: DEF1.SYSTEM_FLAG SYSTEM_FLAG1,
621: DEF2.SYSTEM_FLAG SYSTEM_FLAG2,
622: DEF1.MULTIPLE_STREAM_FLAG MULTI_STREAM_FLAG1,
623: DEF2.MULTIPLE_STREAM_FLAG MULTI_STREAM_FLAG2