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_IVGOFFER_2006_V

Line 4665: FROM igs_uc_ivgoffer_2006_v

4661: SELECT appno
4662: ,roundno
4663: ,timestamp
4664: ,RTRIM(offertext) offertext
4665: FROM igs_uc_ivgoffer_2006_v
4666: WHERE ( timestamp > p_timestamp OR p_timestamp IS NULL ) ;
4667:
4668: -- get the max timestamp value of the odbc-link view
4669: CURSOR c_max_timestamp IS

Line 4671: FROM igs_uc_ivgoffer_2006_v ;

4667:
4668: -- get the max timestamp value of the odbc-link view
4669: CURSOR c_max_timestamp IS
4670: SELECT MAX(timestamp)
4671: FROM igs_uc_ivgoffer_2006_v ;
4672:
4673: -- Variables
4674: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;
4675: l_new_max_timestamp igs_uc_ivgoffer_2006_v.timestamp%TYPE ;

Line 4675: l_new_max_timestamp igs_uc_ivgoffer_2006_v.timestamp%TYPE ;

4671: FROM igs_uc_ivgoffer_2006_v ;
4672:
4673: -- Variables
4674: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;
4675: l_new_max_timestamp igs_uc_ivgoffer_2006_v.timestamp%TYPE ;
4676: l_appno igs_uc_ioffer_ints.appno%TYPE;
4677: l_checkdigit NUMBER;
4678: l_count NUMBER ;
4679: