| Operation Details |  |
| Description: | Lists all service unit deliveries. |
| Sterotype: | nsmulti |
| SQL | |
SELECT serviceUnitDeliveryID, plannedItemID, deliveryDate, recordedDate, recordedBy, numberofUnits, relatedType, recordStatus, comments, relatedID INTO :serviceUnitDeliveryID, :plannedItemID, :deliveryDate, :recordedDate, :recordedBy, :numberofUnits, :relatedType, :recordStatus, :comments, :relatedID FROM ServiceUnitDelivery WHERE ServiceUnitDelivery.plannedItemID = :plannedItemID |