APPS.JTF_TAE_INDEX_CREATION_PVT dependencies on JTF_TAE_QUAL_PRODUCTS

Line 570: * input : table JTF_TAE_QUAL_PRODUCTS

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

Line 631: ,JTF_TAE_QUAL_PRODUCTS P

627: COUNT(r.qual_factor_id) cartesian_terr_X_factors
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

Line 654: FROM JTF_TAE_QUAL_PRODUCTS J3,

650:
651:
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

Line 674: FROM JTF_TAE_QUAL_PRODUCTS P

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

Line 697: from JTF_TAE_QUAL_products p,

693: from (
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