Operation Details
Description: Read the change history for the resolutions on the given investigation delivery.
Sterotype: nsmulti
SQL 
SELECT
  DISTINCT ResolutionStatusHistory.resolutionStatusHistoryID,
  ResolutionStatusHistory.resolutionID,
  ResolutionStatusHistory.resolutionStatus,
  ResolutionStatusHistory.effectiveDate,
  ResolutionConfiguration.resolution
INTO
  :resolutionStatusHistoryID,
  :resolutionID,
  :resolutionStatus,
  :effectiveDate,
  :resolution 
FROM
  Resolution,
  ResolutionConfiguration,
  ResolutionStatusHistory 
WHERE Resolution.caseID = :caseID 
  AND ResolutionStatusHistory.resolutionID = Resolution.resolutionID 
  AND ResolutionConfiguration.resolutionConfigurationID = ResolutionStatusHistory.resolutionConfigurationID 
ORDER BY effectiveDate ASC