Operation Details
Description: To find all Resolution Status History records associated with the specified Resolution
Sterotype: nsmulti
SQL 
SELECT
  ResolutionStatusHistory.resolutionStatusHistoryID,
  ResolutionStatusHistory.resolutionID,
  ResolutionStatusHistory.resolutionStatus,
  ResolutionStatusHistory.effectiveDate,
  ResolutionConfiguration.resolution
INTO
  :resolutionStatusHistoryID,
  :resolutionID,
  :resolutionStatus,
  :effectiveDate,
  :resolution 
FROM
  ResolutionConfiguration,
  Resolution,
  ResolutionStatusHistory 
WHERE ResolutionStatusHistory.resolutionID = :resolutionID 
  AND Resolution.resolutionID = ResolutionStatusHistory.resolutionID 
  AND ResolutionStatusHistory.resolutionConfigurationID = ResolutionConfiguration.resolutionConfigurationID 
ORDER BY effectiveDate ASC