APPS.JTF_TAE_CONTROL_PVT dependencies on JTF_QUAL_TYPE_DENORM_V

Line 185: , jtf_qual_type_denorm_v v

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
189: AND jqtu.source_id = cl_source_id ---1001

Line 205: FROM jtf_qual_type_denorm_v

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
204: and jqtu.qual_type_id in (SELECT related_id
205: FROM jtf_qual_type_denorm_v
206: WHERE qual_type_id = cl_qual_type_id);
207: */
208: -- POPULATION OF QUAL_PRODUCT/FACTOR TABLES
209: -- ( CURSOR BUILD CONTROL )