APPS.ENI_UPGRADE_VSET dependencies on MTL_ITEM_CATEGORIES

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 213: FROM mtl_item_categories

209: AND a.structure_id = c.structure_id
210: AND b.category_set_id = c.category_set_id
211: AND a.category_id <> c.default_category_id
212: AND a.category_id NOT IN (SELECT category_id
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

Line 230: AND EXISTS (SELECT 'X' FROM mtl_item_categories b

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)
233: AND NOT EXISTS(SELECT child_code FROM eni_vset_hrchy_temp
234: WHERE A.segment1 = child_code

Line 271: SELECT category_id FROM mtl_item_categories b

267: -- WHERE hrchy_flag = 'Y'
268: -- AND child_code = b.segment1)
269: ) a
270: WHERE EXISTS(
271: SELECT category_id FROM mtl_item_categories b
272: WHERE a.category_id = b.category_id
273: AND b.category_set_id = g_catset_id)
274: UNION ALL
275: SELECT category_id, segment1,2 flag

Line 283: mtl_item_categories b

279: category_id = g_default_cat_id
280: AND NOT EXISTS (
281: SELECT b.category_id
282: FROM
283: mtl_item_categories b
284: WHERE b.category_id = g_default_cat_id
285: AND ROWNUM = 1
286: );
287:

Line 294: -- FROM MTL_ITEM_CATEGORIES

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
294: -- FROM MTL_ITEM_CATEGORIES
295: -- WHERE CATEGORY_ID = A.CATEGORY_ID
296: -- AND CATEGORY_SET_ID = B.CATEGORY_SET_ID
297: -- AND ROWNUM = 1)
298: -- AND p_validation_mode = 'N';