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.JTY_ASSIGN_BULK_PUB dependencies on JTF_QUAL_TYPE_USGS

Line 1366: , jtf_qual_type_usgs jqtu

1362: SELECT COUNT(*)
1363: INTO num_of_terr
1364: FROM jtf_terr_qtype_usgs_all jtqu
1365: , jtf_terr_all jt1
1366: , jtf_qual_type_usgs jqtu
1367: WHERE jtqu.terr_id = jt1.terr_id
1368: AND jqtu.qual_type_usg_id = jtqu.qual_type_usg_id
1369: AND jqtu.qual_type_id = p_trans_id
1370: AND jqtu.source_id = p_source_id