APPS.JTY_TAE_INDEX_CREATION_PVT dependencies on JTY_DEA_ATTR_FACTORS

Line 251: * input JTY_DEA_ATTR_FACTORS.SQUAL_ALIAS

247: * Type : Private
248: * Pre_reqs :
249: * Description :
250: * Parameters :
251: * input JTY_DEA_ATTR_FACTORS.SQUAL_ALIAS
252: * outout JTY_DEA_ATTR_FACTORS.INPUT_SELECTIVITY is populated with selectivity order
253: JTY_DEA_ATTR_FACTORS.INPUT_ORDINAL_SELECTIVITY is populated with ordinal_selectivity
254: JTY_DEA_ATTR_FACTORS.INPUT_DEVIATION is populated with standard deviation
255: */

Line 252: * outout JTY_DEA_ATTR_FACTORS.INPUT_SELECTIVITY is populated with selectivity order

248: * Pre_reqs :
249: * Description :
250: * Parameters :
251: * input JTY_DEA_ATTR_FACTORS.SQUAL_ALIAS
252: * outout JTY_DEA_ATTR_FACTORS.INPUT_SELECTIVITY is populated with selectivity order
253: JTY_DEA_ATTR_FACTORS.INPUT_ORDINAL_SELECTIVITY is populated with ordinal_selectivity
254: JTY_DEA_ATTR_FACTORS.INPUT_DEVIATION is populated with standard deviation
255: */
256:

Line 253: JTY_DEA_ATTR_FACTORS.INPUT_ORDINAL_SELECTIVITY is populated with ordinal_selectivity

249: * Description :
250: * Parameters :
251: * input JTY_DEA_ATTR_FACTORS.SQUAL_ALIAS
252: * outout JTY_DEA_ATTR_FACTORS.INPUT_SELECTIVITY is populated with selectivity order
253: JTY_DEA_ATTR_FACTORS.INPUT_ORDINAL_SELECTIVITY is populated with ordinal_selectivity
254: JTY_DEA_ATTR_FACTORS.INPUT_DEVIATION is populated with standard deviation
255: */
256:
257: PROCEDURE DEA_SELECTIVITY(p_TABLE_NAME IN VARCHAR2,

Line 254: JTY_DEA_ATTR_FACTORS.INPUT_DEVIATION is populated with standard deviation

250: * Parameters :
251: * input JTY_DEA_ATTR_FACTORS.SQUAL_ALIAS
252: * outout JTY_DEA_ATTR_FACTORS.INPUT_SELECTIVITY is populated with selectivity order
253: JTY_DEA_ATTR_FACTORS.INPUT_ORDINAL_SELECTIVITY is populated with ordinal_selectivity
254: JTY_DEA_ATTR_FACTORS.INPUT_DEVIATION is populated with standard deviation
255: */
256:
257: PROCEDURE DEA_SELECTIVITY(p_TABLE_NAME IN VARCHAR2,
258: x_return_status OUT NOCOPY VARCHAR2)

Line 313: FROM JTY_DEA_ATTR_FACTORS A

309: A.INPUT_DEVIATION dev,
310: A.INPUT_ORDINAL_SELECTIVITY ord_sele,
311: A.INPUT_SELECTIVITY sele,
312: decode(A.UPDATE_SELECTIVITY_FLAG,'Y',1,0) flag
313: FROM JTY_DEA_ATTR_FACTORS A
314: WHERE A.USE_TAE_COL_IN_INDEX_FLAG = 'Y'
315: AND A.TAE_COL_MAP is not null ;
316:
317:

Line 367: -- update JTY_DEA_ATTR_FACTORS

363:
364: RAISE FND_API.G_EXC_ERROR;
365: END IF;
366:
367: -- update JTY_DEA_ATTR_FACTORS
368: FOR i IN 1..col_name.count LOOP
369: UPDATE JTY_DEA_ATTR_FACTORS
370: SET INPUT_SELECTIVITY = i,
371: INPUT_ORDINAL_SELECTIVITY = o_sel(i),

Line 369: UPDATE JTY_DEA_ATTR_FACTORS

365: END IF;
366:
367: -- update JTY_DEA_ATTR_FACTORS
368: FOR i IN 1..col_name.count LOOP
369: UPDATE JTY_DEA_ATTR_FACTORS
370: SET INPUT_SELECTIVITY = i,
371: INPUT_ORDINAL_SELECTIVITY = o_sel(i),
372: INPUT_DEVIATION = std_dev(i)
373: WHERE TAE_COL_MAP = col_name(i);

Line 886: jty_dea_attr_factors J2,

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

Line 910: jty_dea_attr_factors f

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
914: order by input_selectivity desc;

Line 924: jty_dea_attr_factors f

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
928: and p.trans_type_id = cl_trans_id