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_QUAL_USGS_ALL

Line 100: , jtf_qual_usgs_all jqu

96: IS
97: select seed.name, count(*) value_count
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

Line 120: , jtf_qual_usgs_all jqu

116: IS
117: select seed.name, count(*) value_count
118: from jtf_terr_values_all jtv, jtf_terr_qual_all jtq
119: , jtf_seeded_qual_all_b seed
120: , jtf_qual_usgs_all jqu
121: where jtv.terr_qual_id = jtq.terr_qual_id
122: and jtq.qual_usg_id = jqu.qual_usg_id
123: and jqu.seeded_qual_id = seed.seeded_qual_id
124: and jqu.org_id = -3113

Line 157: , jtf_qual_usgs_all jqu

153: AND q.qual_usg_id <> -1102
154: AND NOT ( q.qual_usg_id = -1012 AND
155: ( v.comparison_operator = 'LIKE' OR v.comparison_operator = 'BETWEEN' )
156: )) mv
157: , jtf_qual_usgs_all jqu
158: , jtf_seeded_qual_all_b seed
159: where mv.qual_usg_id = jqu.qual_usg_id
160: and jqu.seeded_qual_id = seed.seeded_qual_id
161: and jqu.org_id = -3113

Line 170: , jtf_qual_usgs_all jqu

166: CURSOR C_values_in_System(lc_source_id NUMBER)
167: IS
168: select seed.name, jtv.comparison_operator operator, count(*) value_count
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

Line 190: , jtf_qual_usgs_all jqu

186: CURSOR C_values_in_system_ALL(lc_source_id NUMBER)
187: IS
188: select seed.name, jtv.comparison_operator operator, count(*) value_count
189: from jtf_terr_values_all jtv, jtf_terr_qual_all jtq
190: , jtf_qual_usgs_all jqu
191: , jtf_seeded_qual_all_b seed
192: where jtv.terr_qual_id = jtq.terr_qual_id
193: and jtq.qual_usg_id = jqu.qual_usg_id
194: and jqu.seeded_qual_id = seed.seeded_qual_id

Line 205: , jtf_qual_usgs_all jqu

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,
209: jtf_terr_usgs_all jtu

Line 251: , jtf_qual_usgs_all jqu

247: AND q.qual_usg_id <> -1102
248: AND NOT ( q.qual_usg_id = -1012 AND
249: ( v.comparison_operator = 'LIKE' OR v.comparison_operator = 'BETWEEN' )
250: )) mv
251: , jtf_qual_usgs_all jqu
252: , jtf_seeded_qual_all_b seed
253: where mv.qual_usg_id = jqu.qual_usg_id
254: and jqu.seeded_qual_id = seed.seeded_qual_id
255: and jqu.org_id = -3113

Line 310: , jtf_qual_usgs_all jqu

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

Line 405: , jtf_qual_usgs_all jqu

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