APPS.MSD_VALIDATE_DEMAND_PLAN dependencies on MSD_CS_DEFN_DIM_DTLS

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 307: msd_cs_defn_dim_dtls cdd

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
311: AND mdp.parameter_type (+) = mds.forecast_based_on

Line 438: FROM msd_cs_defn_dim_dtls mcdd,

434: MSD_CS_DFN_UTL.get_planning_server_clmn(mcd.cs_definition_id, nvl(mdp.FORECAST_DATE_USED, 'END_DATE')) date_clmn,
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

Line 573: MSD_CS_DEFN_DIM_DTLS DIM1,

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
577: WHERE MPV1.DEMAND_PLAN_ID = p_demand_plan_id

Line 574: MSD_CS_DEFN_DIM_DTLS DIM2,

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
577: WHERE MPV1.DEMAND_PLAN_ID = p_demand_plan_id
578: AND DEF1.name = MPV1.parameter_type

Line 626: MSD_CS_DEFN_DIM_DTLS DIM1,

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
630: WHERE MPV1.DEMAND_PLAN_ID = p_demand_plan_id

Line 627: MSD_CS_DEFN_DIM_DTLS DIM2,

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
630: WHERE MPV1.DEMAND_PLAN_ID = p_demand_plan_id
631: AND DEF1.name = MPV1.parameter_type

Line 1312: FROM MSD_CS_DEFN_DIM_DTLS MCD

1308: where MDD.demand_plan_id =p_demand_plan_id
1309: and MDD.dimension_code<>MDD.dp_dimension_code
1310: AND MDD.DP_DIMENSION_CODE NOT IN
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)

Line 1320: FROM MSD_CS_DEFN_DIM_DTLS MCD

1316: WHERE MCDS.NAME = P_PARA_TYPE)
1317: and mcd.collect_flag='Y')
1318: AND MDD.DIMENSION_CODE IN
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)

Line 2128: from msd_cs_defn_dim_dtls

2124:
2125: /* Find the collect level id for time */
2126: cursor get_col_lvl_id(p_cs_definition_id in number, p_dim_code in varchar2) is
2127: select collect_level_id
2128: from msd_cs_defn_dim_dtls
2129: where cs_definition_id = p_cs_definition_id
2130: and dimension_code = p_dim_code;
2131:
2132: /* Translate Time Level Id into Time Column in MSD_TIME */