APPS.QP_ITEMGROUP_UPG_UTIL_PVT dependencies on MTL_CATEGORIES_B

Line 164: INSERT INTO mtl_categories_b

160: INTO l_new_category_id
161: FROM dual;
162:
163: BEGIN
164: INSERT INTO mtl_categories_b
165: (
166: category_id,
167: structure_id,
168: last_update_date,

Line 190: FROM mtl_categories_b b

186: l_enabled_flag, -- whether segment combination is enabled
187: 'Item Category for Item Groups'
188: FROM dual
189: WHERE NOT EXISTS (SELECT 'X'
190: FROM mtl_categories_b b
191: WHERE b.structure_id = l_new_structure_id
192: AND b.segment1 = 'Item Category for Item Groups');
193:
194: INSERT INTO mtl_categories_tl

Line 221: FROM mtl_categories_b b

217: FROM mtl_categories_tl t
218: WHERE t.category_id = l_new_category_id
219: AND t.language = l.LANGUAGE_CODE)
220: AND EXISTS (SELECT 'X'
221: FROM mtl_categories_b b
222: WHERE b.category_id = l_new_category_id);
223:
224: EXCEPTION
225: WHEN OTHERS THEN

Line 353: FROM mtl_categories_b b

349: l_oe_item_group_lines_rec.creation_date,
350: l_oe_item_group_lines_rec.created_by
351: FROM dual
352: WHERE EXISTS (SELECT 'X'
353: FROM mtl_categories_b b
354: WHERE b.category_id = l_new_category_id)
355: AND EXISTS (SELECT 'X'
356: FROM mtl_category_sets_b s
357: WHERE s.category_set_id = l_new_category_set_id);