APPS.JTY_TAE_INDEX_CREATION_PVT dependencies on JTF_TAE_QUAL_PROD_FACTORS

Line 792: , JTF_TAE_QUAL_PROD_FACTORS R

788: FROM jtf_terr_denorm_rules_all d
789: ,jtf_terr_qtype_usgs_all jtqu
790: ,jtf_qual_type_usgs_all jqtu
791: ,JTF_TAE_QUAL_PRODUCTS P
792: , JTF_TAE_QUAL_PROD_FACTORS R
793: WHERE jtqu.qual_relation_product = p.relation_product
794: AND jqtu.source_id = d.source_id
795: AND jqtu.qual_type_id = p.trans_object_type_id
796: AND d.terr_id = jtqu.terr_id

Line 810: JTF_TAE_QUAL_PROD_FACTORS J1

806: Cursor getFactorList(c_pid number) IS
807: SELECT DISTINCT TAE_COL_MAP, J2.INPUT_SELECTIVITY
808: FROM JTF_TAE_QUAL_PRODUCTS J3,
809: JTF_TAE_QUAL_FACTORS J2,
810: JTF_TAE_QUAL_PROD_FACTORS J1
811: WHERE J1.qual_product_id = c_pid
812: AND J1.qual_product_id = J3.qual_product_id
813: AND J1.qual_factor_id = J2.qual_factor_id
814: AND J2.USE_TAE_COL_IN_INDEX_FLAG = 'Y'

Line 832: from jtf_tae_qual_prod_factors pf,

828: AND P.SOURCE_ID = cl_source_id;
829:
830: Cursor getReverseFactorList(cl_pid number) IS
831: select f.tae_col_map, qual_usg_id, input_selectivity
832: from jtf_tae_qual_prod_factors pf,
833: jtf_tae_qual_factors f
834: where pf.qual_product_id = cl_pid
835: and f.qual_factor_id = pf.qual_factor_id
836: and f.tae_col_map is not null

Line 846: JTF_TAE_QUAL_prod_factors pf,

842: select count(*) NON_NULL_TAE_COL_MAPS,
843: p.qual_product_id QUAL_PRODUCT_ID,
844: p.relation_product RELATION_PRODUCT
845: from JTF_TAE_QUAL_products p,
846: JTF_TAE_QUAL_prod_factors pf,
847: JTF_TAE_QUAL_FACTORS f
848: where p.qual_product_id = pf.qual_product_id
849: and pf.qual_factor_id = f.qual_factor_id
850: and p.source_id = cl_source_id