Database SQL Operation: VerificationItemUtilization.searchVerificationItemUtilizationListDetailsAndVersionNo
Description: | Lists all Verification Utilization Items |
Sterotype: | nsmulti |
SELECT
vu.verificationItemUtilizationID,
vu.recordStatus,
vu.versionNo,
vu.verificationItemID,
vi.name
INTO
:verificationItemUtilizationID,
:recordStatus,
:versionNo,
:verificationItemID,
:name
FROM
VerificationItemUtilization vu,
VerificationItem vi
WHERE vu.verifiableDataItemID = :verifiableDataItemID
AND vu.verificationItemID = vi.verificationItemID
AND ( vu.verificationGroupID IS NULL)
|