Database SQL Operation: VerificationItemUtilization.searchAllVerificationGroupItemsForCurrentDate
Description: | Searches for all the verification item names which are applicable for the current date |
Sterotype: | nsmulti |
SELECT
vu.verificationItemUtilizationID,
vi.name
INTO
:verificationItemUtilizationID,
:name
FROM
VerificationItemUtilization vu,
VerificationItem vi
WHERE vu.verifiableDataItemID = :verifiableDataItemID
AND vu.verificationItemID = vi.verificationItemID
AND vu.fromDate <= :currentDate
AND
(
vu.toDate IS NULL
OR vu.toDate >= :currentDate
)
AND ( vu.verificationGroupID IS NOT NULL)
|