Operation Details
Description: Retrieves the Issue details for the Integrated Case.
Sterotype: nsmulti
SQL 
SELECT
  IssueCaseHeader.caseReference,
  IssueCaseHeader.concernRoleID,
  IssueDelivery.issueType,
  IssueDelivery.resolutionStatus,
  IssueCaseHeader.statusCode,
  IssueCaseHeader.startDate,
  ConcernRole.concernRoleName,
  IssueDelivery.caseID,
  CaseParticipantRole.caseParticipantRoleID,
  RelatedCaseHeader.caseReference
INTO
  :caseReference,
  :concernRoleID,
  :issueType,
  :resolutionStatus,
  :caseStatus,
  :startDate,
  :concernRoleName,
  :caseID,
  :caseParticipantRoleID,
  :relatedCaseReference 
FROM
  CaseHeader IssueCaseHeader,
  CaseHeader RelatedCaseHeader,
  IssueDelivery,
  CaseParticipantRole,
  ConcernRole 
WHERE IssueDelivery.relatedCaseID = :caseID 
  AND ConcernRole.concernRoleID = IssueCaseHeader.concernRoleID 
  AND CaseParticipantRole.caseID = IssueCaseHeader.caseID 
  AND RelatedCaseHeader.caseID = IssueDelivery.relatedCaseID 
  AND IssueCaseHeader.integratedCaseID = RelatedCaseHeader.caseID 
  AND IssueCaseHeader.caseID = IssueDelivery.caseID 
  AND CaseParticipantRole.participantRoleID = RelatedCaseHeader.concernRoleID 
ORDER BY startDate DESC