APPS.JTY_TAE_INDEX_CREATION_PVT dependencies on JTF_TAE_QUAL_PRODUCTS

Line 735: * input : table JTF_TAE_QUAL_PRODUCTS

731: * Procedure : CREATE_INDEX
732: * Type : private
733: * Pre_reqs :
734: * Description : index creation
735: * input : table JTF_TAE_QUAL_PRODUCTS
736: * : table JTF_TAE_QUAL_FACTORS
737: * output : indices created on JTF_TAE_OBJECT_INPUT
738: * return 0: failure
739: * 1: success

Line 791: ,JTF_TAE_QUAL_PRODUCTS P

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

Line 808: FROM JTF_TAE_QUAL_PRODUCTS J3,

804: ORDER BY cartesian_terr_X_factors DESC, first_char_flag;
805:
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

Line 824: FROM JTF_TAE_QUAL_PRODUCTS P

820: p.RELATION_PRODUCT RELATION_PRODUCT,
821: p.index_name index_name,
822: p.first_char_flag first_char_flag,
823: rownum index_counter
824: FROM JTF_TAE_QUAL_PRODUCTS P
825: WHERE P.BUILD_INDEX_FLAG = 'Y'
826: AND P.FIRST_CHAR_FLAG = 'Y'
827: AND p.TRANS_OBJECT_TYPE_ID = cl_trans_id
828: AND P.SOURCE_ID = cl_source_id;

Line 845: from JTF_TAE_QUAL_products p,

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