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_TERR_ALL

Line 413: , jtf_terr_all jt1

409: SELECT COUNT(*)
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

Line 430: FROM jtf_terr_all jt

426: AND NVL(jtrs.start_date_active, lp_sysdate) <= lp_sysdate
427: AND jtrs.terr_id = jt1.terr_id )
428: AND NOT EXISTS (
429: SELECT jt.terr_id
430: FROM jtf_terr_all jt
431: WHERE NVL(jt.end_date_active, lp_sysdate + 1) < lp_sysdate
432: CONNECT BY PRIOR jt.parent_territory_id = jt.terr_id AND jt.terr_id <> 1
433: START WITH jt.terr_id = jt1.terr_id)
434: AND jqtu.qual_type_id <> -1001;

Line 1977: , jtf_terr_all jt1

1973: SELECT COUNT(*)
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

Line 1994: FROM jtf_terr_all jt

1990: AND NVL(jtrs.start_date_active, lp_sysdate) <= lp_sysdate
1991: AND jtrs.terr_id = jt1.terr_id )
1992: AND NOT EXISTS (
1993: SELECT jt.terr_id
1994: FROM jtf_terr_all jt
1995: WHERE NVL(jt.end_date_active, lp_sysdate + 1) < lp_sysdate
1996: CONNECT BY PRIOR jt.parent_territory_id = jt.terr_id AND jt.terr_id <> 1
1997: START WITH jt.terr_id = jt1.terr_id)
1998: AND jqtu.qual_type_id <> -1001;

Line 3750: ' , jtf_terr_all jt ' ||

3746: ' ORDER BY M.absolute_rank DESC, M.TERR_ID ) AS LL_TERR_RANK ' ||
3747: ' FROM ' || p_matches_target || ' M ' ||
3748: ' , jtf_terr_denorm_rules_all UL ' ||
3749: ' , ' || p_terr_L5_target_tbl || ' ML ' || /* FINAL LEVEL TABLE */
3750: ' , jtf_terr_all jt ' ||
3751: ' , jtf_terr_denorm_rules_all LL ' ||
3752: ' WHERE UL.level_from_root = 6 ' || /* UPPER level */
3753: ' AND UL.source_id = :b1_source_id ' ||
3754: ' AND UL.qual_type_id = :b1_qual_type_id ' ||