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);
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.