APPS.QP_ITEMGROUP_UPG_UTIL_PVT dependencies on MTL_CATEGORY_SETS_TL

Line 275: FROM mtl_category_sets_b b, mtl_category_sets_tl t

271: l_oe_item_groups_rec.created_by,
272: 'Y'
273: FROM dual
274: WHERE NOT EXISTS (SELECT 'X'
275: FROM mtl_category_sets_b b, mtl_category_sets_tl t
276: WHERE b.category_set_id = t.category_set_id
277: AND b.structure_id = l_new_structure_id
278: AND t.category_set_name =
279: substr(upper(l_oe_item_groups_rec.name),1,15) || '_CATEGORY_SET');

Line 281: INSERT INTO mtl_category_sets_tl

277: AND b.structure_id = l_new_structure_id
278: AND t.category_set_name =
279: substr(upper(l_oe_item_groups_rec.name),1,15) || '_CATEGORY_SET');
280:
281: INSERT INTO mtl_category_sets_tl
282: (
283: category_set_id,
284: language,
285: source_lang,

Line 306: FROM mtl_category_sets_tl t

302: l_oe_item_groups_rec.created_by
303: FROM FND_LANGUAGES l
304: WHERE l.INSTALLED_FLAG IN ('I', 'B')
305: AND NOT EXISTS (SELECT 'X'
306: FROM mtl_category_sets_tl t
307: WHERE t.category_set_id = l_new_category_set_id
308: AND t.language = l.LANGUAGE_CODE)
309: AND EXISTS (SELECT 'X'
310: FROM mtl_category_sets_b b