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_SS_ENR_DETAILS dependencies on IGS_PS_UNIT_VER_ALL

Line 3398: igs_ps_unit_ver_all uv

3394:
3395: CURSOR c_uv_title(cp_n_uoo_id IN NUMBER) IS
3396: SELECT uv.title
3397: FROM igs_ps_unit_ofr_opt_all us,
3398: igs_ps_unit_ver_all uv
3399: WHERE us.uoo_id = cp_n_uoo_id
3400: AND us.unit_cd = uv.unit_cd
3401: AND us.version_number = uv.version_number;
3402:

Line 3403: l_c_title igs_ps_unit_ver_all.title%TYPE;

3399: WHERE us.uoo_id = cp_n_uoo_id
3400: AND us.unit_cd = uv.unit_cd
3401: AND us.version_number = uv.version_number;
3402:
3403: l_c_title igs_ps_unit_ver_all.title%TYPE;
3404: BEGIN
3405: OPEN c_us_title (p_n_uoo_id);
3406: FETCH c_us_title INTO l_c_title;
3407: CLOSE c_us_title;

Line 4468: igs_ps_unit_ver_all uv

4464: CURSOR c_uv_title(cp_n_uoo_id IN NUMBER) IS
4465: SELECT t.subtitle
4466: FROM igs_ps_unit_subtitle t,
4467: igs_ps_unit_ofr_opt_all us,
4468: igs_ps_unit_ver_all uv
4469: WHERE us.uoo_id = cp_n_uoo_id
4470: AND us.unit_cd = uv.unit_cd
4471: AND us.version_number = uv.version_number
4472: AND uv.subtitle_id = t.subtitle_id;