Item_Updation_Qry

UPDATE   mtl_system_items_b
   SET   INVENTORY_ITEM_FLAG = 'N',
         STOCK_ENABLED_FLAG = 'N',
         MTL_TRANSACTIONS_ENABLED_FLAG = 'N',
         REVISION_QTY_CONTROL_CODE = '1',
         COSTING_ENABLED_FLAG = 'N',
         INVENTORY_ASSET_FLAG = 'N',
         DEFAULT_INCLUDE_IN_ROLLUP_FLAG = 'N'
 WHERE   SEGMENT1 IN
               ('42000001'
                )