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 DUAL

Line 485: and level_id = 1),0) from dual;

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

Line 491: and level_id = 11),0) from dual;

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

Line 497: and level_id = 7),0) from dual;

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:
499: fc_item number;
500: fc_geo number;
501: fc_org number;