Operation Details
Description: Reads case details as well as primary client's concern role name and ID and user name and ID of the case owner.
Sterotype: ns
SQL 
SELECT
  CaseHeader.comments,
  CaseHeader.statusCode,
  CaseHeader.caseReference,
  CaseHeader.registrationDate,
  CaseHeader.ownerOrgObjectLinkID,
  CaseHeader.integratedCaseID,
  CaseParticipantRole.caseParticipantRoleID,
  ConcernRole.concernRoleName
INTO
  :comments,
  :statusCode,
  :caseReference,
  :registrationDate,
  :ownerOrgObjectLinkID,
  :integratedCaseID,
  :caseParticipantRoleID,
  :concernRoleName 
FROM
  CaseHeader,
  CaseParticipantRole,
  ConcernRole 
WHERE CaseHeader.caseID = :caseID 
  AND 
  (
    CaseParticipantRole.participantRoleID = CaseHeader.concernRoleID 
    AND CaseParticipantRole.caseID = CaseHeader.caseID 
    AND CaseParticipantRole.typeCode = :typeCode 
  ) 
  AND ConcernRole.concernRoleID = CaseHeader.concernRoleID