Operation Details
Description: Lists all active service unit deliveries for a given day.
Sterotype: nsmulti
SQL 
SELECT
  serviceUnitDeliveryID,
  numberofUnits,
  deliveryDate,
  recordedBy,
  recordStatus
INTO
  :serviceUnitDeliveryID,
  :numberofUnits,
  :deliveryDate,
  :recordedBy,
  :recordStatus 
FROM
  ServiceUnitDelivery 
WHERE ServiceUnitDelivery.plannedItemID = :plannedItemID 
  AND ServiceUnitDelivery.deliveryDate = :deliveryDate 
  AND ServiceUnitDelivery.recordStatus = :recordStatus