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_CATEGORIES_B

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 43: SELECT SEGMENT1 FROM MTL_CATEGORIES_B

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;
45:
46: BEGIN
47:

Line 107: FROM mtl_categories_B A,

103: FND_FILE.PUT_LINE(FND_FILE.LOG, '-------------- ');
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

Line 135: FROM mtl_categories_b a,

131: FND_FILE.PUT_LINE(FND_FILE.LOG, '-------------- ');
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

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 228: FROM mtl_categories_b a

224: -- remain as stray categories under the product catalog
225:
226: CURSOR c_stray_catg(g_struct_id NUMBER, g_catset_id NUMBER) IS
227: SELECT segment1, a.category_id --, b.category_set_id
228: FROM mtl_categories_b a
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)

Line 249: FROM mtl_categories_b a

245: CURSOR c_item_assign(g_struct_id NUMBER, g_catset_id NUMBER) IS
246: SELECT a.category_id, a.segment1, flag
247: FROM (
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'

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 277: mtl_categories_b

273: AND b.category_set_id = g_catset_id)
274: UNION ALL
275: SELECT category_id, segment1,2 flag
276: FROM
277: mtl_categories_b
278: WHERE
279: category_id = g_default_cat_id
280: AND NOT EXISTS (
281: SELECT b.category_id

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 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 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 618: FROM mtl_categories_b

614: l_catg := 0;
615:
616: -- Getting the category id for the top node
617: SELECT category_id INTO l_catg
618: FROM mtl_categories_b
619: WHERE structure_id = g_struct_id
620: AND segment1 = p_top_node;
621:
622: FOR i IN C_INS_UPD(l_catg) LOOP