APPS.JTY_TAE_INDEX_CREATION_PVT dependencies on JTF_TAE_QUAL_PRODUCTS

Line 780: * input : table JTF_TAE_QUAL_PRODUCTS

776: * Procedure : CREATE_INDEX
777: * Type : private
778: * Pre_reqs :
779: * Description : index creation
780: * input : table JTF_TAE_QUAL_PRODUCTS
781: * : table JTF_TAE_QUAL_FACTORS
782: * output : indices created on JTF_TAE_OBJECT_INPUT
783: * return 0: failure
784: * 1: success

Line 836: ,JTF_TAE_QUAL_PRODUCTS P

832: COUNT(r.qual_factor_id) cartesian_terr_X_factors
833: FROM jtf_terr_denorm_rules_all d
834: ,jtf_terr_qtype_usgs_all jtqu
835: ,jtf_qual_type_usgs_all jqtu
836: ,JTF_TAE_QUAL_PRODUCTS P
837: , JTF_TAE_QUAL_PROD_FACTORS R
838: WHERE jtqu.qual_relation_product = p.relation_product
839: AND jqtu.source_id = d.source_id
840: AND jqtu.qual_type_id = p.trans_object_type_id

Line 853: FROM JTF_TAE_QUAL_PRODUCTS J3,

849: ORDER BY cartesian_terr_X_factors DESC, first_char_flag;
850:
851: Cursor getFactorList(c_pid number) IS
852: SELECT DISTINCT TAE_COL_MAP, J2.INPUT_SELECTIVITY
853: FROM JTF_TAE_QUAL_PRODUCTS J3,
854: JTF_TAE_QUAL_FACTORS J2,
855: JTF_TAE_QUAL_PROD_FACTORS J1
856: WHERE J1.qual_product_id = c_pid
857: AND J1.qual_product_id = J3.qual_product_id

Line 869: FROM JTF_TAE_QUAL_PRODUCTS P

865: p.RELATION_PRODUCT RELATION_PRODUCT,
866: p.index_name index_name,
867: p.first_char_flag first_char_flag,
868: rownum index_counter
869: FROM JTF_TAE_QUAL_PRODUCTS P
870: WHERE P.BUILD_INDEX_FLAG = 'Y'
871: AND P.FIRST_CHAR_FLAG = 'Y'
872: AND p.TRANS_OBJECT_TYPE_ID = cl_trans_id
873: AND P.SOURCE_ID = cl_source_id;

Line 890: from JTF_TAE_QUAL_products p,

886: from (
887: select count(*) NON_NULL_TAE_COL_MAPS,
888: p.qual_product_id QUAL_PRODUCT_ID,
889: p.relation_product RELATION_PRODUCT
890: from JTF_TAE_QUAL_products p,
891: JTF_TAE_QUAL_prod_factors pf,
892: JTF_TAE_QUAL_FACTORS f
893: where p.qual_product_id = pf.qual_product_id
894: and pf.qual_factor_id = f.qual_factor_id