Operation Details
Description: Retrieves the duplicate details for the concern role where the status is not equal to the status entered.
Sterotype: nsmulti
SQL 
SELECT
  ConcernRoleDuplicate.concernRoleDuplicateID,
  ConcernRoleDuplicate.duplicateConcernRoleID,
  ConcernRole.concernRoleName,
  ConcernRoleDuplicate.duplicateDate,
  ConcernRoleMerge.mergeStartDate,
  ConcernRoleMerge.mergeEndDate,
  ConcernRoleDuplicate.unmarkDate,
  ConcernRoleDuplicate.statusCode
INTO
  :concernRoleDuplicateID,
  :duplicateConcernRoleID,
  :concernRoleName,
  :duplicateDate,
  :mergeStartDate,
  :mergeEndDate,
  :unmarkDate,
  :statusCode 
FROM
  
  ( 
  SELECT
    ConcernRoleDuplicate.concernRoleDuplicateID,
    ConcernRoleDuplicate.duplicateConcernRoleID,
    ConcernRoleDuplicate.duplicateDate,
    ConcernRoleDuplicate.unmarkDate,
    ConcernRoleDuplicate.statusCode 
  FROM
    ConcernRoleDuplicate 
  WHERE ConcernRoleDuplicate.originalConcernRoleID = :concernRoleID 
    AND ConcernRoleDuplicate.statusCode <> :statusCode 
  ) ConcernRoleDuplicate 
  
  LEFT 
  
  JOIN
  
  ConcernRoleMerge 
  ON ConcernRoleMerge.concernRoleDuplicateID = ConcernRoleDuplicate.concernRoleDuplicateID INNER JOIN
  
  ConcernRole 
  ON ConcernRole.concernRoleID = ConcernRoleDuplicate.duplicateConcernRoleID 
GROUP
  BY ConcernRoleDuplicate.concernRoleDuplicateID,
  ConcernRoleDuplicate.duplicateConcernRoleID,
  ConcernRole.concernRoleName,
  ConcernRoleDuplicate.duplicateDate,
  ConcernRoleMerge.mergeStartDate,
  ConcernRoleMerge.mergeEndDate,
  ConcernRoleDuplicate.unmarkDate,
  ConcernRoleDuplicate.statusCode 
ORDER BY duplicateDate DESC