Operation Details
Description: This method retrieves a list of issue details using the related case ID, i.e. the ID of the related case on which the issues were created.
Sterotype: nsmulti
SQL 
SELECT
  CaseHeader.caseReference,
  CaseHeader.concernRoleID,
  IssueDelivery.issueType,
  IssueDelivery.resolutionStatus,
  CaseHeader.statusCode,
  CaseHeader.startDate,
  ConcernRole.concernRoleName,
  IssueDelivery.caseID,
  CaseParticipantRole.caseParticipantRoleID
INTO
  :caseReference,
  :concernRoleID,
  :issueType,
  :resolutionStatus,
  :caseStatus,
  :startDate,
  :concernRoleName,
  :caseID,
  :caseParticipantRoleID 
FROM
  CaseHeader,
  IssueDelivery,
  CaseParticipantRole,
  ConcernRole 
WHERE IssueDelivery.relatedCaseID = :caseID 
  AND CaseHeader.caseID = IssueDelivery.caseID 
  AND CaseParticipantRole.caseID = CaseHeader.caseID 
  AND ConcernRole.concernRoleID = CaseHeader.concernRoleID 
ORDER BY startDate DESC