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_DEM_UPLOAD_FORECAST dependencies on MSD_DP_SCN_OUTPUT_LEVELS_V

Line 482: select nvl((select 1 from msd_dp_scn_output_levels_v

478: RETURN NUMBER
479: IS
480:
481: CURSOR FCST_AT_ITEM(data_profile_id in NUMBER) is
482: select nvl((select 1 from msd_dp_scn_output_levels_v
483: WHERE demand_plan_id = 5555555
484: and scenario_id = data_profile_id + 5555555
485: and level_id = 1),0) from dual;
486:

Line 488: select nvl((select 1 from msd_dp_scn_output_levels_v

484: and scenario_id = data_profile_id + 5555555
485: and level_id = 1),0) from dual;
486:
487: CURSOR FCST_AT_GEO(data_profile_id in NUMBER) is
488: select nvl((select 1 from msd_dp_scn_output_levels_v
489: WHERE demand_plan_id = 5555555
490: and scenario_id = data_profile_id + 5555555
491: and level_id = 11),0) from dual;
492:

Line 494: select nvl((select 1 from msd_dp_scn_output_levels_v

490: and scenario_id = data_profile_id + 5555555
491: and level_id = 11),0) from dual;
492:
493: CURSOR FCST_AT_ORG(data_profile_id in NUMBER) is
494: select nvl((select 1 from msd_dp_scn_output_levels_v
495: WHERE demand_plan_id = 5555555
496: and scenario_id = data_profile_id + 5555555
497: and level_id = 7),0) from dual;
498: