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_TERR_RSC_ALL

Line 1289: FROM jtf_terr_rsc_all jtr,

1285: AND jt1.end_date_active >= l_sysdate
1286: AND jt1.start_date_active <= l_sysdate
1287: AND EXISTS (
1288: SELECT 1
1289: FROM jtf_terr_rsc_all jtr,
1290: jtf_terr_rsc_access_all jtra,
1291: jtf_qual_types_all jqta
1292: WHERE jtr.terr_id = jt1.terr_id
1293: AND jtr.end_date_active >= l_sysdate

Line 2763: ' , jtf_terr_rsc_all jtr ' ||

2759: ' FROM ' || l_match_target || ' i ' ||
2760: ' WHERE i.worker_id = :bv_worker_id ) o ' ||
2761: ' WHERE o.TERR_RANK <= (SELECT NVL(t.num_winners, 1) FROM jtf_terr_all t WHERE t.terr_id = o.top_level_terr_id) ' ||
2762: ' ) WT ' ||
2763: ' , jtf_terr_rsc_all jtr ' ||
2764: ' , jtf_terr_rsc_access_all jtra ' ||
2765: ' , jtf_qual_types_all jqta ' ||
2766: ' , (SELECT ' ||
2767: ' max(role_id) role_id ' ||

Line 3547: ' , jtf_terr_rsc_all jtr ' ||

3543: ' FROM ' || l_mp_winner_target || ' a, ' || l_uwinner_target || ' b ' ||
3544: ' WHERE b.WORKER_ID = :bv_worker_id ' ||
3545: ' AND a.link = b.trans_object_id ' ||
3546: ' ) WINNERS ' ||
3547: ' , jtf_terr_rsc_all jtr ' ||
3548: ' , jtf_terr_rsc_access_all jtra ' ||
3549: ' , jtf_qual_types_all jqta ' ||
3550: ' , (SELECT ' ||
3551: ' max(role_id) role_id ' ||