APPS.JTF_TERR_DIAGNOSTIC_TEST dependencies on JTF_TERR_QUAL_ALL

Line 98: from jtf_terr_values_all jtv, jtf_terr_qual_all jtq

94:
95: CURSOR C_num_values(lc_source_id NUMBER)
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,

Line 118: from jtf_terr_values_all jtv, jtf_terr_qual_all jtq

114:
115: CURSOR C_num_values_ALL(lc_source_id NUMBER)
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

Line 148: , jtf_terr_qual_all q

144: , v.terr_value_id terr_value_id
145: , v.comparison_operator comparison_operator
146: , v.low_value_char_id low_value_char_id
147: FROM jtf_terr_denorm_rules_all r
148: , jtf_terr_qual_all q
149: , jtf_terr_values_all v
150: WHERE r.source_id = -1001
151: AND q.terr_id = r.related_terr_id
152: AND v.terr_qual_id = q.terr_qual_id

Line 169: from jtf_terr_values_all jtv, jtf_terr_qual_all jtq

165:
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,

Line 189: from jtf_terr_values_all jtv, jtf_terr_qual_all jtq

185:
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

Line 203: from jtf_terr_values_all jtv, jtf_terr_qual_all jtq

199:
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

Line 242: , jtf_terr_qual_all q

238: , v.terr_value_id terr_value_id
239: , v.comparison_operator comparison_operator
240: , v.low_value_char_id low_value_char_id
241: FROM jtf_terr_denorm_rules_all r
242: , jtf_terr_qual_all q
243: , jtf_terr_values_all v
244: WHERE r.source_id = -1001
245: AND q.terr_id = r.related_terr_id
246: AND v.terr_qual_id = q.terr_qual_id

Line 309: from jtf_terr_values_all jtv, jtf_terr_qual_all jtq

305: JTF_DIAGNOSTIC_COREAPI.brprint;
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

Line 404: from jtf_terr_values_all jtv, jtf_terr_qual_all jtq

400: JTF_DIAGNOSTIC_COREAPI.brprint;
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

Line 472: from jtf_terr_values_all jtv, jtf_terr_qual_all jtq

468: --#4. Total Number of Values in System
469: --=====================================
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