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 119: jtf_terr_usgs_all b

115: ( SELECT
116: a.terr_id terr_id,
117: b.source_id source_id
118: FROM jtf_terr_all a,
119: jtf_terr_usgs_all b
120: WHERE a.terr_id = b.terr_id
121: AND b.source_id = p_source_id
122: AND a.start_date_active >
123: (SELECT max(end_date)

Line 174: jtf_terr_usgs_all b

170: ( SELECT
171: a.terr_id terr_id,
172: b.source_id source_id
173: FROM jtf_terr_all a,
174: jtf_terr_usgs_all b
175: WHERE a.terr_id = b.terr_id
176: AND b.source_id = p_source_id
177: AND a.end_date_active >
178: (SELECT max(end_date)

Line 836: FROM jtf_terr_usgs_all jtu

832: ,'I' hier_processing_flag
833: ,'Y' matching_sql_flag
834: ,jta1.start_date_active start_date
835: ,jta1.end_date_active end_date
836: FROM jtf_terr_usgs_all jtu
837: , jtf_terr_all jta1
838: , jtf_terr_all jta2
839: WHERE jtu.source_id = lp_source_id
840: AND jtu.terr_id = jta1.terr_id