Database SQL Operation: VerificationItemUtilization.searchAllActiveVerificationItemsAndLevelByDate
Description: | |
Sterotype: | nsmulti |
SELECT
vi.name,
vu.verificationLevel,
vu.verificationItemUtilizationID
INTO
:name,
:level,
:verificationItemUtilizationID
FROM
VerificationItemUtilization vu,
VerificationItem vi
WHERE vu.verificationItemID = vi.verificationItemID
AND vu.recordStatus <> :recordStatus
AND vu.verifiableDataItemID = :verifiableDataItemID
AND vu.fromDate <= :date
AND
(
vu.toDate IS NULL
OR vu.toDate >= :date
)
|