APPS.JTY_TAE_CONTROL_PVT dependencies on JTF_TAE_QUAL_FACTORS

Line 65: DELETE FROM jtf_tae_qual_factors o

61: DELETE FROM jtf_tae_qual_products
62: WHERE source_id = p_source_id
63: AND trans_object_type_id = p_trans_id;
64:
65: DELETE FROM jtf_tae_qual_factors o
66: WHERE NOT EXISTS
67: ( SELECT NULL
68: FROM jtf_tae_qual_products i
69: WHERE MOD(i.relation_product, o.relation_factor) = 0 );

Line 133: DELETE FROM jtf_tae_qual_factors o

129: DELETE FROM jtf_tae_qual_prod_factors
130: WHERE qual_product_id = l_qual_prd_id_tbl(i);
131: END IF;
132:
133: DELETE FROM jtf_tae_qual_factors o
134: WHERE NOT EXISTS
135: ( SELECT NULL
136: FROM jtf_tae_qual_products i
137: WHERE MOD(i.relation_product, o.relation_factor) = 0 );

Line 376: FROM JTF_TAE_QUAL_factors

372: FOR q_detail in qual_details(qual_name.qual_usg_id) LOOP
373:
374: SELECT count(*)
375: INTO l_exist_qual_detail_count
376: FROM JTF_TAE_QUAL_factors
377: WHERE qual_usg_id = q_detail.qual_usg_id;
378:
379: IF l_exist_qual_detail_count = 0 THEN
380:

Line 383: SELECT JTF_TAE_QUAL_factors_s.NEXTVAL

379: IF l_exist_qual_detail_count = 0 THEN
380:
381: BEGIN
382:
383: SELECT JTF_TAE_QUAL_factors_s.NEXTVAL
384: INTO l_qual_factor_id
385: FROM dual;
386:
387: INSERT INTO JTF_TAE_QUAL_factors

Line 387: INSERT INTO JTF_TAE_QUAL_factors

383: SELECT JTF_TAE_QUAL_factors_s.NEXTVAL
384: INTO l_qual_factor_id
385: FROM dual;
386:
387: INSERT INTO JTF_TAE_QUAL_factors
388: ( QUAL_FACTOR_ID,
389: RELATION_FACTOR,
390: QUAL_USG_ID,
391: LAST_UPDATED_BY,

Line 824: FROM JTF_TAE_QUAL_factors

820: BEGIN
821:
822: SELECT qual_factor_id
823: INTO l_qual_factor_id
824: FROM JTF_TAE_QUAL_factors
825: WHERE qual_usg_id = qual_name.qual_usg_id
826: AND rownum < 2;
827:
828: SELECT JTF_TAE_QUAL_PROD_FACTORS_S.NEXTVAL

Line 875: update JTF_TAE_QUAL_factors

871: END LOOP; /* end loop FOR i IN p_qual_prd_tbl.FIRST .. p_qual_prd_tbl.LAST */
872: END IF; /* end IF (p_qual_prd_tbl.COUNT > 0) */
873:
874: /* no need to build the index for the qualifiers with no column mapped to TRANS table */
875: update JTF_TAE_QUAL_factors
876: set UPDATE_SELECTIVITY_FLAG = 'N',
877: USE_TAE_COL_IN_INDEX_FLAG = 'N'
878: where TAE_COL_MAP is null;
879:

Line 1912: JTF_TAE_QUAL_factors f

1908: CURSOR all_sets(cl_source_id number, cl_trans_id number) is
1909: SELECT p.trans_object_type_id, count(*) num_components, p.qual_product_id qual_product_id, p.relation_product
1910: FROM JTF_TAE_QUAL_products p,
1911: JTF_TAE_QUAL_prod_factors pf,
1912: JTF_TAE_QUAL_factors f
1913: WHERE p.qual_product_id = pf.qual_product_id
1914: AND pf.qual_factor_id = f.qual_factor_id
1915: AND f.tae_col_map is not null
1916: AND p.source_id = cl_source_id

Line 1943: JTF_TAE_QUAL_factors ifc

1939: FROM JTF_TAE_QUAL_products p
1940: WHERE NOT EXISTS (SELECT *
1941: FROM JTF_TAE_QUAL_products ip,
1942: JTF_TAE_QUAL_prod_factors ipf,
1943: JTF_TAE_QUAL_factors ifc
1944: WHERE use_tae_col_in_index_flag = 'Y'
1945: AND ip.qual_product_id = ipf.qual_product_id
1946: AND ipf.qual_factor_id = ifc.qual_factor_id
1947: AND ip.qual_product_id = p.qual_product_id)

Line 1982: JTF_TAE_QUAL_factors f

1978: FROM (
1979: SELECT DISTINCT p.relation_product, f.tae_col_map, f.input_selectivity
1980: FROM JTF_TAE_QUAL_products p,
1981: JTF_TAE_QUAL_prod_factors pf,
1982: JTF_TAE_QUAL_factors f
1983: WHERE f.qual_factor_id = pf.qual_factor_id
1984: AND pf.qual_product_id = p.qual_product_id
1985: AND p.relation_product = cl_set_S.relation_product
1986: AND f.tae_col_map is not null

Line 1996: JTF_TAE_QUAL_factors f

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

Line 2024: JTF_TAE_QUAL_factors f

2020: SELECT qual_usg_id, tae_col_map, rownum row_count
2021: FROM (
2022: SELECT f.qual_usg_id, f.relation_factor, f.tae_col_map
2023: FROM JTF_TAE_QUAL_prod_factors pf,
2024: JTF_TAE_QUAL_factors f
2025: WHERE pf.qual_factor_id = f.qual_factor_id
2026: AND pf.qual_product_id = cl_set_S.qual_product_id
2027: ORDER BY f.input_selectivity)) ilv1,
2028: (