[Script]Backordered Problematic delivery detail
来源:互联网 发布:php开启伪静态 编辑:程序博客网 时间:2024/05/29 06:28
脚本用于Backorder有问题Delivery Detail(比如关联的Move Order丢失...),可以backorder Delivery后,再重新Pick Release;如果不想要这个订单了,可以Backorder后,Cancel销售订单,并通过NOTE:1322105.1来删除多余的Reservation。
- UPDATE wsh_delivery_assignments
- SET delivery_id = NULL,
- parent_delivery_detail_id = NULL,
- last_updated_by = -1,
- last_update_date = SYSDATE
- WHERE delivery_detail_id = xxxx;
- UPDATE wsh_delivery_details
- SET released_status = 'D'
- , source_header_id = -(source_header_id)
- , source_line_id = -(source_line_id)
- , source_header_number = '-'||(source_header_number)
- , source_line_number = '-'||(source_line_number)
- , src_requested_quantity = 0
- , src_requested_quantity2 = decode(src_requested_quantity2,NULL,NULL,0)
- , requested_quantity = 0
- , requested_quantity2 = decode(requested_quantity2,NULL,NULL,0)
- , shipped_quantity = 0
- , shipped_quantity2 = decode(shipped_quantity2,NULL,NULL,0)
- , picked_quantity = 0
- , picked_quantity2 = decode(picked_quantity2,NULL,NULL,0)
- , cycle_count_quantity = 0
- , cycle_count_quantity2 = decode(src_requested_quantity2,NULL,NULL,0)
- , cancelled_quantity = decode(requested_quantity,0,cancelled_quantity,requested_quantity)
- , cancelled_quantity2 = decode(requested_quantity2,NULL,NULL,0,cancelled_quantity2,requested_quantity2)
- , subinventory = NULL
- , locator_id = NULL
- , lot_number = NULL
- , serial_number = NULL
- , to_serial_number = NULL
- , transaction_temp_id = NULL
- , revision = NULL
- , ship_set_id = NULL
- , inv_interfaced_flag = 'X'
- , oe_interfaced_flag = 'X'
- , last_updated_by = -1
- , last_update_date = SYSDATE
- WHERE delivery_detail_id = xxxx;
- Prompt COMMIT to save and ROLLBACK to revert the changes.
转自:http://blog.csdn.net/pan_tian/article/details/7697034
0 0
- [Script]Backordered Problematic delivery detail
- [Script]Backordered Problematic delivery detail
- Delivery
- detail
- The problematic NULLs
- Delivery Completed
- Continuous Delivery
- Delivery SQL
- Content Delivery
- script
- script
- script
- script
- script
- script
- script
- <script>
- script
- The constructor XMLOutputter(Format) is undefined
- 2015年大一下第8周项目1-存储班长信息的学生类(2)访问权限为private
- 正确编写概要设计说明书
- 配置OpenCV产生flann\logger.h(66): error C4996: 'fopen': This function or variable may be unsafe问题
- qt5_qml_Opengl_shader 第三弹-----------------------纹理贴图(YUV)
- [Script]Backordered Problematic delivery detail
- C#三层结构
- JavaMail的发送邮件
- The connection to adb is down, and a severe error has occured.问题解决方法小结
- java中的for each循环
- 安装oracle数据库后遇到数据入库为乱码的问题-由于oracle编码和系统编码不同导致
- OM System Parameter: Reservation Time Fence
- 积跬步至千里——算法强化训练(2)全排列和组合数
- 关于Activity跳转时机的小说明