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.ENI_UPGRADE_VSET dependencies on ENI_VSET_HRCHY_TEMP

Line 19: FROM ENI_VSET_HRCHY_TEMP

15: -- this cursor selects all records with more than one parent
16: -- in the value set hierarchy
17: CURSOR C_DUP IS
18: SELECT CHILD_CODE, COUNT(PARENT_CODE) COUNT
19: FROM ENI_VSET_HRCHY_TEMP
20: WHERE HRCHY_FLAG = 'Y'
21: GROUP BY CHILD_CODE
22: HAVING COUNT(PARENT_CODE) > 1;
23:

Line 28: FROM MTL_ITEM_CATEGORIES A, MTL_CATEGORIES_B B, ENI_VSET_HRCHY_TEMP C

24: -- Cursor that selects all parent categories having item assignments
25:
26: CURSOR c_parent_item_assgn(g_struct_id NUMBER, g_catset_id NUMBER) IS
27: SELECT B.SEGMENT1, COUNT(INVENTORY_ITEM_ID) NUMBER_ITEMS
28: FROM MTL_ITEM_CATEGORIES A, MTL_CATEGORIES_B B, ENI_VSET_HRCHY_TEMP C
29: WHERE A.CATEGORY_SET_ID = g_catset_id
30: AND A.CATEGORY_ID = b.category_id
31: AND B.STRUCTURE_ID = g_struct_id
32: AND B.SEGMENT1 = C.PARENT_CODE

Line 40: SELECT CHILD_CODE FROM ENI_VSET_HRCHY_TEMP

36: -- Cursor that selects all nodes in the value set whose corresponding
37: -- categories do not exist
38:
39: CURSOR c_new_nodes(g_struct_id NUMBER) IS
40: SELECT CHILD_CODE FROM ENI_VSET_HRCHY_TEMP
41: WHERE HRCHY_FLAG = 'Y'
42: MINUS
43: SELECT SEGMENT1 FROM MTL_CATEGORIES_B
44: WHERE STRUCTURE_ID = g_struct_id;

Line 108: mtl_category_sets_b B -- ,ENI_VSET_HRCHY_TEMP C

104:
105: BEGIN
106: SELECT A.segment1 INTO l_catg
107: FROM mtl_categories_B A,
108: mtl_category_sets_b B -- ,ENI_VSET_HRCHY_TEMP C
109: WHERE A.category_id = B.default_category_id
110: AND A.structure_id = B.structure_id
111: AND B.CATEGORY_SET_ID = g_catset_id
112: AND NOT EXISTS (SELECT child_code FROM eni_vset_hrchy_temp

Line 112: AND NOT EXISTS (SELECT child_code FROM eni_vset_hrchy_temp

108: mtl_category_sets_b B -- ,ENI_VSET_HRCHY_TEMP C
109: WHERE A.category_id = B.default_category_id
110: AND A.structure_id = B.structure_id
111: AND B.CATEGORY_SET_ID = g_catset_id
112: AND NOT EXISTS (SELECT child_code FROM eni_vset_hrchy_temp
113: WHERE child_code = a.segment1
114: AND hrchy_flag = 'Y');
115:
116: FND_FILE.PUT_LINE(FND_FILE.LOG, l_catg);

Line 136: mtl_category_sets_b b, eni_vset_hrchy_temp c

132:
133: BEGIN
134: SELECT a.segment1 INTO l_catg
135: FROM mtl_categories_b a,
136: mtl_category_sets_b b, eni_vset_hrchy_temp c
137: WHERE a.category_id = b.default_category_id
138: AND a.structure_id = b.structure_id
139: AND b.category_set_id = g_catset_id
140: AND a.segment1 = c.parent_code

Line 217: AND NOT EXISTS(SELECT child_code FROM eni_vset_hrchy_temp

213: FROM mtl_item_categories
214: WHERE category_id = a.category_id
215: AND category_set_id = b.category_set_id
216: AND ROWNUM = 1)
217: AND NOT EXISTS(SELECT child_code FROM eni_vset_hrchy_temp
218: WHERE a.segment1 = child_code
219: AND hrchy_flag = 'Y'
220: AND child_code <> p_top_node);
221:

Line 233: AND NOT EXISTS(SELECT child_code FROM eni_vset_hrchy_temp

229: WHERE structure_id = g_struct_id
230: AND EXISTS (SELECT 'X' FROM mtl_item_categories b
231: WHERE a.category_id = b.category_id
232: AND b.category_set_id = g_catset_id)
233: AND NOT EXISTS(SELECT child_code FROM eni_vset_hrchy_temp
234: WHERE A.segment1 = child_code
235: AND hrchy_flag = 'Y')
236: AND p_validation_mode = 'Y';
237:

Line 252: SELECT child_code FROM eni_vset_hrchy_temp

248: SELECT a.category_id, segment1, 1 flag -- create in valid cats
249: FROM mtl_categories_b a
250: WHERE a.structure_id = g_struct_id
251: AND NOT EXISTS(
252: SELECT child_code FROM eni_vset_hrchy_temp
253: WHERE hrchy_flag = 'Y'
254: AND child_code = a.segment1)
255: AND NOT EXISTS(
256: SELECT category_id FROM mtl_category_set_valid_cats

Line 266: -- SELECT child_code FROM eni_vset_hrchy_temp

262: WHERE a.category_set_id = g_catset_id
263: AND a.category_id = b.category_id
264: AND b.structure_id = g_struct_id
265: -- AND NOT EXISTS(
266: -- SELECT child_code FROM eni_vset_hrchy_temp
267: -- WHERE hrchy_flag = 'Y'
268: -- AND child_code = b.segment1)
269: ) a
270: WHERE EXISTS(

Line 303: FROM eni_vset_hrchy_temp

299:
300: CURSOR c_check_temp(segment VARCHAR2) IS
301: SELECT 1 exist_flag FROM DUAL
302: WHERE NOT EXISTS(SELECT child_code
303: FROM eni_vset_hrchy_temp
304: WHERE child_code = segment
305: AND hrchy_flag = 'Y'
306: AND rownum = 1)
307: AND p_validation_mode = 'N';

Line 321: FROM eni_vset_hrchy_temp f, mtl_categories_b v,

317: DECODE(v1.category_id,l_catg,NULL, v1.category_id) VSET_PARENT_ID,
318: h.category_id CAT_CHILD_ID,
319: h.parent_category_id CAT_PARENT_ID,
320: g_catset_id CATEGORY_SET_ID
321: FROM eni_vset_hrchy_temp f, mtl_categories_b v,
322: mtl_categories_b v1, mtl_category_set_valid_cats h
323: WHERE v.structure_id = g_struct_id
324: AND v1.structure_id(+) = g_struct_id
325: AND f.child_code = v.segment1

Line 371: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || l_schema || '.ENI_VSET_HRCHY_TEMP';

367: -- validations. If everything is alright then move ahead.
368:
369: -- populating the entire value set into the temp table
370: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Truncating the temp table ... ');
371: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || l_schema || '.ENI_VSET_HRCHY_TEMP';
372:
373: INSERT INTO ENI_VSET_HRCHY_TEMP(
374: CHILD_CODE,
375: PARENT_CODE,

Line 373: INSERT INTO ENI_VSET_HRCHY_TEMP(

369: -- populating the entire value set into the temp table
370: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Truncating the temp table ... ');
371: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || l_schema || '.ENI_VSET_HRCHY_TEMP';
372:
373: INSERT INTO ENI_VSET_HRCHY_TEMP(
374: CHILD_CODE,
375: PARENT_CODE,
376: HRCHY_FLAG)
377: SELECT

Line 392: INSERT INTO ENI_VSET_HRCHY_TEMP (

388: -- into the temp table
389:
390: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Populating hierarchy in temp table under the top node');
391:
392: INSERT INTO ENI_VSET_HRCHY_TEMP (
393: CHILD_CODE,
394: PARENT_CODE,
395: HRCHY_FLAG)
396: SELECT CHILD_CODE, PARENT_CODE, 'Y'

Line 397: FROM ENI_VSET_HRCHY_TEMP H

393: CHILD_CODE,
394: PARENT_CODE,
395: HRCHY_FLAG)
396: SELECT CHILD_CODE, PARENT_CODE, 'Y'
397: FROM ENI_VSET_HRCHY_TEMP H
398: CONNECT BY PRIOR CHILD_CODE = PARENT_CODE
399: START WITH CHILD_CODE = p_top_node;
400:
401: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Rows inserted: ' || sql%rowcount);