Operation Details
Description:  
Sterotype: nsmulti
SQL
SELECT
  VerificationItem.name,
  VerificationItemProvided.receivedFrom,
  VerificationItemProvided.dateReceived,
  VerificationItemUtilization.verificationLevel,
  VerificationItemProvided.verificationItemProvidedID
INTO
  :verificationItemName,
  :receivedFrom,
  :dateReceived,
  :level,
  :verificationItemProvidedID 
FROM
  VerificationItemProvided,
  VerificationItem,
  VerificationItemUtilization 
WHERE VerificationItemProvided.VDIEDLinkID = :vdIEDLinkID 
  AND VerificationItemProvided.recordStatus = :recordStatus 
  AND VerificationItemUtilization.verificationItemUtilizationID = VerificationItemProvided.verificationItemUtilizationID 
  AND VerificationItemUtilization.verificationItemID = VerificationItem.verificationItemID