Operation Details
Description: Read the details of the relationship between an investigation case and an assessment.
Sterotype: ns
SQL 
SELECT
  InvestigationConfig.type,
  AssessmentConfiguration.name,
  InvCAssessmentConfig.startDate,
  InvCAssessmentConfig.endDate,
  InvCAssessmentConfig.invCAssessmentConfigID,
  InvCAssessmentConfig.investigationConfigID,
  InvCAssessmentConfig.assessmentConfigurationID,
  InvCAssessmentConfig.recordStatus,
  InvCAssessmentConfig.versionNo
INTO
  :investigationCaseConfigurationName,
  :assessmentConfigurationName,
  :startDate,
  :endDate,
  :invCAssessmentConfigID,
  :investigationConfigID,
  :assessmentConfigurationID,
  :recordStatus,
  :versionNo 
FROM
  InvestigationConfig,
  InvCAssessmentConfig,
  AssessmentConfiguration 
WHERE InvCAssessmentConfig.invCAssessmentConfigID = :invCAssessmentConfigID 
  AND InvestigationConfig.investigationConfigID = InvCAssessmentConfig.investigationConfigID 
  AND AssessmentConfiguration.assessmentConfigurationID = InvCAssessmentConfig.assessmentConfigurationID