SQL:ServiceUnitDelivery.countActiveServiceUnitDeliveryByPlannedItemID

Database SQL Operation: ServiceUnitDelivery.countActiveServiceUnitDeliveryByPlannedItemID

Operation Details

Description:	Returns the number of units delivered for a planned item
Sterotype:	ns

SQL

SELECT
  SUM(numberOfUnits)
INTO
  :count 
FROM
  ServiceUnitDelivery 
WHERE plannedItemID = :plannedItemID 
  AND recordStatus = :recordStatus