Operation Details
Description: Retrieves a list of case header details by concern role ID and case type.
Sterotype: nsmulti
SQL 
SELECT
  CaseHeader.caseID,
  CaseHeader.planID,
  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.receivedDate,
  CaseHeader.defaultDeliveryMethodType,
  CaseHeader.defaultCurrencyTypeCode,
  CaseHeader.firstReviewDate,
  CaseHeader.versionNo,
  CaseHeader.caseReference
INTO
  :caseID,
  :planID,
  :concernRoleID,
  :ownerOrgObjectLinkID,
  :registrationDate,
  :expectedStartDate,
  :expectedEndDate,
  :startDate,
  :endDate,
  :effectiveDate,
  :statusCode,
  :classificationCode,
  :priorityCode,
  :objectiveCode,
  :appealIndicator,
  :outcomeCode,
  :comments,
  :caseTypeCode,
  :receivedDate,
  :defaultDeliveryMethodType,
  :defaultCurrencyTypeCode,
  :firstReviewDate,
  :versionNo,
  :caseReference 
FROM
  CaseHeader 
WHERE CaseHeader.concernRoleID = :concernRoleID 
  AND CaseHeader.caseTypeCode = :caseTypeCode