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.

APPS.MSD_VALIDATE_DEMAND_PLAN dependencies on MSD_CS_DEFN_DIM_DTLS

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

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

Line 303: msd_cs_defn_dim_dtls cdd

299: cdd.collect_level_id
300: FROM msd_dp_scenarios mds,
301: msd_dp_parameters mdp,
302: msd_cs_definitions csd,
303: msd_cs_defn_dim_dtls cdd
304: WHERE mds.demand_plan_id = p_demand_plan_id
305: AND mds.enable_flag = 'Y'
306: AND mdp.demand_plan_id (+) = mds.demand_plan_id
307: AND mdp.parameter_type (+) = mds.forecast_based_on

Line 434: FROM msd_cs_defn_dim_dtls mcdd,

430: MSD_CS_DFN_UTL.get_planning_server_clmn(mcd.cs_definition_id, nvl(mdp.FORECAST_DATE_USED, 'END_DATE')) date_clmn,
431: mdp.input_demand_plan_id,
432: mdp.input_scenario_id,
433: mdp.revision
434: FROM msd_cs_defn_dim_dtls mcdd,
435: msd_dp_parameters mdp,
436: msd_cs_definitions mcd,
437: msd_dp_dimensions_v mdd
438: WHERE mdp.demand_plan_id = p_demand_plan_id

Line 568: MSD_CS_DEFN_DIM_DTLS DIM1,

564: SELECT DISTINCT DEF2.DESCRIPTION DESCRIPTION,
565: DEF2.COMPOSITE_GROUP_CODE COMPOSITE_GROUP_CODE
566: FROM MSD_CS_DEFINITIONS DEF1,
567: MSD_CS_DEFINITIONS DEF2,
568: MSD_CS_DEFN_DIM_DTLS DIM1,
569: MSD_CS_DEFN_DIM_DTLS DIM2,
570: MSD_DP_PARAMETERS MPV1,
571: MSD_DP_PARAMETERS MPV2
572: WHERE MPV1.DEMAND_PLAN_ID = p_demand_plan_id

Line 569: MSD_CS_DEFN_DIM_DTLS DIM2,

565: DEF2.COMPOSITE_GROUP_CODE COMPOSITE_GROUP_CODE
566: FROM MSD_CS_DEFINITIONS DEF1,
567: MSD_CS_DEFINITIONS DEF2,
568: MSD_CS_DEFN_DIM_DTLS DIM1,
569: MSD_CS_DEFN_DIM_DTLS DIM2,
570: MSD_DP_PARAMETERS MPV1,
571: MSD_DP_PARAMETERS MPV2
572: WHERE MPV1.DEMAND_PLAN_ID = p_demand_plan_id
573: AND DEF1.name = MPV1.parameter_type

Line 621: MSD_CS_DEFN_DIM_DTLS DIM1,

617: DEF1.MULTIPLE_STREAM_FLAG MULTI_STREAM_FLAG1,
618: DEF2.MULTIPLE_STREAM_FLAG MULTI_STREAM_FLAG2
619: FROM MSD_CS_DEFINITIONS DEF1,
620: MSD_CS_DEFINITIONS DEF2,
621: MSD_CS_DEFN_DIM_DTLS DIM1,
622: MSD_CS_DEFN_DIM_DTLS DIM2,
623: MSD_DP_PARAMETERS MPV1,
624: MSD_DP_PARAMETERS MPV2
625: WHERE MPV1.DEMAND_PLAN_ID = p_demand_plan_id

Line 622: MSD_CS_DEFN_DIM_DTLS DIM2,

618: DEF2.MULTIPLE_STREAM_FLAG MULTI_STREAM_FLAG2
619: FROM MSD_CS_DEFINITIONS DEF1,
620: MSD_CS_DEFINITIONS DEF2,
621: MSD_CS_DEFN_DIM_DTLS DIM1,
622: MSD_CS_DEFN_DIM_DTLS DIM2,
623: MSD_DP_PARAMETERS MPV1,
624: MSD_DP_PARAMETERS MPV2
625: WHERE MPV1.DEMAND_PLAN_ID = p_demand_plan_id
626: AND DEF1.name = MPV1.parameter_type

Line 1307: FROM MSD_CS_DEFN_DIM_DTLS MCD

1303: where MDD.demand_plan_id =p_demand_plan_id
1304: and MDD.dimension_code<>MDD.dp_dimension_code
1305: AND MDD.DIMENSION_CODE NOT IN
1306: (SELECT MCD.DIMENSION_CODE
1307: FROM MSD_CS_DEFN_DIM_DTLS MCD
1308: WHERE MCD.CS_DEFINITION_ID IN
1309: (select MCDS.CS_DEFINITION_ID
1310: FROM MSD_CS_DEFINITIONS MCDS
1311: WHERE MCDS.NAME = P_PARA_TYPE)

Line 1315: FROM MSD_CS_DEFN_DIM_DTLS MCD

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

Line 1327: FROM MSD_CS_DEFN_DIM_DTLS MCD

1323: where MDD.demand_plan_id =p_demand_plan_id
1324: and MDD.dimension_code<>MDD.dp_dimension_code
1325: AND MDD.DP_DIMENSION_CODE NOT IN
1326: (SELECT MCD.DIMENSION_CODE
1327: FROM MSD_CS_DEFN_DIM_DTLS MCD
1328: WHERE MCD.CS_DEFINITION_ID IN
1329: (select MCDS.CS_DEFINITION_ID
1330: FROM MSD_CS_DEFINITIONS MCDS
1331: WHERE MCDS.NAME = P_PARA_TYPE)

Line 1335: FROM MSD_CS_DEFN_DIM_DTLS MCD

1331: WHERE MCDS.NAME = P_PARA_TYPE)
1332: and mcd.collect_flag='Y')
1333: AND MDD.DIMENSION_CODE IN
1334: (SELECT MCD.DIMENSION_CODE
1335: FROM MSD_CS_DEFN_DIM_DTLS MCD
1336: WHERE MCD.CS_DEFINITION_ID IN
1337: (select MCDS.CS_DEFINITION_ID
1338: FROM MSD_CS_DEFINITIONS MCDS
1339: WHERE MCDS.NAME = P_PARA_TYPE)

Line 2085: from msd_cs_defn_dim_dtls

2081:
2082: /* Find the collect level id for time */
2083: cursor get_col_lvl_id(p_cs_definition_id in number, p_dim_code in varchar2) is
2084: select collect_level_id
2085: from msd_cs_defn_dim_dtls
2086: where cs_definition_id = p_cs_definition_id
2087: and dimension_code = p_dim_code;
2088:
2089: /* Translate Time Level Id into Time Column in MSD_TIME */