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_EN_GEN_017 dependencies on IGS_CA_STAT

Line 562: igs_ca_stat cs,

558: SELECT currterm.alternate_code
559: FROM (SELECT ci.alternate_code
560: FROM igs_ca_inst ci,
561: igs_ca_type ct,
562: igs_ca_stat cs,
563: igs_ca_da_inst dai
564: WHERE ci.cal_type = ct.cal_type
565: AND ct.s_cal_cat = 'LOAD'
566: AND ci.cal_status = cs.cal_status

Line 718: igs_ca_stat cs

714: CURSOR c_alt_code IS
715: SELECT ci.alternate_code
716: FROM igs_ca_inst ci,
717: igs_ca_type ca,
718: igs_ca_stat cs
719: WHERE ci.cal_type =ca.cal_type
720: AND ci.cal_status = cs.cal_status
721: AND cs.s_cal_status = 'ACTIVE'
722: AND ca.s_cal_cat = 'LOAD'

Line 1263: igs_ca_stat cs

1259: SELECT ci.cal_type,
1260: ci.sequence_number
1261: FROM igs_ca_inst ci,
1262: igs_ca_type ca,
1263: igs_ca_stat cs
1264: WHERE ci.alternate_code = p_term_alt_code
1265: AND ci.cal_type = ca.cal_type
1266: AND ci.cal_status = cs.cal_status
1267: AND cs.s_cal_status = 'ACTIVE'