APPS.JTY_TAE_INDEX_CREATION_PVT dependencies on JTY_DEA_ATTR_PRODUCTS

Line 913: ,jty_dea_attr_products P

909: COUNT(r.dea_attr_factors_id) cartesian_terr_X_factors
910: FROM jty_denorm_dea_rules_all d
911: ,jtf_terr_qtype_usgs_all jtqu
912: ,jtf_qual_type_usgs_all jqtu
913: ,jty_dea_attr_products P
914: ,jty_dea_attr_prod_factors R
915: WHERE jtqu.qual_relation_product = p.attr_relation_product
916: AND jqtu.source_id = d.source_id
917: AND jqtu.qual_type_id = p.trans_type_id

Line 930: FROM jty_dea_attr_products J3,

926: ORDER BY cartesian_terr_X_factors DESC, first_char_flag;
927:
928: Cursor dea_getFactorList(c_pid number) IS
929: SELECT DISTINCT TAE_COL_MAP, J2.INPUT_SELECTIVITY
930: FROM jty_dea_attr_products J3,
931: jty_dea_attr_factors J2,
932: jty_dea_attr_prod_factors J1
933: WHERE J1.dea_attr_products_id = c_pid
934: AND J1.dea_attr_products_id = J3.dea_attr_products_id

Line 946: FROM jty_dea_attr_products P

942: p.attr_relation_product attr_relation_product,
943: p.index_name index_name,
944: p.first_char_flag first_char_flag,
945: rownum index_counter
946: FROM jty_dea_attr_products P
947: WHERE P.BUILD_INDEX_FLAG = 'Y'
948: AND P.FIRST_CHAR_FLAG = 'Y'
949: AND p.trans_type_id = cl_trans_id
950: AND P.source_id = cl_source_id;

Line 967: from jty_dea_attr_products p,

963: from (
964: select count(*) NON_NULL_TAE_COL_MAPS,
965: p.dea_attr_products_id dea_attr_products_id,
966: p.attr_relation_product attr_relation_product
967: from jty_dea_attr_products p,
968: jty_dea_attr_prod_factors pf,
969: jty_dea_attr_factors f
970: where p.dea_attr_products_id = pf.dea_attr_products_id
971: and pf.dea_attr_factors_id = f.dea_attr_factors_id