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.IGS_UC_LOAD_HERCULES_DATA dependencies on IGS_UC_IVNSTARK_2007_V

Line 7994: FROM igs_uc_ivnstark_2007_v

7990: ,RTRIM(status) status
7991: ,firmnow
7992: ,ukentrydate
7993: ,DECODE(RTRIM(eas),'Y','E',RTRIM(eas) ) eas
7994: FROM igs_uc_ivnstark_2007_v
7995: WHERE ( timestamp > p_timestamp OR p_timestamp IS NULL ) ;
7996:
7997: -- get the max timestamp value of the hercules view
7998: CURSOR c_max_timestamp IS

Line 8000: FROM igs_uc_ivnstark_2007_v ;

7996:
7997: -- get the max timestamp value of the hercules view
7998: CURSOR c_max_timestamp IS
7999: SELECT MAX(timestamp)
8000: FROM igs_uc_ivnstark_2007_v ;
8001:
8002: -- Variables
8003: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;
8004: l_new_max_timestamp igs_uc_ivnstark_2007_v.timestamp%TYPE ;

Line 8004: l_new_max_timestamp igs_uc_ivnstark_2007_v.timestamp%TYPE ;

8000: FROM igs_uc_ivnstark_2007_v ;
8001:
8002: -- Variables
8003: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;
8004: l_new_max_timestamp igs_uc_ivnstark_2007_v.timestamp%TYPE ;
8005: l_count NUMBER ;
8006:
8007: l_appno igs_uc_istark_ints.appno%TYPE;
8008: l_checkdigit NUMBER;