APPS.MSD_VALIDATE_DEMAND_PLAN dependencies on MSD_DP_PARAMETERS_CS_V

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 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 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;