| Operation Details |  |
| Description: | Returns the number of units delivered except for the service unit delivery which is been modified. |
| Sterotype: | ns |
| SQL | |
SELECT SUM(numberOfUnits) INTO :count FROM ServiceUnitDelivery WHERE plannedItemID = :plannedItemID AND recordStatus = :recordStatus AND serviceUnitDeliveryID <> :serviceUnitDeliveryID |