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_GEN_PVT dependencies on JTF_TERR_USGS_ALL

Line 109: jtf_terr_usgs_all b

105: ( SELECT
106: a.terr_id terr_id,
107: b.source_id source_id
108: FROM jtf_terr_all a,
109: jtf_terr_usgs_all b
110: WHERE a.terr_id = b.terr_id
111: AND b.source_id = p_source_id
112: AND a.start_date_active >
113: (SELECT max(end_date)

Line 164: jtf_terr_usgs_all b

160: ( SELECT
161: a.terr_id terr_id,
162: b.source_id source_id
163: FROM jtf_terr_all a,
164: jtf_terr_usgs_all b
165: WHERE a.terr_id = b.terr_id
166: AND b.source_id = p_source_id
167: AND a.end_date_active >
168: (SELECT max(end_date)

Line 599: FROM jtf_terr_usgs_all jtu

595: ,'I' hier_processing_flag
596: ,'Y' matching_sql_flag
597: ,jta1.start_date_active start_date
598: ,jta1.end_date_active end_date
599: FROM jtf_terr_usgs_all jtu
600: , jtf_terr_all jta1
601: , jtf_terr_all jta2
602: WHERE jtu.source_id = lp_source_id
603: AND jtu.terr_id = jta1.terr_id