Query to check if Patch applied to Patch Edition

We can use the below tables to validate if the patch has been applied to the patch edition.


select ADOP_SESSION_ID,NODE_NAME,APPLTOP_ID,BUG_NUMBER,PATCH_TOP,DRIVER_FILE_NAME 
from AD_ADOP_SESSION_PATCHES 
where
BUG_NUMBER='&patch_number' 
and APPLIED_FILE_SYSTEM_BASE like '%fs%';