eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JTF_TAE_INDEX_CREATION_PVT dependencies on JTF_TAE_QUAL_FACTORS

Line 317: * input JTF_TAE_QUAL_FACTORS.SQUAL_ALIAS

313: * Type : Private
314: * Pre_reqs :
315: * Description :
316: * Parameters :
317: * input JTF_TAE_QUAL_FACTORS.SQUAL_ALIAS
318: * outout JTF_TAE_QUAL_FACTORS.INPUT_SELECTIVITY is populated with selectivity order
319: JTF_TAE_QUAL_FACTORS.INPUT_ORDINAL_SELECTIVITY is populated with ordinal_selectivity
320: JTF_TAE_QUAL_FACTORS.INPUT_DEVIATION is populated with standard deviation
321: * return

Line 318: * outout JTF_TAE_QUAL_FACTORS.INPUT_SELECTIVITY is populated with selectivity order

314: * Pre_reqs :
315: * Description :
316: * Parameters :
317: * input JTF_TAE_QUAL_FACTORS.SQUAL_ALIAS
318: * outout JTF_TAE_QUAL_FACTORS.INPUT_SELECTIVITY is populated with selectivity order
319: JTF_TAE_QUAL_FACTORS.INPUT_ORDINAL_SELECTIVITY is populated with ordinal_selectivity
320: JTF_TAE_QUAL_FACTORS.INPUT_DEVIATION is populated with standard deviation
321: * return
322: * 0: no data in JTF_TAE_QUAL_FACTORS

Line 319: JTF_TAE_QUAL_FACTORS.INPUT_ORDINAL_SELECTIVITY is populated with ordinal_selectivity

315: * Description :
316: * Parameters :
317: * input JTF_TAE_QUAL_FACTORS.SQUAL_ALIAS
318: * outout JTF_TAE_QUAL_FACTORS.INPUT_SELECTIVITY is populated with selectivity order
319: JTF_TAE_QUAL_FACTORS.INPUT_ORDINAL_SELECTIVITY is populated with ordinal_selectivity
320: JTF_TAE_QUAL_FACTORS.INPUT_DEVIATION is populated with standard deviation
321: * return
322: * 0: no data in JTF_TAE_QUAL_FACTORS
323: * 1: success

Line 320: JTF_TAE_QUAL_FACTORS.INPUT_DEVIATION is populated with standard deviation

316: * Parameters :
317: * input JTF_TAE_QUAL_FACTORS.SQUAL_ALIAS
318: * outout JTF_TAE_QUAL_FACTORS.INPUT_SELECTIVITY is populated with selectivity order
319: JTF_TAE_QUAL_FACTORS.INPUT_ORDINAL_SELECTIVITY is populated with ordinal_selectivity
320: JTF_TAE_QUAL_FACTORS.INPUT_DEVIATION is populated with standard deviation
321: * return
322: * 0: no data in JTF_TAE_QUAL_FACTORS
323: * 1: success
324: */

Line 322: * 0: no data in JTF_TAE_QUAL_FACTORS

318: * outout JTF_TAE_QUAL_FACTORS.INPUT_SELECTIVITY is populated with selectivity order
319: JTF_TAE_QUAL_FACTORS.INPUT_ORDINAL_SELECTIVITY is populated with ordinal_selectivity
320: JTF_TAE_QUAL_FACTORS.INPUT_DEVIATION is populated with standard deviation
321: * return
322: * 0: no data in JTF_TAE_QUAL_FACTORS
323: * 1: success
324: */
325:
326: FUNCTION SELECTIVITY(p_TABLE_NAME IN VARCHAR2) return number IS

Line 345: FROM JTF_TAE_QUAL_FACTORS A

341: A.INPUT_DEVIATION dev,
342: A.INPUT_ORDINAL_SELECTIVITY ord_sele,
343: A.INPUT_SELECTIVITY sele,
344: decode(A.UPDATE_SELECTIVITY_FLAG,'Y',1,0) flag
345: FROM JTF_TAE_QUAL_FACTORS A
346: WHERE A.USE_TAE_COL_IN_INDEX_FLAG = 'Y'
347: AND A.TAE_COL_MAP is not null ;
348:
349:

Line 375: -- update JTF_TAE_QUAL_FACTORS

371: if CAL_SELECTIVITY(p_table_name, col_name, o_sel, std_dev, flag, i-1) = 0
372: then return 0;
373: end if;
374:
375: -- update JTF_TAE_QUAL_FACTORS
376: for i IN 1..col_name.count loop
377: UPDATE JTF_TAE_QUAL_FACTORS
378: SET INPUT_SELECTIVITY = i,
379: INPUT_ORDINAL_SELECTIVITY = o_sel(i),

Line 377: UPDATE JTF_TAE_QUAL_FACTORS

373: end if;
374:
375: -- update JTF_TAE_QUAL_FACTORS
376: for i IN 1..col_name.count loop
377: UPDATE JTF_TAE_QUAL_FACTORS
378: SET INPUT_SELECTIVITY = i,
379: INPUT_ORDINAL_SELECTIVITY = o_sel(i),
380: INPUT_DEVIATION = std_dev(i)
381: WHERE TAE_COL_MAP = col_name(i);

Line 570: * : table JTF_TAE_QUAL_FACTORS

566: * Type : private
567: * Pre_reqs :
568: * Description : index creation
569: * input : table JTF_TAE_QUAL_PRODUCTS
570: * : table JTF_TAE_QUAL_FACTORS
571: * output : indices created on JTF_TAE_OBJECT_INPUT
572: * return 0: failure
573: * 1: success
574: */

Line 654: JTF_TAE_QUAL_FACTORS J2,

650:
651: Cursor getFactorList IS
652: SELECT distinct TAE_COL_MAP, J2.INPUT_SELECTIVITY
653: FROM JTF_TAE_QUAL_PRODUCTS J3,
654: JTF_TAE_QUAL_FACTORS J2,
655: JTF_TAE_QUAL_PROD_FACTORS J1
656: WHERE J1.qual_product_id = pid
657: and J1.qual_product_id = J3.qual_product_id
658: and J1.qual_factor_id = J2.qual_factor_id

Line 682: jtf_tae_qual_factors f

678:
679: Cursor getReverseFactorList IS
680: select f.tae_col_map, qual_usg_id, input_selectivity
681: from jtf_tae_qual_prod_factors pf,
682: jtf_tae_qual_factors f
683: where qual_product_id = pid
684: and f.qual_factor_id = pf.qual_factor_id
685: and f.tae_col_map is not null
686: order by input_selectivity desc;

Line 698: JTF_TAE_QUAL_FACTORS f

694: p.qual_product_id QUAL_PRODUCT_ID,
695: p.relation_product RELATION_PRODUCT
696: from JTF_TAE_QUAL_products p,
697: JTF_TAE_QUAL_prod_factors pf,
698: JTF_TAE_QUAL_FACTORS f
699: where p.qual_product_id = pf.qual_product_id
700: and pf.qual_factor_id = f.qual_factor_id
701: and p.source_id = p_source_id
702: and p.trans_object_type_id = p_trans_object_type_id