APPS.JTF_TERR_DIAGNOSTIC_TEST dependencies on JTF_TERR_ALL

Line 102: and jtq.terr_id IN ( select jt.terr_id from jtf_terr_all jt,

98: from jtf_terr_values_all jtv, jtf_terr_qual_all jtq
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

Line 173: and jtq.terr_id IN ( select jt.terr_id from jtf_terr_all jt,

169: from jtf_terr_values_all jtv, jtf_terr_qual_all jtq
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

Line 204: , jtf_terr_all jta

200: CURSOR C_values_in_System_warnings(lc_source_id NUMBER)
201: IS
202: select jta.name terr_name ,seed.name qual_name, jtv.comparison_operator operator, count(*) value_count
203: from jtf_terr_values_all jtv, jtf_terr_qual_all jtq
204: , jtf_terr_all jta
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,

Line 208: and jtq.terr_id IN ( select jt.terr_id from jtf_terr_all jt,

204: , jtf_terr_all jta
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

Line 312: and jtq.terr_id IN ( select jt.terr_id from jtf_terr_all jt,

308: into l_percent_count
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

Line 407: and jtq.terr_id IN ( select jt.terr_id from jtf_terr_all jt,

403: into l_percent_count
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

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 474: and jtq.terr_id IN ( select jt.terr_id from jtf_terr_all jt,

470: select count(*)
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