Operation Details
Description: Reads all the activity entity details plus the caseReference from the case header
Sterotype: ns
SQL 
SELECT
  Activity.activityID,
  Activity.userName,
  Activity.organisationID,
  Activity.subject,
  Activity.activityTypeCode,
  Activity.startDateTime,
  Activity.endDateTime,
  Activity.allDayInd,
  Activity.locationID,
  Activity.locationName,
  Activity.priorityCode,
  Activity.timeStatusCode,
  Activity.notes,
  Activity.recurrenceID,
  Activity.caseID,
  Activity.concernRoleID,
  Activity.recordStatusCode,
  Activity.versionNo,
  CaseHeader.caseReference
INTO
  :activityID,
  :userName,
  :organisationID,
  :subject,
  :activityTypeCode,
  :startDateTime,
  :endDateTime,
  :allDayInd,
  :locationID,
  :locationName,
  :priorityCode,
  :timeStatusCode,
  :notes,
  :recurrenceID,
  :caseID,
  :concernRoleID,
  :recordStatusCode,
  :versionNo,
  :caseReference 
FROM
  Activity 
  
  LEFT OUTER JOIN
  
  CaseHeader 
  ON CaseHeader.caseID = Activity.caseID 
WHERE Activity.activityID = :activityID