APPS.JTY_TAE_INDEX_CREATION_PVT dependencies on JTF_TAE_QUAL_FACTORS

Line 405: * input JTF_TAE_QUAL_FACTORS.SQUAL_ALIAS

401: * Type : Private
402: * Pre_reqs :
403: * Description :
404: * Parameters :
405: * input JTF_TAE_QUAL_FACTORS.SQUAL_ALIAS
406: * outout JTF_TAE_QUAL_FACTORS.INPUT_SELECTIVITY is populated with selectivity order
407: JTF_TAE_QUAL_FACTORS.INPUT_ORDINAL_SELECTIVITY is populated with ordinal_selectivity
408: JTF_TAE_QUAL_FACTORS.INPUT_DEVIATION is populated with standard deviation
409: */

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

402: * Pre_reqs :
403: * Description :
404: * Parameters :
405: * input JTF_TAE_QUAL_FACTORS.SQUAL_ALIAS
406: * outout JTF_TAE_QUAL_FACTORS.INPUT_SELECTIVITY is populated with selectivity order
407: JTF_TAE_QUAL_FACTORS.INPUT_ORDINAL_SELECTIVITY is populated with ordinal_selectivity
408: JTF_TAE_QUAL_FACTORS.INPUT_DEVIATION is populated with standard deviation
409: */
410:

Line 407: JTF_TAE_QUAL_FACTORS.INPUT_ORDINAL_SELECTIVITY is populated with ordinal_selectivity

403: * Description :
404: * Parameters :
405: * input JTF_TAE_QUAL_FACTORS.SQUAL_ALIAS
406: * outout JTF_TAE_QUAL_FACTORS.INPUT_SELECTIVITY is populated with selectivity order
407: JTF_TAE_QUAL_FACTORS.INPUT_ORDINAL_SELECTIVITY is populated with ordinal_selectivity
408: JTF_TAE_QUAL_FACTORS.INPUT_DEVIATION is populated with standard deviation
409: */
410:
411: PROCEDURE SELECTIVITY(p_TABLE_NAME IN VARCHAR2,

Line 408: JTF_TAE_QUAL_FACTORS.INPUT_DEVIATION is populated with standard deviation

404: * Parameters :
405: * input JTF_TAE_QUAL_FACTORS.SQUAL_ALIAS
406: * outout JTF_TAE_QUAL_FACTORS.INPUT_SELECTIVITY is populated with selectivity order
407: JTF_TAE_QUAL_FACTORS.INPUT_ORDINAL_SELECTIVITY is populated with ordinal_selectivity
408: JTF_TAE_QUAL_FACTORS.INPUT_DEVIATION is populated with standard deviation
409: */
410:
411: PROCEDURE SELECTIVITY(p_TABLE_NAME IN VARCHAR2,
412: p_mode IN VARCHAR2,

Line 468: FROM JTF_TAE_QUAL_FACTORS A

464: A.INPUT_DEVIATION dev,
465: A.INPUT_ORDINAL_SELECTIVITY ord_sele,
466: A.INPUT_SELECTIVITY sele,
467: decode(A.UPDATE_SELECTIVITY_FLAG,'Y',1,0) flag
468: FROM JTF_TAE_QUAL_FACTORS A
469: WHERE A.USE_TAE_COL_IN_INDEX_FLAG = 'Y'
470: AND A.TAE_COL_MAP is not null ;
471:
472: CURSOR getColumnName_dnmval(cl_source_id in number) IS

Line 570: -- update JTF_TAE_QUAL_FACTORS

566: RAISE FND_API.G_EXC_ERROR;
567: END IF;
568:
569: IF (p_source_id IS NULL) THEN
570: -- update JTF_TAE_QUAL_FACTORS
571: FOR i IN 1..col_name.count LOOP
572: UPDATE JTF_TAE_QUAL_FACTORS
573: SET INPUT_SELECTIVITY = i,
574: INPUT_ORDINAL_SELECTIVITY = o_sel(i),

Line 572: UPDATE JTF_TAE_QUAL_FACTORS

568:
569: IF (p_source_id IS NULL) THEN
570: -- update JTF_TAE_QUAL_FACTORS
571: FOR i IN 1..col_name.count LOOP
572: UPDATE JTF_TAE_QUAL_FACTORS
573: SET INPUT_SELECTIVITY = i,
574: INPUT_ORDINAL_SELECTIVITY = o_sel(i),
575: INPUT_DEVIATION = std_dev(i)
576: WHERE TAE_COL_MAP = col_name(i);

Line 736: * : table JTF_TAE_QUAL_FACTORS

732: * Type : private
733: * Pre_reqs :
734: * Description : index creation
735: * input : table JTF_TAE_QUAL_PRODUCTS
736: * : table JTF_TAE_QUAL_FACTORS
737: * output : indices created on JTF_TAE_OBJECT_INPUT
738: * return 0: failure
739: * 1: success
740: */

Line 809: JTF_TAE_QUAL_FACTORS J2,

805:
806: Cursor getFactorList(c_pid number) IS
807: SELECT DISTINCT TAE_COL_MAP, J2.INPUT_SELECTIVITY
808: FROM JTF_TAE_QUAL_PRODUCTS J3,
809: JTF_TAE_QUAL_FACTORS J2,
810: JTF_TAE_QUAL_PROD_FACTORS J1
811: WHERE J1.qual_product_id = c_pid
812: AND J1.qual_product_id = J3.qual_product_id
813: AND J1.qual_factor_id = J2.qual_factor_id

Line 833: jtf_tae_qual_factors f

829:
830: Cursor getReverseFactorList(cl_pid number) IS
831: select f.tae_col_map, qual_usg_id, input_selectivity
832: from jtf_tae_qual_prod_factors pf,
833: jtf_tae_qual_factors f
834: where pf.qual_product_id = cl_pid
835: and f.qual_factor_id = pf.qual_factor_id
836: and f.tae_col_map is not null
837: order by input_selectivity desc;

Line 847: JTF_TAE_QUAL_FACTORS f

843: p.qual_product_id QUAL_PRODUCT_ID,
844: p.relation_product RELATION_PRODUCT
845: from JTF_TAE_QUAL_products p,
846: JTF_TAE_QUAL_prod_factors pf,
847: JTF_TAE_QUAL_FACTORS f
848: where p.qual_product_id = pf.qual_product_id
849: and pf.qual_factor_id = f.qual_factor_id
850: and p.source_id = cl_source_id
851: and p.trans_object_type_id = cl_trans_id