Operation Details
Description: Searches for the number of cases of a specified status for a specified category.
Sterotype: ns
SQL 
SELECT
  COUNT (*)
INTO
  :numberOfRecords 
FROM
  CaseHeader,
  ProductDelivery 
WHERE 
  (
    CaseHeader.statusCode <> :statusCode 
    AND CaseHeader.statusCode <> :statusCode2 
  ) 
  AND CaseHeader.concernRoleID = :concernRoleID 
  AND ProductDelivery.caseID = CaseHeader.caseID 
  AND ProductDelivery.categoryCode = :categoryCode