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 MTL_CATEGORY_SET_VALID_CATS

Line 205: FROM mtl_categories_b a, mtl_category_set_valid_cats b, mtl_category_sets_b c

201: -- and do not have item assignments
202:
203: CURSOR c_out_hrchy(g_struct_id NUMBER, g_catset_id NUMBER) IS
204: SELECT segment1, a.category_id, b.category_set_id
205: FROM mtl_categories_b a, mtl_category_set_valid_cats b, mtl_category_sets_b c
206: WHERE a.structure_id = g_struct_id
207: AND b.category_set_id = g_catset_id
208: AND a.category_id = b.category_id
209: AND a.structure_id = c.structure_id

Line 256: SELECT category_id FROM mtl_category_set_valid_cats

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
257: WHERE a.category_id = category_id
258: AND category_set_id = g_catset_id)
259: UNION ALL
260: SELECT a.category_id, b.segment1, 2 flag -- update in valid cats

Line 261: FROM mtl_category_set_valid_cats a, mtl_categories_b b

257: WHERE a.category_id = category_id
258: AND category_set_id = g_catset_id)
259: UNION ALL
260: SELECT a.category_id, b.segment1, 2 flag -- update in valid cats
261: FROM mtl_category_set_valid_cats a, mtl_categories_b b
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(

Line 289: -- FROM MTL_CATEGORIES_B A, MTL_CATEGORY_SET_VALID_CATS B

285: AND ROWNUM = 1
286: );
287:
288: -- SELECT SEGMENT1, A.CATEGORY_ID, B.CATEGORY_SET_ID
289: -- FROM MTL_CATEGORIES_B A, MTL_CATEGORY_SET_VALID_CATS B
290: -- WHERE STRUCTURE_ID = g_struct_id
291: -- AND B.CATEGORY_SET_ID = g_catset_id
292: -- AND A.CATEGORY_ID = B.CATEGORY_ID
293: -- AND A.CATEGORY_ID IN (SELECT CATEGORY_ID

Line 322: mtl_categories_b v1, mtl_category_set_valid_cats h

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
326: AND f.parent_code = v1.segment1(+)

Line 574: FROM MTL_CATEGORY_SET_VALID_CATS

570: -- children's category id, the API will fail since by then the
571: -- child has already been deleted.
572:
573: SELECT COUNT(CATEGORY_ID) INTO l_catg
574: FROM MTL_CATEGORY_SET_VALID_CATS
575: WHERE CATEGORY_SET_ID = i.CATEGORY_SET_ID
576: AND CATEGORY_ID = i.CATEGORY_ID;
577:
578: IF l_catg <> 0 THEN

Line 671: -- mtl_category_set_valid_cats table if such a change

667: FND_FILE.PUT_LINE(FND_FILE.LOG, i.vset_child_code);
668: END IF;
669:
670: -- Will update the parent-child relationship in
671: -- mtl_category_set_valid_cats table if such a change
672: -- is detected
673: ELSIF NVL(i.vset_parent_id, -1) <> NVL(i.cat_parent_id, -1) THEN
674: IF l_update = 0 then
675: FND_FILE.PUT_LINE(FND_FILE.LOG, '');