APPS.JTF_TAE_INDEX_CREATION_PVT dependencies on JTF_TAE_QUAL_PROD_FACTORS

Line 632: , JTF_TAE_QUAL_PROD_FACTORS R

628: FROM jtf_terr_denorm_rules_all d
629: ,jtf_terr_qtype_usgs_all jtqu
630: ,jtf_qual_type_usgs_all jqtu
631: ,JTF_TAE_QUAL_PRODUCTS P
632: , JTF_TAE_QUAL_PROD_FACTORS R
633: WHERE /* ARPATEL 01/06/2004 bug#3337382: use qual_relation_factor in jtf_terr_qtype_usgs_all */
634: --d.qual_relation_product = p.relation_product
635: jtqu.qual_relation_product = p.relation_product
636: AND jqtu.source_id = d.source_id

Line 656: JTF_TAE_QUAL_PROD_FACTORS J1

652: Cursor getFactorList IS
653: SELECT distinct TAE_COL_MAP, J2.INPUT_SELECTIVITY
654: FROM JTF_TAE_QUAL_PRODUCTS J3,
655: JTF_TAE_QUAL_FACTORS J2,
656: JTF_TAE_QUAL_PROD_FACTORS J1
657: WHERE J1.qual_product_id = pid
658: and J1.qual_product_id = J3.qual_product_id
659: and J1.qual_factor_id = J2.qual_factor_id
660: -- and J1.qual_usg_id = J2.qual_usg_id

Line 682: from jtf_tae_qual_prod_factors pf,

678: AND P.SOURCE_ID = p_source_id;
679:
680: Cursor getReverseFactorList IS
681: select f.tae_col_map, qual_usg_id, input_selectivity
682: from jtf_tae_qual_prod_factors pf,
683: jtf_tae_qual_factors f
684: where qual_product_id = pid
685: and f.qual_factor_id = pf.qual_factor_id
686: and f.tae_col_map is not null

Line 698: JTF_TAE_QUAL_prod_factors pf,

694: select count(*) NON_NULL_TAE_COL_MAPS,
695: p.qual_product_id QUAL_PRODUCT_ID,
696: p.relation_product RELATION_PRODUCT
697: from JTF_TAE_QUAL_products p,
698: JTF_TAE_QUAL_prod_factors pf,
699: JTF_TAE_QUAL_FACTORS f
700: where p.qual_product_id = pf.qual_product_id
701: and pf.qual_factor_id = f.qual_factor_id
702: and p.source_id = p_source_id