Operation Details
Description: Method to read the Ownership Details.
Sterotype: ns
SQL 
SELECT
  OWNERSHIP.EVIDENCEID,
  OWNERSHIP.CASEPARTICIPANTROLEID,
  OWNERSHIP.VERSIONNO,
  OWNERSHIP.PERCENTAGEOWNED,
  OWNERSHIP.STARTDATE,
  OWNERSHIP.ENDDATE,
  OWNERSHIP.COMMENTS,
  OWNERSHIP.WILLINGTOSELLIND,
  OWNERSHIP.OWNERSHIPTYPE,
  OWNERSHIP.USAGE,
  concernRoleName,
  PRIMARYALTERNATEID
INTO
  :evidenceID,
  :caseParticipantRoleID,
  :versionNo,
  :percentageOwned,
  :startDate,
  :endDate,
  :comments,
  :willingToSellInd,
  :ownershipType,
  :usage,
  :caseParticipantName,
  :alternateID 
FROM
  OWNERSHIP,
  CaseParticipantrole,
  ConcernRole 
WHERE OWNERSHIP.EVIDENCEID = :evidenceID 
  AND CaseParticipantrole.caseParticipantRoleID = OWNERSHIP.CASEPARTICIPANTROLEID 
  AND ConcernRole.concernRoleID = CaseParticipantrole.participantRoleID