Patch Applied or not check

----------------------------------
-Patch is applied or not?
-File Name: patch.sql
-Usage: @patch
-----------------------------------

alter session set nls_date_format='dd-Mon-RR hh24:mi:ss';
Prompt 'Entere Patch/Bug Number:'
Accept PATCHNUM
set line 200
col PATCH_NAME for a30
select PATCH_NAME,PATCH_TYPE,CREATION_DATE from apps.ad_applied_patches where PATCH_NAME like '%&PATCHNUM%'
/

Prompt 'AD_BUG history:'

set line 200
col BUG_NUMBER for a20
col APPLICATION_SHORT_NAME for a20
select BUG_NUMBER,APPLICATION_SHORT_NAME,CREATION_DATE,GENERIC_PATCH from apps.ad_bugs where BUG_NUMBER in('&PATCHNUM')
/