Operation Details
Description: This method returns all the Product Delivery Cases of a given Product, of a given Client where the case is in a status of Open, Active or Approved.
Sterotype: ns
SQL 
SELECT
  CaseHeader.caseID,
  CaseHeader.planID,
  CaseHeader.integratedCaseID,
  CaseHeader.concernRoleID,
  CaseHeader.ownerOrgObjectLinkID,
  CaseHeader.registrationDate,
  CaseHeader.expectedStartDate,
  CaseHeader.expectedEndDate,
  CaseHeader.startDate,
  CaseHeader.endDate,
  CaseHeader.effectiveDate,
  CaseHeader.statusCode,
  CaseHeader.classificationCode,
  CaseHeader.priorityCode,
  CaseHeader.objectiveCode,
  CaseHeader.appealIndicator,
  CaseHeader.outcomeCode,
  CaseHeader.comments,
  CaseHeader.caseTypeCode,
  CaseHeader.integratedCaseType,
  CaseHeader.receivedDate,
  CaseHeader.defaultDeliveryMethodType,
  CaseHeader.defaultCurrencyTypeCode,
  CaseHeader.firstReviewDate,
  CaseHeader.versionNo
INTO
  :caseID,
  :planID,
  :integratedCaseID,
  :concernRoleID,
  :ownerOrgObjectLinkID,
  :registrationDate,
  :expectedStartDate,
  :expectedEndDate,
  :startDate,
  :endDate,
  :effectiveDate,
  :statusCode,
  :classificationCode,
  :priorityCode,
  :objectiveCode,
  :appealIndicator,
  :outcomeCode,
  :comments,
  :caseTypeCode,
  :integratedCaseType,
  :receivedDate,
  :defaultDeliveryMethodType,
  :defaultCurrencyTypeCode,
  :firstReviewDate,
  :versionNo 
FROM
  CaseHeader,
  ProductDelivery 
WHERE ProductDelivery.productID = :productID 
  AND ProductDelivery.recipConcernRoleID = :recipConcernRoleID 
  AND CaseHeader.caseID = ProductDelivery.caseID 
  AND 
  (
    CaseHeader.statusCode = :caseStatusActive 
    OR CaseHeader.statusCode = :caseStatusOpen 
    OR CaseHeader.statusCode = :caseStatusApproved 
  )