Check Whether a Patch is applied or not

 select *
from ad_bugs ab
where ab.bug_number = '&PatchNumber';

or

select bug_number from ad_bugs where bug_number='&PatchNumber';