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_DP_PARAMETERS

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

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

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 305: msd_dp_parameters mdp,

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,
307: msd_cs_defn_dim_dtls cdd
308: WHERE mds.demand_plan_id = p_demand_plan_id
309: AND mds.enable_flag = 'Y'

Line 405: FROM msd_dp_parameters

401: p_parameter_type VARCHAR2,
402: p_cs_name VARCHAR2,
403: p_date_used in VARCHAR2) IS
404: SELECT start_date, end_date
405: FROM msd_dp_parameters
406: WHERE demand_plan_id = p_demand_plan_id
407: AND parameter_type = p_parameter_type
408: AND (((parameter_name IS NULL) AND (p_cs_name IS NULL))
409: OR

Line 439: msd_dp_parameters mdp,

435: mdp.input_demand_plan_id,
436: mdp.input_scenario_id,
437: mdp.revision
438: FROM msd_cs_defn_dim_dtls mcdd,
439: msd_dp_parameters mdp,
440: msd_cs_definitions mcd,
441: msd_dp_dimensions_v mdd
442: WHERE mdp.demand_plan_id = p_demand_plan_id
443: AND mdd.demand_plan_id = p_demand_plan_id

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 575: MSD_DP_PARAMETERS MPV1,

571: FROM MSD_CS_DEFINITIONS DEF1,
572: MSD_CS_DEFINITIONS DEF2,
573: MSD_CS_DEFN_DIM_DTLS DIM1,
574: MSD_CS_DEFN_DIM_DTLS DIM2,
575: MSD_DP_PARAMETERS MPV1,
576: MSD_DP_PARAMETERS MPV2
577: WHERE MPV1.DEMAND_PLAN_ID = p_demand_plan_id
578: AND DEF1.name = MPV1.parameter_type
579: AND DEF1.COMPOSITE_GROUP_CODE IS NOT NULL

Line 576: MSD_DP_PARAMETERS MPV2

572: MSD_CS_DEFINITIONS DEF2,
573: MSD_CS_DEFN_DIM_DTLS DIM1,
574: MSD_CS_DEFN_DIM_DTLS DIM2,
575: MSD_DP_PARAMETERS MPV1,
576: MSD_DP_PARAMETERS MPV2
577: WHERE MPV1.DEMAND_PLAN_ID = p_demand_plan_id
578: AND DEF1.name = MPV1.parameter_type
579: AND DEF1.COMPOSITE_GROUP_CODE IS NOT NULL
580: AND NVL(DEF1.ENABLE_FLAG,'Y') = 'Y'

Line 628: MSD_DP_PARAMETERS MPV1,

624: FROM MSD_CS_DEFINITIONS DEF1,
625: MSD_CS_DEFINITIONS DEF2,
626: MSD_CS_DEFN_DIM_DTLS DIM1,
627: MSD_CS_DEFN_DIM_DTLS DIM2,
628: MSD_DP_PARAMETERS MPV1,
629: MSD_DP_PARAMETERS MPV2
630: WHERE MPV1.DEMAND_PLAN_ID = p_demand_plan_id
631: AND DEF1.name = MPV1.parameter_type
632: AND NVL(DEF1.ENABLE_FLAG,'Y') = 'Y'

Line 629: MSD_DP_PARAMETERS MPV2

625: MSD_CS_DEFINITIONS DEF2,
626: MSD_CS_DEFN_DIM_DTLS DIM1,
627: MSD_CS_DEFN_DIM_DTLS DIM2,
628: MSD_DP_PARAMETERS MPV1,
629: MSD_DP_PARAMETERS MPV2
630: WHERE MPV1.DEMAND_PLAN_ID = p_demand_plan_id
631: AND DEF1.name = MPV1.parameter_type
632: AND NVL(DEF1.ENABLE_FLAG,'Y') = 'Y'
633: --AND NVL(DEF1.LOWEST_LEVEL_FLAG,1) = 0

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 2026: from msd_dp_parameters mdp,

2022: is
2023:
2024: cursor c_ascp_stream(p_demand_plan_id number) is
2025: select mdp.parameter_id
2026: from msd_dp_parameters mdp,
2027: msd_cs_definitions mcd,
2028: msc_plans mp
2029: where mdp.demand_plan_id = p_demand_plan_id
2030: and mdp.parameter_type = mcd.name

Line 2036: from msd_dp_parameters

2032: and mdp.parameter_name = mp.compile_designator;
2033:
2034: cursor c_non_ascp_stream(p_demand_plan_id number) is
2035: select parameter_id
2036: from msd_dp_parameters
2037: where demand_plan_id = p_demand_plan_id
2038: and parameter_id not in ( select mdp.parameter_id
2039: from msd_dp_parameters mdp,
2040: msd_cs_definitions mcd,

Line 2039: from msd_dp_parameters mdp,

2035: select parameter_id
2036: from msd_dp_parameters
2037: where demand_plan_id = p_demand_plan_id
2038: and parameter_id not in ( select mdp.parameter_id
2039: from msd_dp_parameters mdp,
2040: msd_cs_definitions mcd,
2041: msc_plans mp
2042: where mdp.demand_plan_id = p_demand_plan_id
2043: and mdp.parameter_type = mcd.name

Line 2055: update msd_dp_parameters

2051: open c_ascp_stream(p_demand_plan_id);
2052: loop
2053: fetch c_ascp_stream into l_parameter_id;
2054: exit when c_ascp_stream%NOTFOUND;
2055: update msd_dp_parameters
2056: set ascp_stream_flag='Y'
2057: where demand_plan_id=p_demand_plan_id
2058: and parameter_id =l_parameter_id;
2059: end loop;

Line 2066: update msd_dp_parameters

2062: open c_non_ascp_stream(p_demand_plan_id);
2063: loop
2064: fetch c_non_ascp_stream into l_parameter_id;
2065: exit when c_non_ascp_stream%NOTFOUND;
2066: update msd_dp_parameters
2067: set ascp_stream_flag='N'
2068: where demand_plan_id=p_demand_plan_id
2069: and parameter_id =l_parameter_id;
2070: end loop;

Line 2439: update msd_dp_parameters

2435: WHEN invalid_identifier THEN
2436:
2437: debug_out('Execution of Modified Validation Query Falied due to INVALID_IDENTIFIER.Executing Original Query.'); /* Bug 4741977 */
2438:
2439: update msd_dp_parameters
2440: set ascp_stream_flag='N'
2441: where demand_plan_id = p_demand_plan_id
2442: and parameter_id = c_input_rec.parameter_id;
2443:

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;