Operation Details
Description: Searches active product deliveries for integrated case.
Sterotype: nsmulti
SQL 
SELECT
  ProductDelivery.caseID,
  ProductDelivery.productID,
  ProductDelivery.productType
INTO
  :caseID,
  :productID,
  :productType 
FROM
  CaseHeader,
  ProductDelivery 
WHERE CaseHeader.integratedCaseID = :integratedCaseID 
  AND CaseHeader.statusCode <> :statusCode 
  AND ProductDelivery.caseID = CaseHeader.caseID 
ORDER BY ProductDelivery.caseID