APPS.JTY_TAE_CONTROL_PVT dependencies on JTF_TAE_QUAL_PROD_FACTORS

Line 54: DELETE FROM jtf_tae_qual_prod_factors

50:
51: IF (p_mode = 'TOTAL') THEN
52: BEGIN
53:
54: DELETE FROM jtf_tae_qual_prod_factors
55: WHERE qual_product_id IN
56: ( SELECT qual_product_id
57: FROM jtf_tae_qual_products
58: WHERE source_id = p_source_id

Line 129: DELETE FROM jtf_tae_qual_prod_factors

125: RETURNING qual_product_id, relation_product BULK COLLECT INTO l_qual_prd_id_tbl, l_rel_prd_tbl;
126:
127: IF (l_qual_prd_id_tbl.COUNT > 0) THEN
128: FORALL i IN l_qual_prd_id_tbl.FIRST .. l_qual_prd_id_tbl.LAST
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

Line 828: SELECT JTF_TAE_QUAL_PROD_FACTORS_S.NEXTVAL

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
829: INTO l_qual_prod_factor_id
830: FROM dual;
831:
832: INSERT INTO JTF_TAE_QUAL_prod_factors

Line 832: INSERT INTO JTF_TAE_QUAL_prod_factors

828: SELECT JTF_TAE_QUAL_PROD_FACTORS_S.NEXTVAL
829: INTO l_qual_prod_factor_id
830: FROM dual;
831:
832: INSERT INTO JTF_TAE_QUAL_prod_factors
833: ( QUAL_PROD_FACTOR_ID,
834: QUAL_PRODUCT_ID,
835: QUAL_FACTOR_ID,
836: LAST_UPDATE_DATE,

Line 861: x_msg_data := 'Populating JTF_TAE_QUAL_PROD_FACTORS table : Error no_data_found.';

857: );
858:
859: EXCEPTION
860: WHEN NO_DATA_FOUND THEN
861: x_msg_data := 'Populating JTF_TAE_QUAL_PROD_FACTORS table : Error no_data_found.';
862: RAISE FND_API.G_EXC_ERROR;
863:
864: WHEN OTHERS THEN
865: x_msg_data := SQLCODE || ' : ' || SQLERRM;

Line 1911: JTF_TAE_QUAL_prod_factors pf,

1907:
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

Line 1928: JTF_TAE_QUAL_prod_factors pf

1924: , cl_trans_id NUMBER ) is
1925: SELECT * FROM (
1926: SELECT count(*) num_components, p.qual_product_id qual_product_id, p.relation_product
1927: FROM JTF_TAE_QUAL_products p,
1928: JTF_TAE_QUAL_prod_factors pf
1929: WHERE p.qual_product_id = pf.qual_product_id
1930: AND p.source_id = cl_source_id
1931: AND p.trans_object_type_id = cl_trans_id
1932: GROUP BY p.qual_product_id, p.relation_product )

Line 1942: JTF_TAE_QUAL_prod_factors ipf,

1938: SELECT p.trans_object_type_id, p.qual_product_id, p.relation_product
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

Line 1981: JTF_TAE_QUAL_prod_factors pf,

1977: SELECT rownum row_count, tae_col_map, input_selectivity
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

Line 1995: JTF_TAE_QUAL_prod_factors pf,

1991: SELECT rownum row_count, tae_col_map, input_selectivity
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

Line 2023: FROM JTF_TAE_QUAL_prod_factors pf,

2019: FROM (
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,