DBA Data[Home] [Help]

APPS.ENGPKIMP dependencies on MTL_SYSTEM_ITEMS_TL

Line 3525: UPDATE mtl_system_items_tl SET description = l_new_description WHERE inventory_item_id = item.revised_item_id AND

3521: --commented out the below select statement for bug 9238945
3522: --SELECT new_item_description INTO l_new_description FROM eng_revised_items WHERE revised_item_sequence_id = item.revised_item_sequence_id;
3523:
3524: IF (l_new_description IS NOT NULL) THEN
3525: UPDATE mtl_system_items_tl SET description = l_new_description WHERE inventory_item_id = item.revised_item_id AND
3526: organization_id = item.organization_id AND source_lang = UserEnv('LANG');
3527: END IF;
3528: END;
3529: --Code changes for Enhancement 6084027 ends