APPS.JTF_TAE_INDEX_CREATION_PVT dependencies on JTF_TAE_QUAL_PRODUCTS

Line 569: * input : table JTF_TAE_QUAL_PRODUCTS

565: * Procedure : CREATE_INDEX
566: * Type : private
567: * Pre_reqs :
568: * Description : index creation
569: * input : table JTF_TAE_QUAL_PRODUCTS
570: * : table JTF_TAE_QUAL_FACTORS
571: * output : indices created on JTF_TAE_OBJECT_INPUT
572: * return 0: failure
573: * 1: success

Line 630: ,JTF_TAE_QUAL_PRODUCTS P

626: COUNT(r.qual_factor_id) cartesian_terr_X_factors
627: FROM jtf_terr_denorm_rules_all d
628: ,jtf_terr_qtype_usgs_all jtqu
629: ,jtf_qual_type_usgs_all jqtu
630: ,JTF_TAE_QUAL_PRODUCTS P
631: , JTF_TAE_QUAL_PROD_FACTORS R
632: WHERE /* ARPATEL 01/06/2004 bug#3337382: use qual_relation_factor in jtf_terr_qtype_usgs_all */
633: --d.qual_relation_product = p.relation_product
634: jtqu.qual_relation_product = p.relation_product

Line 653: FROM JTF_TAE_QUAL_PRODUCTS J3,

649:
650:
651: Cursor getFactorList IS
652: SELECT distinct TAE_COL_MAP, J2.INPUT_SELECTIVITY
653: FROM JTF_TAE_QUAL_PRODUCTS J3,
654: JTF_TAE_QUAL_FACTORS J2,
655: JTF_TAE_QUAL_PROD_FACTORS J1
656: WHERE J1.qual_product_id = pid
657: and J1.qual_product_id = J3.qual_product_id

Line 673: FROM JTF_TAE_QUAL_PRODUCTS P

669:
670: p.index_name index_name,
671: p.first_char_flag first_char_flag,
672: rownum index_counter
673: FROM JTF_TAE_QUAL_PRODUCTS P
674: WHERE P.BUILD_INDEX_FLAG = 'Y'
675: AND P.FIRST_CHAR_FLAG = 'Y'
676: AND p.TRANS_OBJECT_TYPE_ID = p_trans_object_type_id
677: AND P.SOURCE_ID = p_source_id;

Line 696: from JTF_TAE_QUAL_products p,

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