首页 > 代码库 > Oracle EBS-SQL (OM-3):销售连接停靠站时冲减库存出错处理.sql

Oracle EBS-SQL (OM-3):销售连接停靠站时冲减库存出错处理.sql


DELETE FROM INV.MTL_RESERVATIONS MR
WHERE EXISTS (SELECT 1 FROM WSH.WSH_DELIVERY_ASSIGNMENTS WDA
                            ,WSH.WSH_DELIVERY_DETAILS    WDD
                 WHERE WDA.DELIVERY_DETAIL_ID = WDD.DELIVERY_DETAIL_ID
                     AND MR.INVENTORY_ITEM_ID = WDD.INVENTORY_ITEM_ID
                     AND MR.DEMAND_SOURCE_LINE_ID = WDD.SOURCE_LINE_ID
                     AND MR.ORGANIZATION_ID    = WDD.ORGANIZATION_ID
                     AND WDA.DELIVERY_ID = 3826)--在此输入出错的交货号。