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

Line 414: , jtf_qual_type_usgs jqtu

410: INTO num_of_terr
411: FROM jtf_terr_qtype_usgs_all jtqu
412: , jtf_terr_usgs_all jtu
413: , jtf_terr_all jt1
414: , jtf_qual_type_usgs jqtu
415: WHERE jtqu.terr_id = jt1.terr_id
416: AND jqtu.qual_type_usg_id = jtqu.qual_type_usg_id
417: AND jqtu.qual_type_id = p_trans_object_type_id
418: AND jtu.source_id = p_source_id

Line 1978: , jtf_qual_type_usgs jqtu

1974: INTO num_of_terr
1975: FROM jtf_terr_qtype_usgs_all jtqu
1976: , jtf_terr_usgs_all jtu
1977: , jtf_terr_all jt1
1978: , jtf_qual_type_usgs jqtu
1979: WHERE jtqu.terr_id = jt1.terr_id
1980: AND jqtu.qual_type_usg_id = jtqu.qual_type_usg_id
1981: AND jqtu.qual_type_id = p_trans_object_type_id
1982: AND jtu.source_id = p_source_id