APPS.JTY_TAE_INDEX_CREATION_PVT dependencies on JTY_DEA_ATTR_PROD_FACTORS

Line 914: ,jty_dea_attr_prod_factors R

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

Line 932: jty_dea_attr_prod_factors J1

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

Line 954: from jty_dea_attr_prod_factors pf,

950: AND P.source_id = cl_source_id;
951:
952: Cursor dea_getReverseFactorList(cl_pid number) IS
953: select f.tae_col_map, qual_usg_id, input_selectivity
954: from jty_dea_attr_prod_factors pf,
955: jty_dea_attr_factors f
956: where pf.dea_attr_products_id = cl_pid
957: and f.dea_attr_factors_id = pf.dea_attr_factors_id
958: and f.tae_col_map is not null

Line 968: jty_dea_attr_prod_factors pf,

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