Cancelled Sales Order shows Back Ordered in the shipping transactions form

Hi,

One of our SO is calcelled from the back end using a update statement.  The sales order line got cancelled but in the shipping transactions form, the SO line is till shown as back ordered.

Have checked for the reservations of the SO in the reservations form in inventory and there are no reservations for the item on the cancelled SO line against the sales order.

The update statement used for cancelling the SO line is:

UPDATE oe_order_lines_all
    SET schedule_ship_date  = NULL ,
      pricing_quantity      = 0 ,
      cancelled_quantity    = 10,
      ordered_quantity      = 0 ,
      visible_demand_flag   = NULL ,
      schedule_arrival_date = NULL ,