Operation Details
Description: Lists all the communications related to a concern role, even if the concern role is the concerning participant or, the correspondent for the communication.
Sterotype: nsmulti
SQL 
SELECT
  ConcernRoleCommunication.communicationID,
  ConcernRoleCommunication.concernRoleID,
  ConcernRoleCommunication.typeCode,
  ConcernRoleCommunication.proFormaVersionNo,
  ConcernRoleCommunication.methodTypeCode,
  ConcernRoleCommunication.incomingInd,
  ConcernRoleCommunication.communicationDate,
  ConcernRoleCommunication.statusCode,
  ConcernRoleCommunication.correspondentName,
  ConcernRoleCommunication.correspondentConcernRoleID,
  ConcernRoleCommunication.correspondentTypeCode,
  ConcernRoleCommunication.subjectText,
  ConcernRoleCommunication.documentLocation,
  ConcernRoleCommunication.documentRefNumber,
  ConcernRoleCommunication.fileLocation,
  ConcernRoleCommunication.fileReferenceNumber,
  ConcernRoleCommunication.caseID,
  ConcernRoleCommunication.ticketID,
  ConcernRoleCommunication.userName,
  ConcernRoleCommunication.comments,
  ConcernRoleCommunication.communicationText,
  ConcernRoleCommunication.addressID,
  ConcernRoleCommunication.phoneNumberID,
  ConcernRoleCommunication.emailAddressID,
  ConcernRoleCommunication.proFormaID,
  ConcernRoleCommunication.communicationStatus,
  ConcernRoleCommunication.proFormaInd,
  ConcernRoleCommunication.attachmentInd,
  ConcernRoleCommunication.documentTemplateID,
  ConcernRoleCommunication.communicationFormat,
  ConcernRoleCommunication.localeIdentifier,
  ConcernRoleCommunication.versionNo
INTO
  :communicationID,
  :concernRoleID,
  :typeCode,
  :proFormaVersionNo,
  :methodTypeCode,
  :incomingInd,
  :communicationDate,
  :statusCode,
  :correspondentName,
  :correspondentConcernRoleID,
  :correspondentTypeCode,
  :subjectText,
  :documentLocation,
  :documentRefNumber,
  :fileLocation,
  :fileReferenceNumber,
  :caseID,
  :ticketID,
  :userName,
  :comments,
  :communicationText,
  :addressID,
  :phoneNumberID,
  :emailAddressID,
  :proFormaID,
  :communicationStatus,
  :proFormaInd,
  :attachmentInd,
  :documentTemplateID,
  :communicationFormat,
  :localeIdentifier,
  :versionNo 
FROM
  ConcernRoleCommunication, ConcernRole
WHERE    
(  
  ConcernRoleCommunication.concernRoleID = :concernRoleID
     
    OR
    
   ConcernRoleCommunication.correspondentConcernRoleID = :concernRoleID
 )  

AND 
    ConcernRole.concernRoleID = ConcernRoleCommunication.correspondentConcernRoleID

ORDER BY ConcernRoleCommunication.communicationStatus,   ConcernRoleCommunication.communicationDate DESC