AD Applied Patches R12.2

select 
decode(ad_patch.is_patch_applied(&ebs_release &appltop_id &patch_num &lang),'EXPLICIT','APPLIED','NOT_APPLIED','NOT APPLIED')
from dual

select decode(ad_patch.is_patch_applied(&ebs_release &appltop_id &patch_num &lang),'EXPLICIT','APPLIED','NOT_APPLIED','NOT APPLIED') from dual