APPS.JTY_TAE_INDEX_CREATION_PVT dependencies on JTY_DEA_ATTR_PROD_FACTORS

Line 869: ,jty_dea_attr_prod_factors R

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
873: AND d.terr_id = jtqu.terr_id

Line 887: jty_dea_attr_prod_factors J1

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
890: AND J1.dea_attr_factors_id = J2.dea_attr_factors_id
891: AND J2.USE_TAE_COL_IN_INDEX_FLAG = 'Y'

Line 909: from jty_dea_attr_prod_factors pf,

905: AND P.source_id = cl_source_id;
906:
907: Cursor dea_getReverseFactorList(cl_pid number) IS
908: select f.tae_col_map, qual_usg_id, input_selectivity
909: from jty_dea_attr_prod_factors pf,
910: jty_dea_attr_factors f
911: where pf.dea_attr_products_id = cl_pid
912: and f.dea_attr_factors_id = pf.dea_attr_factors_id
913: and f.tae_col_map is not null

Line 923: jty_dea_attr_prod_factors pf,

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
927: and p.source_id = cl_source_id