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_DEFINITIONS

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

298: msd_cs_dfn_utl.get_planning_server_clmn(csd.cs_definition_id, mdp.FORECAST_DATE_USED) date_planning_view_clmn,
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

Line 436: msd_cs_definitions mcd,

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
439: AND mdd.demand_plan_id = p_demand_plan_id
440: AND mdd.dimension_code = mcdd.dimension_code

Line 534: FROM msd_cs_definitions_vl,

530: nvl(planning_server_view_name,'MSD_CS_DATA_V'),
531: planning_server_view_name_ds),
532: planning_server_view_name_ds),
533: planning_server_view_name
534: FROM msd_cs_definitions_vl,
535: msd_demand_plans mdp
536: WHERE cs_definition_id = p_cs_def_id
537: and mdp.demand_plan_id = p_demand_plan_id;
538:

Line 566: FROM MSD_CS_DEFINITIONS DEF1,

562: --
563: CURSOR chk_comp_group(p_demand_plan_id NUMBER) IS
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,

Line 567: MSD_CS_DEFINITIONS DEF2,

563: CURSOR chk_comp_group(p_demand_plan_id NUMBER) IS
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

Line 619: FROM MSD_CS_DEFINITIONS DEF1,

615: DEF1.SYSTEM_FLAG SYSTEM_FLAG1,
616: DEF2.SYSTEM_FLAG SYSTEM_FLAG2,
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,

Line 620: MSD_CS_DEFINITIONS DEF2,

616: DEF2.SYSTEM_FLAG SYSTEM_FLAG2,
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

Line 1297: from msd_cs_definitions

1293: x_is_dp_hier_level number;
1294:
1295: cursor get_cs_name (p_cs_definition_id in number) is
1296: select name
1297: from msd_cs_definitions
1298: where cs_definition_id = p_cs_definition_id;
1299:
1300: /* Bug #5464757 */
1301: Cursor COL_DIM_IN_PARA(P_PARA_TYPE in varchar2) is

Line 1310: FROM MSD_CS_DEFINITIONS MCDS

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)
1312: and mcd.collect_flag='Y')
1313: AND MDD.DP_DIMENSION_CODE IN
1314: (SELECT MCD.DIMENSION_CODE

Line 1318: FROM MSD_CS_DEFINITIONS MCDS

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)
1320: and mcd.collect_flag='Y')
1321: Union All
1322: SELECT MDD.DP_DIMENSION_CODE dim_code FROM MSD.msd_dP_dimensions MDD

Line 1330: FROM MSD_CS_DEFINITIONS MCDS

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)
1332: and mcd.collect_flag='Y')
1333: AND MDD.DIMENSION_CODE IN
1334: (SELECT MCD.DIMENSION_CODE

Line 1338: FROM MSD_CS_DEFINITIONS MCDS

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)
1340: and mcd.collect_flag='Y');
1341:
1342: Begin

Line 2076: from msd_cs_definitions

2072: * which rows are deleted...for Net Change
2073: */
2074: cursor get_stream_type(p_cs_definition_id number) is
2075: select cs_type
2076: from msd_cs_definitions
2077: where cs_definition_id = p_cs_definition_id;
2078:
2079: /* Stream type for Custom Stream */
2080: x_stream_type varchar2(30);

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

2751: Procedure chk_composite_group_level (p_demand_plan_id in number) is
2752: lv_level_id1 msd_levels.level_id%TYPE := 0;
2753: lv_level_id2 msd_levels.level_id%TYPE := 0;
2754: lv_date_column_name msd_cs_defn_column_dtls.planning_view_column_name%TYPE;
2755: lv_previous_stream msd_cs_definitions.name%TYPE := '##'; --Previous stream verified
2756: lv_level_differ Number :=2; --1-Yes and 2-No
2757:
2758: Begin
2759:

Line 2886: from msd_cs_definitions

2882:
2883: /* Added to check if custom stream is Input Scenario */
2884: cursor get_cs_name (p_cs_definition_id in number) is
2885: select name
2886: from msd_cs_definitions
2887: where cs_definition_id = p_cs_definition_id;
2888:
2889: x_name varchar2(100);
2890: x_input_scenario varchar2(100) := 'MSD_INPUT_SCENARIO';