Operation Details
Description:  
Sterotype: nsmulti
SQL 
SELECT
  ProductEvidenceLink.productEvidenceLinkID,
  ProductEvidenceLink.productID,
  ProductEvidenceLink.evidenceMetadataID,
  ProductEvidenceLink.shareableInd,
  ProductEvidenceLink.category,
  ProductEvidenceLink.sortOrder,
  ProductEvidenceLink.quickLinkInd,
  EvidenceMetadata.evidenceType
INTO
  :evidenceTypeLinkID,
  :associatedID,
  :evidenceTypeID,
  :shareableInd,
  :category,
  :sortOrder,
  :quickLinkInd,
  :evidenceTypeCode 
FROM
  ProductEvidenceLink,
  EvidenceMetadata 
WHERE ProductEvidenceLink.productID = :productID 
  AND EvidenceMetadata.evidenceMetadataID = ProductEvidenceLink.evidenceMetadataID 
  AND EvidenceMetadata.recordStatus = :recordStatus