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 87: FROM jty_dea_attr_products

83:
84: DELETE FROM jty_dea_attr_prod_factors
85: WHERE dea_attr_products_id IN
86: ( SELECT dea_attr_products_id
87: FROM jty_dea_attr_products
88: WHERE source_id = p_source_id
89: AND trans_type_id = p_trans_id);
90:
91: DELETE FROM jty_dea_attr_products

Line 91: DELETE FROM jty_dea_attr_products

87: FROM jty_dea_attr_products
88: WHERE source_id = p_source_id
89: AND trans_type_id = p_trans_id);
90:
91: DELETE FROM jty_dea_attr_products
92: WHERE source_id = p_source_id
93: AND trans_type_id = p_trans_id;
94:
95: DELETE FROM jty_dea_attr_factors o

Line 98: FROM jty_dea_attr_products i

94:
95: DELETE FROM jty_dea_attr_factors o
96: WHERE NOT EXISTS
97: ( SELECT NULL
98: FROM jty_dea_attr_products i
99: WHERE MOD(i.attr_relation_product, o.relation_factor) = 0 );
100:
101: DELETE FROM jty_dea_attr_products_sql
102: WHERE source_id = p_source_id

Line 101: DELETE FROM jty_dea_attr_products_sql

97: ( SELECT NULL
98: FROM jty_dea_attr_products i
99: WHERE MOD(i.attr_relation_product, o.relation_factor) = 0 );
100:
101: DELETE FROM jty_dea_attr_products_sql
102: WHERE source_id = p_source_id
103: AND trans_type_id = p_trans_id
104: AND keep_flag <> 'Y';
105:

Line 1007: SELECT JTY_DEA_ATTR_PRODUCTS_S.NEXTVAL

1003: IF (p_qual_prd_tbl.COUNT > 0) THEN
1004: FOR i IN p_qual_prd_tbl.FIRST .. p_qual_prd_tbl.LAST LOOP
1005: l_counter := l_counter + 1;
1006:
1007: SELECT JTY_DEA_ATTR_PRODUCTS_S.NEXTVAL
1008: INTO l_qual_product_id
1009: FROM dual;
1010:
1011: -- POPULATE PRODUCTS

Line 1016: INSERT INTO JTY_DEA_ATTR_PRODUCTS

1012: IF ((p_qual_prd_tbl(i) <> 1) AND (p_qual_prd_tbl(i) IS NOT NULL)) THEN
1013:
1014: BEGIN
1015:
1016: INSERT INTO JTY_DEA_ATTR_PRODUCTS
1017: ( DEA_ATTR_PRODUCTS_ID,
1018: ATTR_RELATION_PRODUCT,
1019: SOURCE_ID,
1020: TRANS_TYPE_ID,

Line 2113: FROM jty_dea_attr_products p,

2109: l_first_char_flag_count NUMBER;
2110:
2111: CURSOR all_sets(cl_source_id number, cl_trans_id number) is
2112: SELECT p.trans_type_id, count(*) num_components, p.dea_attr_products_id dea_attr_products_id, p.attr_relation_product
2113: FROM jty_dea_attr_products p,
2114: jty_dea_attr_prod_factors pf,
2115: jty_dea_attr_factors f
2116: WHERE p.dea_attr_products_id = pf.dea_attr_products_id
2117: AND pf.dea_attr_factors_id = f.dea_attr_factors_id

Line 2130: FROM jty_dea_attr_products p,

2126: , cl_source_id NUMBER
2127: , cl_trans_id NUMBER ) is
2128: SELECT * FROM (
2129: SELECT count(*) num_components, p.dea_attr_products_id dea_attr_products_id, p.attr_relation_product
2130: FROM jty_dea_attr_products p,
2131: jty_dea_attr_prod_factors pf
2132: WHERE p.dea_attr_products_id = pf.dea_attr_products_id
2133: AND p.source_id = cl_source_id
2134: AND p.trans_type_id = cl_trans_id

Line 2142: FROM jty_dea_attr_products p

2138: ORDER BY 1 DESC, dea_attr_products_id ASC;
2139:
2140: CURSOR all_empty_column_indexes(cl_source_id number, cl_trans_id number) is
2141: SELECT p.trans_type_id, p.dea_attr_products_id, p.attr_relation_product
2142: FROM jty_dea_attr_products p
2143: WHERE NOT EXISTS (SELECT *
2144: FROM jty_dea_attr_products ip,
2145: jty_dea_attr_prod_factors ipf,
2146: jty_dea_attr_factors ifc

Line 2144: FROM jty_dea_attr_products ip,

2140: CURSOR all_empty_column_indexes(cl_source_id number, cl_trans_id number) is
2141: SELECT p.trans_type_id, p.dea_attr_products_id, p.attr_relation_product
2142: FROM jty_dea_attr_products p
2143: WHERE NOT EXISTS (SELECT *
2144: FROM jty_dea_attr_products ip,
2145: jty_dea_attr_prod_factors ipf,
2146: jty_dea_attr_factors ifc
2147: WHERE use_tae_col_in_index_flag = 'Y'
2148: AND ip.dea_attr_products_id = ipf.dea_attr_products_id

Line 2182: FROM jty_dea_attr_products p,

2178: FROM (
2179: SELECT rownum row_count, tae_col_map, input_selectivity
2180: FROM (
2181: SELECT DISTINCT p.attr_relation_product, f.tae_col_map, f.input_selectivity
2182: FROM jty_dea_attr_products p,
2183: jty_dea_attr_prod_factors pf,
2184: jty_dea_attr_factors f
2185: WHERE f.dea_attr_factors_id = pf.dea_attr_factors_id
2186: AND pf.dea_attr_products_id = p.dea_attr_products_id

Line 2196: FROM jty_dea_attr_products p,

2192: (
2193: SELECT rownum row_count, tae_col_map, input_selectivity
2194: FROM (
2195: SELECT DISTINCT p.attr_relation_product, f.tae_col_map, f.input_selectivity
2196: FROM jty_dea_attr_products p,
2197: jty_dea_attr_prod_factors pf,
2198: jty_dea_attr_factors f
2199: WHERE f.dea_attr_factors_id = pf.dea_attr_factors_id
2200: AND pf.dea_attr_products_id = p.dea_attr_products_id

Line 2245: UPDATE JTY_DEA_ATTR_PRODUCTS

2241: l_first_char_flag := 'N';
2242: END IF;
2243:
2244: IF S_subset_L = 'Y' THEN
2245: UPDATE JTY_DEA_ATTR_PRODUCTS
2246: SET BUILD_INDEX_FLAG = 'N', FIRST_CHAR_FLAG = l_first_char_flag
2247: WHERE dea_attr_products_id = cl_set_S.dea_attr_products_id
2248: AND attr_relation_product NOT IN (4841, 324347);
2249:

Line 2250: UPDATE JTY_DEA_ATTR_PRODUCTS

2246: SET BUILD_INDEX_FLAG = 'N', FIRST_CHAR_FLAG = l_first_char_flag
2247: WHERE dea_attr_products_id = cl_set_S.dea_attr_products_id
2248: AND attr_relation_product NOT IN (4841, 324347);
2249:
2250: UPDATE JTY_DEA_ATTR_PRODUCTS
2251: SET FIRST_CHAR_FLAG = l_first_char_flag
2252: WHERE dea_attr_products_id = cl_set_S.dea_attr_products_id
2253: AND attr_relation_product IN (4841, 324347);
2254: ELSE

Line 2255: UPDATE JTY_DEA_ATTR_PRODUCTS

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

Line 2260: UPDATE JTY_DEA_ATTR_PRODUCTS

2256: SET BUILD_INDEX_FLAG = 'Y', FIRST_CHAR_FLAG = l_first_char_flag
2257: WHERE dea_attr_products_id = cl_set_S.dea_attr_products_id;
2258: END IF;
2259:
2260: UPDATE JTY_DEA_ATTR_PRODUCTS
2261: SET FIRST_CHAR_FLAG = 'Y'
2262: WHERE dea_attr_products_id = cl_set_S.dea_attr_products_id
2263: AND attr_relation_product = 353393;
2264:

Line 2270: UPDATE JTY_DEA_ATTR_PRODUCTS p

2266:
2267: -- Set reduction complete
2268: -- Set build_index_flag = 'N' for all empty column indexes combinations
2269: FOR empty_column_index in all_empty_column_indexes(p_source_id, p_trans_id) LOOP
2270: UPDATE JTY_DEA_ATTR_PRODUCTS p
2271: SET BUILD_INDEX_FLAG = 'N'
2272: WHERE p.dea_attr_products_id = empty_column_index.dea_attr_products_id;
2273: END LOOP;
2274: