APPS.JTY_TAE_INDEX_CREATION_PVT dependencies on JTY_DEA_ATTR_PRODUCTS

Line 868: ,jty_dea_attr_products P

864: COUNT(r.dea_attr_factors_id) cartesian_terr_X_factors
865: FROM jty_denorm_dea_rules_all d
866: ,jtf_terr_qtype_usgs_all jtqu
867: ,jtf_qual_type_usgs_all jqtu
868: ,jty_dea_attr_products P
869: ,jty_dea_attr_prod_factors R
870: WHERE jtqu.qual_relation_product = p.attr_relation_product
871: AND jqtu.source_id = d.source_id
872: AND jqtu.qual_type_id = p.trans_type_id

Line 885: FROM jty_dea_attr_products J3,

881: ORDER BY cartesian_terr_X_factors DESC, first_char_flag;
882:
883: Cursor dea_getFactorList(c_pid number) IS
884: SELECT DISTINCT TAE_COL_MAP, J2.INPUT_SELECTIVITY
885: FROM jty_dea_attr_products J3,
886: jty_dea_attr_factors J2,
887: jty_dea_attr_prod_factors J1
888: WHERE J1.dea_attr_products_id = c_pid
889: AND J1.dea_attr_products_id = J3.dea_attr_products_id

Line 901: FROM jty_dea_attr_products P

897: p.attr_relation_product attr_relation_product,
898: p.index_name index_name,
899: p.first_char_flag first_char_flag,
900: rownum index_counter
901: FROM jty_dea_attr_products P
902: WHERE P.BUILD_INDEX_FLAG = 'Y'
903: AND P.FIRST_CHAR_FLAG = 'Y'
904: AND p.trans_type_id = cl_trans_id
905: AND P.source_id = cl_source_id;

Line 922: from jty_dea_attr_products p,

918: from (
919: select count(*) NON_NULL_TAE_COL_MAPS,
920: p.dea_attr_products_id dea_attr_products_id,
921: p.attr_relation_product attr_relation_product
922: from jty_dea_attr_products p,
923: jty_dea_attr_prod_factors pf,
924: jty_dea_attr_factors f
925: where p.dea_attr_products_id = pf.dea_attr_products_id
926: and pf.dea_attr_factors_id = f.dea_attr_factors_id