APPS.JTY_TAE_INDEX_CREATION_PVT dependencies on JTF_TAE_QUAL_PROD_FACTORS

Line 837: , JTF_TAE_QUAL_PROD_FACTORS R

833: FROM jtf_terr_denorm_rules_all d
834: ,jtf_terr_qtype_usgs_all jtqu
835: ,jtf_qual_type_usgs_all jqtu
836: ,JTF_TAE_QUAL_PRODUCTS P
837: , JTF_TAE_QUAL_PROD_FACTORS R
838: WHERE jtqu.qual_relation_product = p.relation_product
839: AND jqtu.source_id = d.source_id
840: AND jqtu.qual_type_id = p.trans_object_type_id
841: AND d.terr_id = jtqu.terr_id

Line 855: JTF_TAE_QUAL_PROD_FACTORS J1

851: Cursor getFactorList(c_pid number) IS
852: SELECT DISTINCT TAE_COL_MAP, J2.INPUT_SELECTIVITY
853: FROM JTF_TAE_QUAL_PRODUCTS J3,
854: JTF_TAE_QUAL_FACTORS J2,
855: JTF_TAE_QUAL_PROD_FACTORS J1
856: WHERE J1.qual_product_id = c_pid
857: AND J1.qual_product_id = J3.qual_product_id
858: AND J1.qual_factor_id = J2.qual_factor_id
859: AND J2.USE_TAE_COL_IN_INDEX_FLAG = 'Y'

Line 877: from jtf_tae_qual_prod_factors pf,

873: AND P.SOURCE_ID = cl_source_id;
874:
875: Cursor getReverseFactorList(cl_pid number) IS
876: select f.tae_col_map, qual_usg_id, input_selectivity
877: from jtf_tae_qual_prod_factors pf,
878: jtf_tae_qual_factors f
879: where pf.qual_product_id = cl_pid
880: and f.qual_factor_id = pf.qual_factor_id
881: and f.tae_col_map is not null

Line 891: JTF_TAE_QUAL_prod_factors pf,

887: select count(*) NON_NULL_TAE_COL_MAPS,
888: p.qual_product_id QUAL_PRODUCT_ID,
889: p.relation_product RELATION_PRODUCT
890: from JTF_TAE_QUAL_products p,
891: JTF_TAE_QUAL_prod_factors pf,
892: JTF_TAE_QUAL_FACTORS f
893: where p.qual_product_id = pf.qual_product_id
894: and pf.qual_factor_id = f.qual_factor_id
895: and p.source_id = cl_source_id