APPS.JTY_TAE_CONTROL_PVT dependencies on JTF_TAE_QUAL_FACTORS

Line 75: DELETE FROM jtf_tae_qual_factors o

71: DELETE FROM jtf_tae_qual_products
72: WHERE source_id = p_source_id
73: AND trans_object_type_id = p_trans_id;
74:
75: DELETE FROM jtf_tae_qual_factors o
76: WHERE NOT EXISTS
77: ( SELECT NULL
78: FROM jtf_tae_qual_products i
79: WHERE MOD(i.relation_product, o.relation_factor) = 0 );

Line 143: DELETE FROM jtf_tae_qual_factors o

139: DELETE FROM jtf_tae_qual_prod_factors
140: WHERE qual_product_id = l_qual_prd_id_tbl(i);
141: END IF;
142:
143: DELETE FROM jtf_tae_qual_factors o
144: WHERE NOT EXISTS
145: ( SELECT NULL
146: FROM jtf_tae_qual_products i
147: WHERE MOD(i.relation_product, o.relation_factor) = 0 );

Line 417: FROM JTF_TAE_QUAL_factors

413: FOR q_detail in qual_details(qual_name.qual_usg_id) LOOP
414:
415: SELECT count(*)
416: INTO l_exist_qual_detail_count
417: FROM JTF_TAE_QUAL_factors
418: WHERE qual_usg_id = q_detail.qual_usg_id;
419:
420: IF l_exist_qual_detail_count = 0 THEN
421:

Line 424: SELECT JTF_TAE_QUAL_factors_s.NEXTVAL

420: IF l_exist_qual_detail_count = 0 THEN
421:
422: BEGIN
423:
424: SELECT JTF_TAE_QUAL_factors_s.NEXTVAL
425: INTO l_qual_factor_id
426: FROM dual;
427:
428: INSERT INTO JTF_TAE_QUAL_factors

Line 428: INSERT INTO JTF_TAE_QUAL_factors

424: SELECT JTF_TAE_QUAL_factors_s.NEXTVAL
425: INTO l_qual_factor_id
426: FROM dual;
427:
428: INSERT INTO JTF_TAE_QUAL_factors
429: ( QUAL_FACTOR_ID,
430: RELATION_FACTOR,
431: QUAL_USG_ID,
432: LAST_UPDATED_BY,

Line 865: FROM JTF_TAE_QUAL_factors

861: BEGIN
862:
863: SELECT qual_factor_id
864: INTO l_qual_factor_id
865: FROM JTF_TAE_QUAL_factors
866: WHERE qual_usg_id = qual_name.qual_usg_id
867: AND rownum < 2;
868:
869: SELECT JTF_TAE_QUAL_PROD_FACTORS_S.NEXTVAL

Line 916: update JTF_TAE_QUAL_factors

912: END LOOP; /* end loop FOR i IN p_qual_prd_tbl.FIRST .. p_qual_prd_tbl.LAST */
913: END IF; /* end IF (p_qual_prd_tbl.COUNT > 0) */
914:
915: /* no need to build the index for the qualifiers with no column mapped to TRANS table */
916: update JTF_TAE_QUAL_factors
917: set UPDATE_SELECTIVITY_FLAG = 'N',
918: USE_TAE_COL_IN_INDEX_FLAG = 'N'
919: where TAE_COL_MAP is null;
920:

Line 1930: JTF_TAE_QUAL_factors f

1926: CURSOR all_sets(cl_source_id number, cl_trans_id number) is
1927: SELECT p.trans_object_type_id, count(*) num_components, p.qual_product_id qual_product_id, p.relation_product
1928: FROM JTF_TAE_QUAL_products p,
1929: JTF_TAE_QUAL_prod_factors pf,
1930: JTF_TAE_QUAL_factors f
1931: WHERE p.qual_product_id = pf.qual_product_id
1932: AND pf.qual_factor_id = f.qual_factor_id
1933: AND f.tae_col_map is not null
1934: AND p.source_id = cl_source_id

Line 1961: JTF_TAE_QUAL_factors ifc

1957: FROM JTF_TAE_QUAL_products p
1958: WHERE NOT EXISTS (SELECT *
1959: FROM JTF_TAE_QUAL_products ip,
1960: JTF_TAE_QUAL_prod_factors ipf,
1961: JTF_TAE_QUAL_factors ifc
1962: WHERE use_tae_col_in_index_flag = 'Y'
1963: AND ip.qual_product_id = ipf.qual_product_id
1964: AND ipf.qual_factor_id = ifc.qual_factor_id
1965: AND ip.qual_product_id = p.qual_product_id)

Line 1998: JTF_TAE_QUAL_factors f

1994: FROM (
1995: SELECT DISTINCT p.relation_product, f.tae_col_map, f.input_selectivity
1996: FROM JTF_TAE_QUAL_products p,
1997: JTF_TAE_QUAL_prod_factors pf,
1998: JTF_TAE_QUAL_factors f
1999: WHERE f.qual_factor_id = pf.qual_factor_id
2000: AND pf.qual_product_id = p.qual_product_id
2001: AND p.relation_product = cl_set_S.relation_product
2002: AND f.tae_col_map is not null

Line 2012: JTF_TAE_QUAL_factors f

2008: FROM (
2009: SELECT DISTINCT p.relation_product, f.tae_col_map, f.input_selectivity
2010: FROM JTF_TAE_QUAL_products p,
2011: JTF_TAE_QUAL_prod_factors pf,
2012: JTF_TAE_QUAL_factors f
2013: WHERE f.qual_factor_id = pf.qual_factor_id
2014: AND pf.qual_product_id = p.qual_product_id
2015: AND p.relation_product = cl_set_L.relation_product
2016: AND f.tae_col_map is not null

Line 2040: JTF_TAE_QUAL_factors f

2036: SELECT qual_usg_id, tae_col_map, rownum row_count
2037: FROM (
2038: SELECT f.qual_usg_id, f.relation_factor, f.tae_col_map
2039: FROM JTF_TAE_QUAL_prod_factors pf,
2040: JTF_TAE_QUAL_factors f
2041: WHERE pf.qual_factor_id = f.qual_factor_id
2042: AND pf.qual_product_id = cl_set_S.qual_product_id
2043: ORDER BY f.input_selectivity)) ilv1,
2044: (