APPS.JTF_TAE_CONTROL_PVT dependencies on JTF_QUAL_USGS_ALL

Line 183: FROM jtf_qual_usgs_all jqua,

179:
180: -- BUILD QUAL_RELATION_PRODUCT
181: cursor qual_rel_facts(cl_source_id number, cl_qual_type_id number) is
182: SELECT jqua.qual_usg_id, jqua.qual_relation_factor, jqua.org_id
183: FROM jtf_qual_usgs_all jqua,
184: jtf_qual_type_usgs jqtu
185: , jtf_qual_type_denorm_v v
186: WHERE qual_relation_factor IS NOT NULL
187: and jqua.org_id = -3113

Line 193: FROM jtf_qual_usgs_all iq

189: AND jqtu.source_id = cl_source_id ---1001
190: and jqtu.qual_type_id = v.related_id
191: AND v.qual_type_id = cl_qual_type_id -- -1002
192: AND EXISTS ( SELECT iq.qual_usg_id
193: FROM jtf_qual_usgs_all iq
194: WHERE enabled_flag = 'Y'
195: AND iq.qual_usg_id = jqua.qual_usg_id );
196:
197: /* SELECT jqua.qual_usg_id, jqua.qual_relation_factor, jqua.org_id

Line 198: FROM jtf_qual_usgs_all jqua,

194: WHERE enabled_flag = 'Y'
195: AND iq.qual_usg_id = jqua.qual_usg_id );
196:
197: /* SELECT jqua.qual_usg_id, jqua.qual_relation_factor, jqua.org_id
198: FROM jtf_qual_usgs_all jqua,
199: jtf_qual_type_usgs jqtu
200: WHERE
201: jqua.qual_type_usg_id = jqtu.qual_type_usg_id
202: and qual_relation_factor is not null

Line 242: from jtf_qual_usgs_all jqua

238: ORDER BY total_count DESC;
239:
240: cursor quals_used(qual_relation_product number) is
241: select distinct qual_usg_id -- distinct not really needed
242: from jtf_qual_usgs_all jqua
243: where mod(qual_relation_product, jqua.qual_relation_factor) = 0
244: and org_id = -3113;
245:
246: cursor qual_details(cl_qual_usg_id number) is

Line 247: select * from jtf_qual_usgs_all

243: where mod(qual_relation_product, jqua.qual_relation_factor) = 0
244: and org_id = -3113;
245:
246: cursor qual_details(cl_qual_usg_id number) is
247: select * from jtf_qual_usgs_all
248: where qual_usg_id = cl_qual_usg_id
249: and org_id = -3113;
250:
251: -- cursor non_rsc_qual_types(cl_source_id number) is

Line 944: from jtf_qual_usgs_all

940: order by f.input_selectivity
941: )
942: ) ilv1,
943: (select qual_usg_id, 1 row_count
944: from jtf_qual_usgs_all
945: where org_id = -3113
946: and seeded_qual_id = -1012
947: ) ilv2
948: where ilv1.qual_usg_id = ilv2.qual_usg_id