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.JTY_TAE_CONTROL_PVT dependencies on JTY_DEA_ATTR_PRODUCTS

Line 97: FROM jty_dea_attr_products

93:
94: DELETE FROM jty_dea_attr_prod_factors
95: WHERE dea_attr_products_id IN
96: ( SELECT dea_attr_products_id
97: FROM jty_dea_attr_products
98: WHERE source_id = p_source_id
99: AND trans_type_id = p_trans_id);
100:
101: DELETE FROM jty_dea_attr_products

Line 101: DELETE FROM jty_dea_attr_products

97: FROM jty_dea_attr_products
98: WHERE source_id = p_source_id
99: AND trans_type_id = p_trans_id);
100:
101: DELETE FROM jty_dea_attr_products
102: WHERE source_id = p_source_id
103: AND trans_type_id = p_trans_id;
104:
105: DELETE FROM jty_dea_attr_factors o

Line 108: FROM jty_dea_attr_products i

104:
105: DELETE FROM jty_dea_attr_factors o
106: WHERE NOT EXISTS
107: ( SELECT NULL
108: FROM jty_dea_attr_products i
109: WHERE MOD(i.attr_relation_product, o.relation_factor) = 0 );
110:
111: DELETE FROM jty_dea_attr_products_sql
112: WHERE source_id = p_source_id

Line 111: DELETE FROM jty_dea_attr_products_sql

107: ( SELECT NULL
108: FROM jty_dea_attr_products i
109: WHERE MOD(i.attr_relation_product, o.relation_factor) = 0 );
110:
111: DELETE FROM jty_dea_attr_products_sql
112: WHERE source_id = p_source_id
113: AND trans_type_id = p_trans_id
114: AND keep_flag <> 'Y';
115:

Line 166: DELETE FROM jty_dea_attr_products

162: END;
163: ELSIF (p_mode = 'DEA INCREMENTAL') THEN
164: BEGIN
165:
166: DELETE FROM jty_dea_attr_products
167: WHERE source_id = p_source_id
168: AND trans_type_id = p_trans_id
169: AND attr_relation_product not in (
170: SELECT qual_relation_product

Line 187: FROM jty_dea_attr_products i

183:
184: DELETE FROM jty_dea_attr_factors o
185: WHERE NOT EXISTS
186: ( SELECT NULL
187: FROM jty_dea_attr_products i
188: WHERE MOD(i.attr_relation_product, o.relation_factor) = 0 );
189:
190: IF (l_rel_prd_tbl.COUNT > 0) THEN
191: FORALL i IN l_rel_prd_tbl.FIRST .. l_rel_prd_tbl.LAST

Line 192: DELETE FROM jty_dea_attr_products_sql

188: WHERE MOD(i.attr_relation_product, o.relation_factor) = 0 );
189:
190: IF (l_rel_prd_tbl.COUNT > 0) THEN
191: FORALL i IN l_rel_prd_tbl.FIRST .. l_rel_prd_tbl.LAST
192: DELETE FROM jty_dea_attr_products_sql
193: WHERE source_id = p_source_id
194: AND trans_type_id = p_trans_id
195: AND attr_relation_product = l_rel_prd_tbl(i)
196: AND keep_flag <> 'Y';

Line 1035: SELECT JTY_DEA_ATTR_PRODUCTS_S.NEXTVAL

1031: IF (p_qual_prd_tbl.COUNT > 0) THEN
1032: FOR i IN p_qual_prd_tbl.FIRST .. p_qual_prd_tbl.LAST LOOP
1033: l_counter := l_counter + 1;
1034:
1035: SELECT JTY_DEA_ATTR_PRODUCTS_S.NEXTVAL
1036: INTO l_qual_product_id
1037: FROM dual;
1038:
1039: -- POPULATE PRODUCTS

Line 1044: INSERT INTO JTY_DEA_ATTR_PRODUCTS

1040: IF ((p_qual_prd_tbl(i) <> 1) AND (p_qual_prd_tbl(i) IS NOT NULL)) THEN
1041:
1042: BEGIN
1043:
1044: INSERT INTO JTY_DEA_ATTR_PRODUCTS
1045: ( DEA_ATTR_PRODUCTS_ID,
1046: ATTR_RELATION_PRODUCT,
1047: SOURCE_ID,
1048: TRANS_TYPE_ID,

Line 2125: FROM jty_dea_attr_products p,

2121: l_first_char_flag_count NUMBER;
2122:
2123: CURSOR all_sets(cl_source_id number, cl_trans_id number) is
2124: SELECT p.trans_type_id, count(*) num_components, p.dea_attr_products_id dea_attr_products_id, p.attr_relation_product
2125: FROM jty_dea_attr_products p,
2126: jty_dea_attr_prod_factors pf,
2127: jty_dea_attr_factors f
2128: WHERE p.dea_attr_products_id = pf.dea_attr_products_id
2129: AND pf.dea_attr_factors_id = f.dea_attr_factors_id

Line 2142: FROM jty_dea_attr_products p,

2138: , cl_source_id NUMBER
2139: , cl_trans_id NUMBER ) is
2140: SELECT * FROM (
2141: SELECT count(*) num_components, p.dea_attr_products_id dea_attr_products_id, p.attr_relation_product
2142: FROM jty_dea_attr_products p,
2143: jty_dea_attr_prod_factors pf
2144: WHERE p.dea_attr_products_id = pf.dea_attr_products_id
2145: AND p.source_id = cl_source_id
2146: AND p.trans_type_id = cl_trans_id

Line 2154: FROM jty_dea_attr_products p

2150: ORDER BY 1 DESC, dea_attr_products_id ASC;
2151:
2152: CURSOR all_empty_column_indexes(cl_source_id number, cl_trans_id number) is
2153: SELECT p.trans_type_id, p.dea_attr_products_id, p.attr_relation_product
2154: FROM jty_dea_attr_products p
2155: WHERE NOT EXISTS (SELECT *
2156: FROM jty_dea_attr_products ip,
2157: jty_dea_attr_prod_factors ipf,
2158: jty_dea_attr_factors ifc

Line 2156: FROM jty_dea_attr_products ip,

2152: CURSOR all_empty_column_indexes(cl_source_id number, cl_trans_id number) is
2153: SELECT p.trans_type_id, p.dea_attr_products_id, p.attr_relation_product
2154: FROM jty_dea_attr_products p
2155: WHERE NOT EXISTS (SELECT *
2156: FROM jty_dea_attr_products ip,
2157: jty_dea_attr_prod_factors ipf,
2158: jty_dea_attr_factors ifc
2159: WHERE use_tae_col_in_index_flag = 'Y'
2160: AND ip.dea_attr_products_id = ipf.dea_attr_products_id

Line 2192: FROM jty_dea_attr_products p,

2188: FROM (
2189: SELECT rownum row_count, tae_col_map, input_selectivity
2190: FROM (
2191: SELECT DISTINCT p.attr_relation_product, f.tae_col_map, f.input_selectivity
2192: FROM jty_dea_attr_products p,
2193: jty_dea_attr_prod_factors pf,
2194: jty_dea_attr_factors f
2195: WHERE f.dea_attr_factors_id = pf.dea_attr_factors_id
2196: AND pf.dea_attr_products_id = p.dea_attr_products_id

Line 2206: FROM jty_dea_attr_products p,

2202: (
2203: SELECT rownum row_count, tae_col_map, input_selectivity
2204: FROM (
2205: SELECT DISTINCT p.attr_relation_product, f.tae_col_map, f.input_selectivity
2206: FROM jty_dea_attr_products p,
2207: jty_dea_attr_prod_factors pf,
2208: jty_dea_attr_factors f
2209: WHERE f.dea_attr_factors_id = pf.dea_attr_factors_id
2210: AND pf.dea_attr_products_id = p.dea_attr_products_id

Line 2255: UPDATE JTY_DEA_ATTR_PRODUCTS

2251: l_first_char_flag := 'N';
2252: END IF;
2253:
2254: IF S_subset_L = 'Y' THEN
2255: UPDATE JTY_DEA_ATTR_PRODUCTS
2256: SET BUILD_INDEX_FLAG = 'N', FIRST_CHAR_FLAG = l_first_char_flag
2257: WHERE dea_attr_products_id = cl_set_S.dea_attr_products_id
2258: AND attr_relation_product NOT IN (4841, 324347);
2259:

Line 2260: UPDATE JTY_DEA_ATTR_PRODUCTS

2256: SET BUILD_INDEX_FLAG = 'N', FIRST_CHAR_FLAG = l_first_char_flag
2257: WHERE dea_attr_products_id = cl_set_S.dea_attr_products_id
2258: AND attr_relation_product NOT IN (4841, 324347);
2259:
2260: UPDATE JTY_DEA_ATTR_PRODUCTS
2261: SET FIRST_CHAR_FLAG = l_first_char_flag
2262: WHERE dea_attr_products_id = cl_set_S.dea_attr_products_id
2263: AND attr_relation_product IN (4841, 324347);
2264: ELSE

Line 2265: UPDATE JTY_DEA_ATTR_PRODUCTS

2261: SET FIRST_CHAR_FLAG = l_first_char_flag
2262: WHERE dea_attr_products_id = cl_set_S.dea_attr_products_id
2263: AND attr_relation_product IN (4841, 324347);
2264: ELSE
2265: UPDATE JTY_DEA_ATTR_PRODUCTS
2266: SET BUILD_INDEX_FLAG = 'Y', FIRST_CHAR_FLAG = l_first_char_flag
2267: WHERE dea_attr_products_id = cl_set_S.dea_attr_products_id;
2268: END IF;
2269:

Line 2270: UPDATE JTY_DEA_ATTR_PRODUCTS

2266: SET BUILD_INDEX_FLAG = 'Y', FIRST_CHAR_FLAG = l_first_char_flag
2267: WHERE dea_attr_products_id = cl_set_S.dea_attr_products_id;
2268: END IF;
2269:
2270: UPDATE JTY_DEA_ATTR_PRODUCTS
2271: SET FIRST_CHAR_FLAG = 'Y'
2272: WHERE dea_attr_products_id = cl_set_S.dea_attr_products_id
2273: AND attr_relation_product = 353393;
2274:

Line 2280: UPDATE JTY_DEA_ATTR_PRODUCTS p

2276:
2277: -- Set reduction complete
2278: -- Set build_index_flag = 'N' for all empty column indexes combinations
2279: FOR empty_column_index in all_empty_column_indexes(p_source_id, p_trans_id) LOOP
2280: UPDATE JTY_DEA_ATTR_PRODUCTS p
2281: SET BUILD_INDEX_FLAG = 'N'
2282: WHERE p.dea_attr_products_id = empty_column_index.dea_attr_products_id;
2283: END LOOP;
2284: