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_SEEDED_QUAL_ALL_B

Line 99: , jtf_seeded_qual_all_b seed

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

Line 119: , jtf_seeded_qual_all_b seed

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
123: and jqu.seeded_qual_id = seed.seeded_qual_id

Line 158: , jtf_seeded_qual_all_b seed

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
162: and (seed.org_id = -3114 OR seed.org_id is null)

Line 171: , jtf_seeded_qual_all_b seed

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
175: where jtu.source_id = lc_source_id

Line 191: , jtf_seeded_qual_all_b seed

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
195: and jqu.org_id = -3113

Line 206: , jtf_seeded_qual_all_b seed

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
210: where jtu.source_id = lc_source_id

Line 252: , jtf_seeded_qual_all_b seed

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
256: and (seed.org_id = -3114 OR seed.org_id is null)