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

Line 4871: from jtf_terr_rsc_ALL j, jtf_terr_ALL jt

4867: l_terr_ids_tbl Terr_Ids_Tbl_Type;
4868:
4869: CURSOR csr_terr_rsc(l_resource_id NUMBER, l_resource_type VARCHAR) IS
4870: select j.terr_id
4871: from jtf_terr_rsc_ALL j, jtf_terr_ALL jt
4872: where j.resource_id = l_resource_id
4873: and j.resource_type = l_resource_type
4874: and j.terr_id = jt.terr_id
4875: and jt.template_flag = 'N'

Line 4883: from JTF_TERR_ALL jt

4879: and not jt.terr_id = 1;
4880:
4881: CURSOR csr_unassigned_terrs IS
4882: select terr_id
4883: from JTF_TERR_ALL jt
4884: where NOT EXISTS (select jtr.terr_id
4885: from jtf_terr_rsc_ALL jtr
4886: where jt.terr_id = jtr.terr_id
4887: )