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

Line 293: from jtf_terr_all jta,

289: jta.terr_id,
290: jta.name,
291: jta.rank,
292: p_session_id
293: from jtf_terr_all jta,
294: jtf_terr_rsc_all jtra
295: where jta.terr_id = jtra.terr_id
296: and (jtra.resource_id = p_resource_id or p_resource_id = -999)
297: and (jtra.group_id = p_group_id or p_group_id =-999)

Line 300: FROM jtf_terr_all jt

296: and (jtra.resource_id = p_resource_id or p_resource_id = -999)
297: and (jtra.group_id = p_group_id or p_group_id =-999)
298: AND NOT EXISTS (
299: SELECT jt.terr_id
300: FROM jtf_terr_all jt
301: WHERE ( ( NVL(jt.end_date_active, lp_sysdate) <= NVL(lp_active_date, lp_sysdate) ) OR
302: ( NVL(jt.start_date_active, lp_sysdate) > NVL(lp_active_date, lp_sysdate) )
303: )
304: CONNECT BY PRIOR jt.parent_territory_id = jt.terr_id AND jt.terr_id <> 1