Operation Details
Description: Method for reading resource transfer evidence and the participantRoleID of the recipient of the resource transfer.
Sterotype: ns
SQL 
SELECT
  RESOURCETRANSFER.EVIDENCEID,
  RESOURCETRANSFER.CASEPARTICIPANTROLEID,
  RESOURCETRANSFER.RECIPIENTCASEPARTICIPANTROLEID,
  CaseParticipantRole.PARTICIPANTROLEID,
  RESOURCETRANSFER.TRANSFERDATE,
  RESOURCETRANSFER.TRANSFERREASON,
  RESOURCETRANSFER.ITEMTYPE,
  RESOURCETRANSFER.FAIRMARKETVALUE,
  RESOURCETRANSFER.UNCOMPENSATEDVALUE,
  RESOURCETRANSFER.AMOUNTRECEIVED,
  RESOURCETRANSFER.VERSIONNO,
  RESOURCETRANSFER.COMMENTS,
  RESOURCETRANSFER.RESOURCETYPE,
  RESOURCETRANSFER.ENDDATE,
  RESOURCETRANSFER.ACTINGONBEHALFIND,
  RESOURCETRANSFER.ATTEMPTEDTOREGAINPOSSESSIONIND,
  RESOURCETRANSFER.LEGALBINDDOCINPLACEIND
INTO
  :evidenceID,
  :caseParticipantRoleID,
  :recipientCaseParticipantRoleID,
  :recipientParticipantRoleID,
  :transferDate,
  :transferReason,
  :itemType,
  :fairMarketValue,
  :uncompensatedValue,
  :amountReceived,
  :versionNo,
  :comments,
  :resourceType,
  :endDate,
  :actingOnBehalfInd,
  :attemptedToRegainPossessionInd,
  :legalBindDocInPlaceInd 
FROM
  RESOURCETRANSFER,
  CaseParticipantRole 
WHERE RESOURCETRANSFER.EVIDENCEID = :evidenceID 
  AND CaseParticipantRole.CASEPARTICIPANTROLEID = RESOURCETRANSFER.CASEPARTICIPANTROLEID