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_AS_SUARC_LGCY_PUB dependencies on IGS_GE_REF_CD_TYPE

Line 207: FROM igs_ge_ref_cd refcd, igs_ge_ref_cd_type refcdt

203: l_number NUMBER;
204: CURSOR get_ref_code_id
205: IS
206: SELECT refcd.reference_code_id
207: FROM igs_ge_ref_cd refcd, igs_ge_ref_cd_type refcdt
208: WHERE refcd.reference_cd_type = refcdt.reference_cd_type
209: AND refcd.reference_cd = p_suarc_dtls_rec.reference_cd
210: AND refcd.reference_cd_type = p_suarc_dtls_rec.reference_cd_type;
211:

Line 333: FROM igs_ge_ref_cd refcd, igs_ge_ref_cd_type refcdt

329:
330: CURSOR cur_check_ref_cd_section_abv
331: IS
332: SELECT 'X'
333: FROM igs_ge_ref_cd refcd, igs_ge_ref_cd_type refcdt
334: WHERE refcd.reference_cd_type = refcdt.reference_cd_type
335: AND refcd.reference_cd = p_suarc_dtls_rec.reference_cd
336: AND refcd.reference_cd_type = p_suarc_dtls_rec.reference_cd_type
337: AND refcdt.UNIT_FLAG='Y'