Operation Details
Description: Returns the duplicate details for the specified concern role duplicate.
Sterotype: ns
SQL 
SELECT
  ConcernRoleDuplicate.originalConcernRoleID,
  ConcernRoleDuplicate.duplicateConcernRoleID,
  ConcernRoleDuplicate.duplicateDate,
  ConcernRoleDuplicate.duplicateReason,
  ConcernRoleDuplicate.duplicateUser,
  ConcernRoleDuplicate.duplicateComments,
  ConcernRoleDuplicate.unmarkDate,
  ConcernRoleDuplicate.unmarkReason,
  ConcernRoleDuplicate.unmarkUser,
  ConcernRoleDuplicate.unmarkComments,
  OrigConcernRole.concernRoleName,
  DupConcernRole.concernRoleName,
  ConcernRoleMerge.mergeStatus,
  ConcernRoleMerge.mergeStartDate,
  ConcernRoleMerge.mergeEndDate,
  ConcernRoleMerge.mergeStartedBy,
  ConcernRoleMerge.mergeCompletedBy,
  DupUsers.fullName,
  MergeStartedUsers.fullName,
  MergeCompletedUsers.fullName,
  UnmarkUsers.fullName
INTO
  :originalConcernRoleID,
  :duplicateConcernRoleID,
  :duplicateDate,
  :duplicateReason,
  :duplicateUser,
  :duplicateComments,
  :unmarkDate,
  :unmarkReason,
  :unmarkUser,
  :unmarkComments,
  :originalConcernRoleName,
  :duplicateConcernRoleName,
  :mergeStatus,
  :mergeStartDate,
  :mergeEndDate,
  :mergeStartedBy,
  :mergeCompletedBy,
  :duplicateUserFullName,
  :mergeStartedUserFullName,
  :mergeCompletedUserFullName,
  :unmarkUserFullName 
FROM
  
  ( 
  SELECT
    ConcernRoleDuplicate.originalConcernRoleID,
    ConcernRoleDuplicate.duplicateConcernRoleID,
    ConcernRoleDuplicate.duplicateDate,
    ConcernRoleDuplicate.duplicateReason,
    ConcernRoleDuplicate.duplicateUser,
    ConcernRoleDuplicate.duplicateComments,
    ConcernRoleDuplicate.unmarkDate,
    ConcernRoleDuplicate.unmarkReason,
    ConcernRoleDuplicate.unmarkUser,
    ConcernRoleDuplicate.unmarkComments 
  FROM
    ConcernRoleDuplicate 
  WHERE ConcernRoleDuplicate.concernRoleDuplicateID = :concernRoleDuplicateID 
  ) ConcernRoleDuplicate 
  
  LEFT 
  
  JOIN
  
  ConcernRoleMerge 
  ON ConcernRoleMerge.concernRoleDuplicateID = :concernRoleDuplicateID 
  
  LEFT 
  
  JOIN
  
  ConcernRole OrigConcernRole 
  ON OrigConcernRole.concernRoleID = ConcernRoleDuplicate.originalConcernRoleID 
  
  LEFT 
  
  JOIN
  
  ConcernRole DupConcernRole 
  ON DupConcernRole.concernRoleID = ConcernRoleDuplicate.duplicateConcernRoleID 
  
  LEFT 
  
  JOIN
  
  Users DupUsers 
  ON DupUsers.userName = ConcernRoleDuplicate.duplicateUser 
  
  LEFT 
  
  JOIN
  
  Users MergeStartedUsers 
  ON MergeStartedUsers.userName = ConcernRoleMerge.mergeStartedBy 
  
  LEFT 
  
  JOIN
  
  Users MergeCompletedUsers 
  ON MergeCompletedUsers.userName = ConcernRoleMerge.mergeCompletedBy 
  
  LEFT 
  
  JOIN
  
  Users UnmarkUsers 
  ON UnmarkUsers.userName = ConcernRoleDuplicate.unmarkUser 
GROUP
  BY ConcernRoleDuplicate.originalConcernRoleID,
  ConcernRoleDuplicate.duplicateConcernRoleID,
  ConcernRoleDuplicate.duplicateDate,
  ConcernRoleDuplicate.duplicateReason,
  ConcernRoleDuplicate.duplicateUser,
  ConcernRoleDuplicate.duplicateComments,
  ConcernRoleDuplicate.unmarkDate,
  ConcernRoleDuplicate.unmarkReason,
  ConcernRoleDuplicate.unmarkUser,
  ConcernRoleDuplicate.unmarkComments,
  OrigConcernRole.concernRoleName,
  DupConcernRole.concernRoleName,
  ConcernRoleMerge.mergeStatus,
  ConcernRoleMerge.mergeStartDate,
  ConcernRoleMerge.mergeEndDate,
  ConcernRoleMerge.mergeStartedBy,
  ConcernRoleMerge.mergeCompletedBy,
  DupUsers.fullName,
  MergeStartedUsers.fullName,
  MergeCompletedUsers.fullName,
  UnmarkUsers.fullName