Operation Details
Description:  
Sterotype: nsmulti
SQL
SELECT
  VerificationItemUtilization.verificationItemUtilizationID,
  VerificationItemUtilization.verificationItemID,
  VerificationItemUtilization.verifiableDataItemID,
  VerificationItemUtilization.verificationLevel,
  VerificationItemUtilization.fromDate,
  VerificationItemUtilization.toDate,
  VerificationItem.name
INTO
  :verificationItemUtilizationID,
  :verificationItemID,
  :verifiableDataItemID,
  :verificationLevel,
  :fromDate,
  :toDate,
  :name 
FROM
  VerificationItemUtilization,
  VerificationItem 
WHERE VerificationItemUtilization.verifiableDataItemID = :verifiableDataItemID 
  AND VerificationItemUtilization.recordStatus <> :recordStatus 
   AND ( VerificationItemUtilization.verificationGroupID  IS NULL)