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)--在此输入出错的交货号。