APPS.JTF_TAE_CONTROL_PVT dependencies on JTF_QUAL_TYPE_USGS

Line 184: jtf_qual_type_usgs jqtu

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
188: and jqua.qual_type_usg_id = jqtu.qual_type_usg_id

Line 199: jtf_qual_type_usgs jqtu

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
203: and jqua.org_id = -3113

Line 220: ,jtf_qual_type_usgs_all jqtu

216: cursor qual_rel_sets(cl_qual_type_id number) is
217: SELECT count(*) total_count, jtqu.qual_relation_product
218: FROM jtf_terr_denorm_rules_all jtdr
219: ,jtf_terr_qtype_usgs_all jtqu
220: ,jtf_qual_type_usgs_all jqtu
221: WHERE 1=1
222: --and org_id = -3113
223: /* JDOCHERT: 07/29/03: BUG# :
224: ** JTF_TAE_QUAL_PRODUCTS NOT BEING CORRECTLY POPULATED SINCE

Line 252: -- select * from jtf_qual_type_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
252: -- select * from jtf_qual_type_usgs_all
253: -- where source_id = cl_source_id
254: -- and qual_type_id <> -1001;
255:
256: BEGIN

Line 300: FROM jtf_qual_type_usgs_all jqtu

296: UPDATE jtf_terr_qtype_usgs_all jtqu
297: SET jtqu.QUAL_RELATION_PRODUCT = 1
298: WHERE jtqu.qual_type_usg_id = (
299: SELECT jqtu.qual_type_usg_id
300: FROM jtf_qual_type_usgs_all jqtu
301: WHERE jqtu.source_id = p_source_id
302: AND jqtu.qual_type_id = p_trans_id
303: );
304:

Line 374: ,jtf_qual_type_usgs_all ijqtu

370: WHERE jtqu.terr_id IN
371: ( SELECT ijtdr.terr_id
372: FROM jtf_terr_denorm_rules_all ijtdr
373: ,jtf_terr_qtype_usgs_all ijtqu
374: ,jtf_qual_type_usgs_all ijqtu
375: ,jtf_terr_qual_all jtq
376: WHERE ijtdr.source_id = l_source_id
377: AND ijqtu.source_id = ijtdr.source_id
378: AND ijqtu.qual_type_id = l_trans_id

Line 386: FROM jtf_qual_type_usgs_all jqtu

382: AND jtq.qual_usg_id = qual_rel.qual_usg_id
383: )
384: AND jtqu.qual_type_usg_id = (
385: SELECT jqtu.qual_type_usg_id
386: FROM jtf_qual_type_usgs_all jqtu
387: WHERE jqtu.source_id = l_source_id
388: AND jqtu.qual_type_id = l_trans_id
389: );
390: