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.

APPS.MSD_VALIDATE_DEMAND_PLAN dependencies on MSD_DP_PARAMETERS

Line 162: from msd_cs_definitions mcd, msd_cs_defn_dim_dtls mcdd, msd_dp_parameters mdp

158: FROM msd_dp_dimensions_v mddv
159: WHERE demand_plan_id = p_demand_plan_id
160: and not exists (
161: select 1
162: from msd_cs_definitions mcd, msd_cs_defn_dim_dtls mcdd, msd_dp_parameters mdp
163: where mcd.cs_definition_id = mcdd.cs_definition_id
164: and mdp.parameter_type = mcd.name
165: and mdp.demand_plan_id = p_demand_plan_id
166: and mcdd.dimension_code = mddv.dp_dimension_code

Line 266: FROM msd_dp_parameters_cs_v

262: SELECT parameter_type,
263: parameter_name,
264: forecast_date_used,
265: count(*)
266: FROM msd_dp_parameters_cs_v
267: WHERE demand_plan_id = p_demand_plan_id
268: AND parameter_type_id <> '7'
269: GROUP BY parameter_type,
270: parameter_name,

Line 301: msd_dp_parameters mdp,

297: nvl(mdp.view_name, nvl(csd.planning_server_view_name,'MSD_CS_DATA_V')) view_name,
298: msd_cs_dfn_utl.get_planning_server_clmn(csd.cs_definition_id, mdp.FORECAST_DATE_USED) date_planning_view_clmn,
299: cdd.collect_level_id
300: FROM msd_dp_scenarios mds,
301: msd_dp_parameters mdp,
302: msd_cs_definitions csd,
303: msd_cs_defn_dim_dtls cdd
304: WHERE mds.demand_plan_id = p_demand_plan_id
305: AND mds.enable_flag = 'Y'

Line 401: FROM msd_dp_parameters

397: p_parameter_type VARCHAR2,
398: p_cs_name VARCHAR2,
399: p_date_used in VARCHAR2) IS
400: SELECT start_date, end_date
401: FROM msd_dp_parameters
402: WHERE demand_plan_id = p_demand_plan_id
403: AND parameter_type = p_parameter_type
404: AND (((parameter_name IS NULL) AND (p_cs_name IS NULL))
405: OR

Line 435: msd_dp_parameters mdp,

431: mdp.input_demand_plan_id,
432: mdp.input_scenario_id,
433: mdp.revision
434: FROM msd_cs_defn_dim_dtls mcdd,
435: msd_dp_parameters mdp,
436: msd_cs_definitions mcd,
437: msd_dp_dimensions_v mdd
438: WHERE mdp.demand_plan_id = p_demand_plan_id
439: AND mdd.demand_plan_id = p_demand_plan_id

Line 522: FROM msd_dp_parameters_cs_v mdp

518: mdp.input_demand_plan_id,
519: mdp.input_scenario_id,
520: mdp.revision,
521: mdp.allo_agg_basis_stream_id
522: FROM msd_dp_parameters_cs_v mdp
523: WHERE mdp.demand_plan_id = p_demand_plan_id
524: AND mdp.parameter_type_id <> '7';
525:
526: CURSOR get_ps_view_name (p_cs_def_id NUMBER, p_demand_plan_id number) IS

Line 554: FROM msd_dp_parameters_cs_v

550:
551:
552: CURSOR get_one_param (p_demand_plan_id IN NUMBER, p_parameter_type IN VARCHAR2) IS
553: SELECT cs_definition_id
554: FROM msd_dp_parameters_cs_v
555: WHERE demand_plan_id = p_demand_plan_id
556: AND parameter_type = p_parameter_type
557: AND parameter_type <> '7';
558:

Line 570: MSD_DP_PARAMETERS MPV1,

566: FROM MSD_CS_DEFINITIONS DEF1,
567: MSD_CS_DEFINITIONS DEF2,
568: MSD_CS_DEFN_DIM_DTLS DIM1,
569: MSD_CS_DEFN_DIM_DTLS DIM2,
570: MSD_DP_PARAMETERS MPV1,
571: MSD_DP_PARAMETERS MPV2
572: WHERE MPV1.DEMAND_PLAN_ID = p_demand_plan_id
573: AND DEF1.name = MPV1.parameter_type
574: AND DEF1.COMPOSITE_GROUP_CODE IS NOT NULL

Line 571: MSD_DP_PARAMETERS MPV2

567: MSD_CS_DEFINITIONS DEF2,
568: MSD_CS_DEFN_DIM_DTLS DIM1,
569: MSD_CS_DEFN_DIM_DTLS DIM2,
570: MSD_DP_PARAMETERS MPV1,
571: MSD_DP_PARAMETERS MPV2
572: WHERE MPV1.DEMAND_PLAN_ID = p_demand_plan_id
573: AND DEF1.name = MPV1.parameter_type
574: AND DEF1.COMPOSITE_GROUP_CODE IS NOT NULL
575: AND NVL(DEF1.ENABLE_FLAG,'Y') = 'Y'

Line 623: MSD_DP_PARAMETERS MPV1,

619: FROM MSD_CS_DEFINITIONS DEF1,
620: MSD_CS_DEFINITIONS DEF2,
621: MSD_CS_DEFN_DIM_DTLS DIM1,
622: MSD_CS_DEFN_DIM_DTLS DIM2,
623: MSD_DP_PARAMETERS MPV1,
624: MSD_DP_PARAMETERS MPV2
625: WHERE MPV1.DEMAND_PLAN_ID = p_demand_plan_id
626: AND DEF1.name = MPV1.parameter_type
627: AND NVL(DEF1.ENABLE_FLAG,'Y') = 'Y'

Line 624: MSD_DP_PARAMETERS MPV2

620: MSD_CS_DEFINITIONS DEF2,
621: MSD_CS_DEFN_DIM_DTLS DIM1,
622: MSD_CS_DEFN_DIM_DTLS DIM2,
623: MSD_DP_PARAMETERS MPV1,
624: MSD_DP_PARAMETERS MPV2
625: WHERE MPV1.DEMAND_PLAN_ID = p_demand_plan_id
626: AND DEF1.name = MPV1.parameter_type
627: AND NVL(DEF1.ENABLE_FLAG,'Y') = 'Y'
628: --AND NVL(DEF1.LOWEST_LEVEL_FLAG,1) = 0

Line 1887: msd_dp_parameters_cs_v

1883: cursor get_input_date (p_demand_plan_id in number) is
1884: select
1885: min(start_date), max(end_date)
1886: from
1887: msd_dp_parameters_cs_v
1888: where
1889: demand_plan_id = p_demand_plan_id;
1890: --
1891: l_min_1 date;

Line 3275: msd_dp_parameters_cs_v mdp

3271: mdp.start_date,
3272: mdp.end_date,
3273: mdp.price_list_name
3274: FROM
3275: msd_dp_parameters_cs_v mdp
3276: WHERE mdp.demand_plan_id = p_demand_plan_id
3277: AND mdp.parameter_type_id <> '7'
3278: AND nvl(mdp.stream_type,'ABCD') not in ('ARCHIVED','ARCHIVED_TIM','CALCULATED','PLACEHOLDER')
3279: AND mdp.price_list_name IS NOT NULL;