delete from wms_stock where wh_code = '1001';
delete from wms_batch_attribute where wh_code = '1001';
delete from wms_into_order where wh_code = '1001';
delete from wms_out_order_head where wh_code = '1001';
delete from wms_out_order where wh_code = '1001';
delete from wms_adjust_order where wh_code = '1001';
delete from wms_transfer_order where wh_code = '1001';
delete from wms_count_order_head where wh_code = '1001';
delete from wms_count_order where wh_code = '1001';
delete from wms_count_task where wh_code = '1001';
delete from wms_into_task where wh_code = '1001';
delete from wms_out_task where wh_code = '1001';
delete from wms_out_trace where wh_code = '1001';
delete from wms_out_wave where wh_code = '1001';
delete from wms_move_task where wh_code = '1001';
delete from wms_account_result where wh_code = '1001';
delete from wms_account_result_index where wh_code = '1001';
delete from wms_account_result_clob where wh_code = '1001';
delete from wms_stock_change_record where wh_code = '1001';
--库存清空，容器留在仓位中，所以只需置为空容器，无需置为空仓，如果容器需要拿下来，则将状态置为1，空仓位
update wms_bin set bin_status = '2' where wh_code = '1001' and (container_code is not null or container_code = '');
--分播墙和缓存架，容器拿走，所以容器号清除，仓位置为空仓
update wms_bin set bin_status = '1', container_code = '', lock_code = '' where wh_code = '1001' and pod_code in (select pod_code from wms_pod where pod_category in ('2', '3'));