销售订单行booked后，挑库到待发库，突然决定不再发货，对订单行作backordered,但是订单行的状态没有变为cancle,仍然是picked,导致整个订单无法关闭！

具体操作步骤：
　　
　　1)om/order organizer /new sale order i create an sale order ,entry order line ordered item:C.BT.250-100G-2.8.J　02 qty: is 11
　　2) om/ship transaction/pick release reserved 11.and transer to satged subinventory 'DFK'.
   
    3) later,i do not want to ship it to custmer, in ship transaction form, i do backordered,delivery is clos
　　ed,but order line status is
　　picked, in ship transaction form, query it ,line pick status is staged, reserved is not released.

solution:

　　Dwon the script. from Metalink
  
   Declare
     l_line_id　 number := &order_line_id;
　　 l_user_id　 number;
　　 l_resp_id　 number;
　　 l_resp_appl_id number;
　　 l_wf_exists varchar2(1) := 'Y';

Begin
　　update oe_order_lines_all
       set ordered_quantity　 = 0,
           cancelled_quantity = nvl(cancelled_quantity, 0) + ordered_quantity ,
           cancelled_flag　　 = 'Y',