[Home] [Help]
859:
860: code_debug('delete_old_icc_attrs : ' || ' Entering method ');
861:
862: DELETE
863: FROM ego_mtl_sy_items_ext_tl
864: WHERE inventory_item_id = p_inventory_item_id
865: AND attr_group_id NOT IN
866: (SELECT ATTR_GROUP_ID
867: FROM EGO_OBJ_ATTR_GRP_ASSOCS_V AGV,
2367:
2368: -----------------------------------------------------------------------------
2369: -- Insert corresponding rows in the TL table for each B table row we added --
2370: -----------------------------------------------------------------------------
2371: INSERT INTO EGO_MTL_SY_ITEMS_EXT_TL
2372: (
2373: EXTENSION_ID
2374: ,ORGANIZATION_ID
2375: ,INVENTORY_ITEM_ID