Database SQL Operation: VerificationItemProvided.searchListDetailsByStatusAndVDIEDLinkID
Description: | |
Sterotype: | nsmulti |
SELECT
VerificationItem.name,
VerificationItemProvided.receivedFrom,
VerificationItemProvided.dateReceived,
VerificationItemUtilization.verificationLevel,
VerificationItemProvided.verificationItemProvidedID
INTO
:verificationItemName,
:receivedFrom,
:dateReceived,
:level,
:verificationItemProvidedID
FROM
VerificationItemProvided,
VerificationItem,
VerificationItemUtilization
WHERE VerificationItemProvided.VDIEDLinkID = :vdIEDLinkID
AND VerificationItemProvided.recordStatus = :recordStatus
AND VerificationItemUtilization.verificationItemUtilizationID = VerificationItemProvided.verificationItemUtilizationID
AND VerificationItemUtilization.verificationItemID = VerificationItem.verificationItemID
|