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_TERR_ENGINE_GEN2_PVT dependencies on JTF_TERR_ALL

Line 1088: ,jtf_terr_all jt

1084: AND jqu.real_time_select IS NOT NULL
1085: AND v.qual_type_id = lp_trans_id
1086: AND EXISTS ( SELECT jtq.terr_id
1087: FROM jtf_terr_qtype_usgs_all jtqu
1088: ,jtf_terr_all jt
1089: ,jtf_terr_qual_all jtq
1090: ,jtf_qual_type_usgs jqtu
1091: WHERE jt.end_date_active >= lp_start_date
1092: AND jt.start_date_active <= lp_end_date

Line 1486: , jtf_terr_all jt1

1482: IF (p_mode = 'DATE EFFECTIVE' or p_mode = 'DEA INCREMENTAL') THEN
1483: SELECT COUNT (jt1.terr_id)
1484: INTO l_num_of_terr
1485: FROM jtf_terr_qtype_usgs_all jtqu
1486: , jtf_terr_all jt1
1487: , jtf_qual_type_usgs jqtu
1488: WHERE jtqu.terr_id = jt1.terr_id
1489: AND jqtu.qual_type_usg_id = jtqu.qual_type_usg_id
1490: AND jqtu.qual_type_id = p_trans_id

Line 1518: , jtf_terr_all jt1

1514: ELSE
1515: SELECT COUNT(jt1.terr_id)
1516: INTO l_num_of_terr
1517: FROM jtf_terr_qtype_usgs_all jtqu
1518: , jtf_terr_all jt1
1519: , jtf_qual_type_usgs jqtu
1520: WHERE jtqu.terr_id = jt1.terr_id
1521: AND jqtu.qual_type_usg_id = jtqu.qual_type_usg_id
1522: AND jqtu.qual_type_id = p_trans_id