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 318: * input JTF_TAE_QUAL_FACTORS.SQUAL_ALIAS

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

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

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

Line 320: JTF_TAE_QUAL_FACTORS.INPUT_ORDINAL_SELECTIVITY is populated with ordinal_selectivity

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

Line 321: JTF_TAE_QUAL_FACTORS.INPUT_DEVIATION is populated with standard deviation

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

Line 323: * 0: no data in JTF_TAE_QUAL_FACTORS

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

Line 346: FROM JTF_TAE_QUAL_FACTORS A

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

Line 376: -- update JTF_TAE_QUAL_FACTORS

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

Line 378: UPDATE JTF_TAE_QUAL_FACTORS

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

Line 571: * : table JTF_TAE_QUAL_FACTORS

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

Line 655: JTF_TAE_QUAL_FACTORS J2,

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

Line 683: jtf_tae_qual_factors f

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

Line 699: JTF_TAE_QUAL_FACTORS f

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