APPS.MSD_VALIDATE_DEMAND_PLAN dependencies on MSD_DP_PARAMETERS_CS_V

Line 270: FROM msd_dp_parameters_cs_v

266: SELECT parameter_type,
267: parameter_name,
268: forecast_date_used,
269: count(*)
270: FROM msd_dp_parameters_cs_v
271: WHERE demand_plan_id = p_demand_plan_id
272: AND parameter_type_id <> '7'
273: GROUP BY parameter_type,
274: parameter_name,

Line 527: FROM msd_dp_parameters_cs_v mdp

523: mdp.input_scenario_id,
524: mdp.revision,
525: mdp.allo_agg_basis_stream_id,
526: mdp.ascp_stream_flag
527: FROM msd_dp_parameters_cs_v mdp
528: WHERE mdp.demand_plan_id = p_demand_plan_id
529: AND mdp.parameter_type_id <> '7';
530:
531: CURSOR get_ps_view_name (p_cs_def_id NUMBER, p_demand_plan_id number) IS

Line 559: FROM msd_dp_parameters_cs_v

555:
556:
557: CURSOR get_one_param (p_demand_plan_id IN NUMBER, p_parameter_type IN VARCHAR2) IS
558: SELECT cs_definition_id
559: FROM msd_dp_parameters_cs_v
560: WHERE demand_plan_id = p_demand_plan_id
561: AND parameter_type = p_parameter_type
562: AND parameter_type <> '7';
563:

Line 1872: msd_dp_parameters_cs_v

1868: cursor get_input_date (p_demand_plan_id in number) is
1869: select
1870: min(start_date), max(end_date)
1871: from
1872: msd_dp_parameters_cs_v
1873: where
1874: demand_plan_id = p_demand_plan_id;
1875: --
1876: l_min_1 date;

Line 3408: msd_dp_parameters_cs_v mdp

3404: mdp.start_date,
3405: mdp.end_date,
3406: mdp.price_list_name
3407: FROM
3408: msd_dp_parameters_cs_v mdp
3409: WHERE mdp.demand_plan_id = p_demand_plan_id
3410: AND mdp.parameter_type_id <> '7'
3411: AND nvl(mdp.stream_type,'ABCD') not in ('ARCHIVED','ARCHIVED_TIM','CALCULATED','PLACEHOLDER')
3412: AND mdp.price_list_name IS NOT NULL;