Operation Details |
Description: | Searches for all active item utilization names. |
Sterotype: | nsmulti |
SQL |
SELECT vu.verificationItemUtilizationID, vi.name INTO :verificationItemUtilizationID, :name FROM VerificationItemUtilization vu, VerificationItem vi WHERE vu.verifiableDataItemID = :verifiableDataItemID AND vu.recordStatus <> :recordStatus AND vu.verificationItemID = vi.verificationItemID AND ( vu.verificationGroupID IS NULL) |