APPS.ENI_UPGRADE_VSET dependencies on MTL_CATEGORY_SETS_B

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 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 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 363: FROM MTL_CATEGORY_SETS_B

359:
360: -- Get structure id for the default category set for Product FA
361:
362: SELECT STRUCTURE_ID,DEFAULT_CATEGORY_ID INTO g_struct_id,g_default_cat_id
363: FROM MTL_CATEGORY_SETS_B
364: WHERE CATEGORY_SET_ID = g_catset_id;
365:
366: -- Call Validate_structure from this procedure to do all the
367: -- validations. If everything is alright then move ahead.