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

Line 103: jtf_terr_usgs_all jtu

99: , jtf_seeded_qual_all_b seed
100: , jtf_qual_usgs_all jqu
101: where jtv.terr_qual_id = jtq.terr_qual_id
102: and jtq.terr_id IN ( select jt.terr_id from jtf_terr_all jt,
103: jtf_terr_usgs_all jtu
104: where jtu.source_id = lc_source_id
105: and jtu.terr_id = jt.terr_id
106: and jt.start_date_active <= SYSDATE
107: and NVL(jt.end_date_active, SYSDATE) >= SYSDATE )

Line 174: jtf_terr_usgs_all jtu

170: , jtf_qual_usgs_all jqu
171: , jtf_seeded_qual_all_b seed
172: where jtv.terr_qual_id = jtq.terr_qual_id
173: and jtq.terr_id IN ( select jt.terr_id from jtf_terr_all jt,
174: jtf_terr_usgs_all jtu
175: where jtu.source_id = lc_source_id
176: and jtu.terr_id = jt.terr_id
177: and jt.start_date_active <= SYSDATE
178: AND NVL(jt.end_date_active, SYSDATE) >= SYSDATE )

Line 209: jtf_terr_usgs_all jtu

205: , jtf_qual_usgs_all jqu
206: , jtf_seeded_qual_all_b seed
207: where jtv.terr_qual_id = jtq.terr_qual_id
208: and jtq.terr_id IN ( select jt.terr_id from jtf_terr_all jt,
209: jtf_terr_usgs_all jtu
210: where jtu.source_id = lc_source_id
211: and jtu.terr_id = jt.terr_id
212: and jt.start_date_active <= SYSDATE
213: AND NVL(jt.end_date_active, SYSDATE) >= SYSDATE )

Line 313: jtf_terr_usgs_all jtu

309: from jtf_terr_values_all jtv, jtf_terr_qual_all jtq
310: , jtf_qual_usgs_all jqu
311: where jtv.terr_qual_id = jtq.terr_qual_id
312: and jtq.terr_id IN ( select jt.terr_id from jtf_terr_all jt,
313: jtf_terr_usgs_all jtu
314: where jtu.source_id = l_source_id
315: and jtu.terr_id = jt.terr_id
316: and jt.start_date_active <= SYSDATE
317: AND NVL(jt.end_date_active, SYSDATE) >= SYSDATE )

Line 408: jtf_terr_usgs_all jtu

404: from jtf_terr_values_all jtv, jtf_terr_qual_all jtq
405: , jtf_qual_usgs_all jqu
406: where jtv.terr_qual_id = jtq.terr_qual_id
407: and jtq.terr_id IN ( select jt.terr_id from jtf_terr_all jt,
408: jtf_terr_usgs_all jtu
409: where jtu.source_id = l_source_id
410: and jtu.terr_id = jt.terr_id
411: and jt.start_date_active <= SYSDATE
412: AND NVL(jt.end_date_active, SYSDATE) >= SYSDATE )

Line 432: from jtf_terr_all jta, jtf_terr_usgs_all jtua

428: --#1. Number of ACTIVE Territories
429: --======================================
430: select count(*)
431: into l_active_sales_terrs
432: from jtf_terr_all jta, jtf_terr_usgs_all jtua
433: where jtua.terr_id = jta.terr_id
434: and jtua.source_id = l_source_id
435: and jta.start_date_active <= SYSDATE
436: AND NVL(jta.end_date_active, SYSDATE) >= SYSDATE;

Line 475: jtf_terr_usgs_all jtu

471: into l_num_values
472: from jtf_terr_values_all jtv, jtf_terr_qual_all jtq
473: where jtv.terr_qual_id = jtq.terr_qual_id
474: and jtq.terr_id IN ( select jt.terr_id from jtf_terr_all jt,
475: jtf_terr_usgs_all jtu
476: where jtu.source_id = l_source_id
477: and jtu.terr_id = jt.terr_id
478: and jt.start_date_active <= SYSDATE
479: AND NVL(jt.end_date_active, SYSDATE + 1) >= SYSDATE );