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_CL_PRE_PROCESS dependencies on MSD_HIERARCHY_LEVELS

Line 1007: cursor c1 is select count(*) from MSD_HIERARCHY_LEVELS

1003: IS
1004: lv_sql_stmt VARCHAR2(4000);
1005: lv_error_text VARCHAR2(250);
1006: lv_debug BOOLEAN := msc_cl_pre_process.v_debug;
1007: cursor c1 is select count(*) from MSD_HIERARCHY_LEVELS
1008: where LEVEL_ID = 11
1009: AND PARENT_LEVEL_ID = 15 ;
1010:
1011: lv_other_exist PLS_INTEGER := 0;

Line 2015: ||' FROM msd_hierarchy_levels mhl'

2011: 'UPDATE msd_st_level_associations mla'
2012: ||' SET process_flag ='||G_ERROR_FLG||','
2013: ||' error_text = '||''''||lv_message_text||''''
2014: ||' WHERE NOT EXISTS ( SELECT 1'
2015: ||' FROM msd_hierarchy_levels mhl'
2016: ||' WHERE mla.level_id = mhl.level_id'
2017: ||' AND mla.parent_level_id = mhl.parent_level_id)'
2018: ||' AND process_flag ='|| G_IN_PROCESS
2019: ||' AND batch_id = :lv_batch_id'