Thursday, November 7, 2013

Script to cancel delivery detail line

UPDATE wsh_delivery_details
   SET released_status = 'D',
       src_requested_quantity = 0,
       requested_quantity = 0,
       shipped_quantity = 0,
       cycle_count_quantity = 0,
       cancelled_quantity = 0,
       subinventory = NULL,
       locator_id = NULL,
       lot_number = NULL,
       revision = NULL,
       inv_interfaced_flag = 'X',
       oe_interfaced_flag = 'X'
 WHERE delivery_detail_id IN (970233316, 970233320);

No comments:

Post a Comment

Note: Only a member of this blog may post a comment.