APPS.MSD_VALIDATE_DEMAND_PLAN dependencies on MSD_CS_DEFINITIONS

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 306: msd_cs_definitions csd,

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'
310: AND mdp.demand_plan_id (+) = mds.demand_plan_id

Line 440: msd_cs_definitions mcd,

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
444: AND mdd.dimension_code = mcdd.dimension_code

Line 539: FROM msd_cs_definitions_vl,

535: nvl(planning_server_view_name,'MSD_CS_DATA_V'),
536: planning_server_view_name_ds),
537: planning_server_view_name_ds),
538: planning_server_view_name
539: FROM msd_cs_definitions_vl,
540: msd_demand_plans mdp
541: WHERE cs_definition_id = p_cs_def_id
542: and mdp.demand_plan_id = p_demand_plan_id;
543:

Line 571: FROM MSD_CS_DEFINITIONS DEF1,

567: --
568: CURSOR chk_comp_group(p_demand_plan_id NUMBER) IS
569: SELECT DISTINCT DEF2.DESCRIPTION DESCRIPTION,
570: DEF2.COMPOSITE_GROUP_CODE COMPOSITE_GROUP_CODE
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,

Line 572: MSD_CS_DEFINITIONS DEF2,

568: CURSOR chk_comp_group(p_demand_plan_id NUMBER) IS
569: SELECT DISTINCT DEF2.DESCRIPTION DESCRIPTION,
570: DEF2.COMPOSITE_GROUP_CODE COMPOSITE_GROUP_CODE
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

Line 624: FROM MSD_CS_DEFINITIONS DEF1,

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

Line 625: MSD_CS_DEFINITIONS DEF2,

621: DEF2.SYSTEM_FLAG SYSTEM_FLAG2,
622: DEF1.MULTIPLE_STREAM_FLAG MULTI_STREAM_FLAG1,
623: DEF2.MULTIPLE_STREAM_FLAG MULTI_STREAM_FLAG2
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

Line 1302: from msd_cs_definitions

1298: x_is_dp_hier_level number;
1299:
1300: cursor get_cs_name (p_cs_definition_id in number) is
1301: select name
1302: from msd_cs_definitions
1303: where cs_definition_id = p_cs_definition_id;
1304:
1305: /* Bug #5464757 */
1306: Cursor COL_DIM_IN_PARA(P_PARA_TYPE in varchar2) is

Line 1315: FROM MSD_CS_DEFINITIONS MCDS

1311: (SELECT MCD.DIMENSION_CODE
1312: FROM MSD_CS_DEFN_DIM_DTLS MCD
1313: WHERE MCD.CS_DEFINITION_ID IN
1314: (select MCDS.CS_DEFINITION_ID
1315: FROM MSD_CS_DEFINITIONS MCDS
1316: WHERE MCDS.NAME = P_PARA_TYPE)
1317: and mcd.collect_flag='Y')
1318: AND MDD.DIMENSION_CODE IN
1319: (SELECT MCD.DIMENSION_CODE

Line 1323: FROM MSD_CS_DEFINITIONS MCDS

1319: (SELECT MCD.DIMENSION_CODE
1320: FROM MSD_CS_DEFN_DIM_DTLS MCD
1321: WHERE MCD.CS_DEFINITION_ID IN
1322: (select MCDS.CS_DEFINITION_ID
1323: FROM MSD_CS_DEFINITIONS MCDS
1324: WHERE MCDS.NAME = P_PARA_TYPE)
1325: and mcd.collect_flag='Y');
1326:
1327: Begin

Line 2027: msd_cs_definitions mcd,

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
2031: and nvl(mcd.MULTIPLE_STREAM_FLAG,'N') = 'Y'

Line 2040: msd_cs_definitions mcd,

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
2044: and nvl(mcd.MULTIPLE_STREAM_FLAG,'N') = 'Y'

Line 2119: from msd_cs_definitions

2115: * which rows are deleted...for Net Change
2116: */
2117: cursor get_stream_type(p_cs_definition_id number) is
2118: select cs_type
2119: from msd_cs_definitions
2120: where cs_definition_id = p_cs_definition_id;
2121:
2122: /* Stream type for Custom Stream */
2123: x_stream_type varchar2(30);

Line 2888: lv_previous_stream msd_cs_definitions.name%TYPE := '##'; --Previous stream verified

2884: Procedure chk_composite_group_level (p_demand_plan_id in number) is
2885: lv_level_id1 msd_levels.level_id%TYPE := 0;
2886: lv_level_id2 msd_levels.level_id%TYPE := 0;
2887: lv_date_column_name msd_cs_defn_column_dtls.planning_view_column_name%TYPE;
2888: lv_previous_stream msd_cs_definitions.name%TYPE := '##'; --Previous stream verified
2889: lv_level_differ Number :=2; --1-Yes and 2-No
2890:
2891: Begin
2892:

Line 3019: from msd_cs_definitions

3015:
3016: /* Added to check if custom stream is Input Scenario */
3017: cursor get_cs_name (p_cs_definition_id in number) is
3018: select name
3019: from msd_cs_definitions
3020: where cs_definition_id = p_cs_definition_id;
3021:
3022: x_name varchar2(100);
3023: x_input_scenario varchar2(100) := 'MSD_INPUT_SCENARIO';