Operation Details
Description: Operation to search for current cases for a specified concern role.
Sterotype: nsmulti
SQL 
SELECT
  CaseHeader.caseID,
  ProductProvider.name,
  CaseHeader.startDate,
  CaseHeader.endDate,
  CaseHeader.statusCode,
  ProductDelivery.productProviderID,
  Product.name
INTO
  :caseID,
  :productProviderName,
  :caseStartDate,
  :caseEndDate,
  :caseStatus,
  :providerID,
  :productName 
FROM
  CaseHeader,
  ProductProvider,
  ProductDelivery,
  Product 
WHERE CaseHeader.concernRoleID = :clientID 
  AND ProductDelivery.caseID = CaseHeader.caseID 
  AND ProductProvider.concernRoleID = ProductDelivery.productProviderID 
  AND Product.productID = ProductDelivery.productID