Update_Item_Category

UPDATE   mtl_item_categories
   SET   organization_id = 124                            --category_id = 8181
 WHERE   INVENTORY_ITEM_ID IN
               (SELECT   INVENTORY_ITEM_ID
                  FROM   MTL_SYSTEM_ITEMS_B
                 WHERE   SEGMENT1 IN
                               ('42000008')