DBA Data[Home] [Help]

APPS.QP_ITEMGROUP_UPG_UTIL_PVT dependencies on MTL_CATEGORIES_TL

Line 194: INSERT INTO mtl_categories_tl

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
195: (
196: category_id,
197: language,
198: source_lang,

Line 217: FROM mtl_categories_tl t

213: l_user_id
214: FROM FND_LANGUAGES l
215: WHERE l.INSTALLED_FLAG in ('I', 'B')
216: AND NOT EXISTS (SELECT 'X'
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