Operation Details
Description:  
Sterotype: nsmulti
SQL
SELECT 
EVIDENCEDESCRIPTOR.evidenceDescriptorID,
EVIDENCEDESCRIPTOR.caseID,
EVIDENCEDESCRIPTOR.participantID,
EVIDENCEDESCRIPTOR.statusCode,
EVIDENCEDESCRIPTOR.receivedDate,
EVIDENCEDESCRIPTOR.effectiveFrom,
EVIDENCEDESCRIPTOR.correctionSetID,
EVIDENCEDESCRIPTOR.successionID,
EVIDENCEDESCRIPTOR.relatedID,
EVIDENCEDESCRIPTOR.evidenceType,
EVIDENCEDESCRIPTOR.pendingRemovalInd,
EVIDENCEDESCRIPTOR.pendingUpdateInd,
EVIDENCEDESCRIPTOR.newInd,
EVIDENCEDESCRIPTOR.approvalRequestedInd,
EVIDENCEDESCRIPTOR.sharedInstanceID,
EVIDENCEDESCRIPTOR.sharedInd,
EVIDENCEDESCRIPTOR.changeReceivedDate,
EVIDENCEDESCRIPTOR.evidenceActivationDate,
EVIDENCEDESCRIPTOR.sharedUnchangedInd,
EVIDENCEDESCRIPTOR.sourceCaseID,
EVIDENCEDESCRIPTOR.changeReason,
EVIDENCEDESCRIPTOR.externalSourceCaseInd,
EVIDENCEDESCRIPTOR.versionNo

INTO 

:evidenceDescriptorID,
:caseID,
:participantID,
:statusCode,
:receivedDate,
:effectiveFrom,
:correctionSetID,
:successionID,
:relatedID,
:evidenceType,
:pendingRemovalInd,
:pendingUpdateInd,
:newInd,
:approvalRequestedInd,
:sharedInstanceID,
:sharedInd,
:changeReceivedDate,
:evidenceActivationDate,
:sharedUnchangedInd,
:sourceCaseID,
:changeReason,
:externalSourceCaseInd,
:versionNo

FROM EVIDENCEDESCRIPTOR, CURRENTPOSTPONEDVERIFICATION

WHERE 
EVIDENCEDESCRIPTOR.evidenceDescriptorID = CURRENTPOSTPONEDVERIFICATION.evidenceDescriptorID 
AND 
CURRENTPOSTPONEDVERIFICATION.postponedByUser = :postponedByUser