Operation Details
Description: Reads Investigation type and active resolution details.
Sterotype: ns
SQL 
SELECT
  InvestigationDelivery.investigationType,
  Resolution.resolution
INTO
  :investigationType,
  :resolution
FROM
  InvestigationDelivery 
  LEFT OUTER JOIN
  (SELECT
    ResolutionConfiguration.resolution,
    Resolution.caseID
  FROM
    InvestigationDelivery,
    Resolution,
    ResolutionConfiguration
  WHERE InvestigationDelivery.resolutionStatus = :resolutionStatus
    AND InvestigationDelivery.caseID = Resolution.caseID
    AND Resolution.resolutionConfigurationID = ResolutionConfiguration.resolutionConfigurationID
    AND Resolution.recordStatus = :recordStatus) Resolution ON Resolution.caseID = InvestigationDelivery.caseID   
WHERE InvestigationDelivery.caseID = :caseID