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_PS_VALIDATE_GENERIC_PKG dependencies on IGS_AS_US_AI_GROUP

Line 1811: FROM igs_as_us_ai_group

1807: NVL (final_weight_qty, 0) group_final_weight_qty,
1808: NVL (midterm_weight_qty, 0) group_midterm_weight_qty,
1809: NVL (final_formula_qty, 0) group_final_formula_qty,
1810: NVL (midterm_formula_qty, 0) group_midterm_formula_qty
1811: FROM igs_as_us_ai_group
1812: WHERE uoo_id = cp_uoo_id;
1813:
1814: CURSOR cur_ai (cp_us_ass_item_group_id IN NUMBER ) IS
1815: SELECT NVL (SUM (final_weight_qty), 0) sum_final_weight_qty,

Line 1825: FROM igs_as_us_ai_group a, igs_ps_unit_ofr_opt_all b, igs_ca_inst_all c

1821: AND logical_delete_dt IS NULL;
1822:
1823: CURSOR cur_group (cp_rec_as_us_ai igs_ps_generic_pub.usec_ass_item_grp_rec_type) IS
1824: SELECT a.us_ass_item_group_id
1825: FROM igs_as_us_ai_group a, igs_ps_unit_ofr_opt_all b, igs_ca_inst_all c
1826: WHERE a.group_name = cp_rec_as_us_ai.group_name
1827: AND a.uoo_id =b.uoo_id
1828: AND b.unit_cd=cp_rec_as_us_ai.unit_cd
1829: AND b.version_number=cp_rec_as_us_ai.version_number