Operation Details
Description:  
Sterotype: nsmulti
SQL 
SELECT
  ProductEvidenceLink.shareableInd,
  ProductEvidenceLink.category,
  ProductEvidenceLink.sortOrder,
  ProductEvidenceLink.quickLinkInd,
  EvidenceMetadata.participantDataInd,
  EvidenceMetadata.evidenceType
INTO
  :shareableInd,
  :category,
  :sortOrder,
  :quickLinkInd,
  :participantDataInd,
  :evidenceType 
FROM
  ProductEvidenceLink,
  EvidenceMetadata 
WHERE ProductEvidenceLink.productID = :productID 
  AND EvidenceMetadata.evidenceMetadataID = ProductEvidenceLink.evidenceMetadataID 
  AND EvidenceMetadata.recordStatus = :recordStatus
  AND ProductEvidenceLink.dataLinkedToProductInd = '1'