List applied patche details in Oracle apps

select patch_drivers.orig_patch_name "Patch Name",
patch_runs.start_date "Patch Applied Date",
patch_runs.patch_top "Patch Top",
patch_drivers.driver_file_name "Driver File Name",
patch_drivers.patch_abstract "Patch Details",
patch_bugs.no_of_bugs "Bugs"
from applsys.ad_patch_runs patch_runs,
(select patch_run_id, count(patch_run_id) no_of_bugs
from applsys.ad_patch_run_bugs
group by patch_run_id) patch_bugs,
applsys.ad_patch_drivers patch_drivers
where patch_runs.patch_run_id = patch_bugs.patch_run_id and
patch_drivers.patch_driver_id = patch_runs.patch_driver_id /*and
patch_runs.start_date > (select created from v$database) - 1*/
order by patch_runs.start_date desc

Script to find Roll out patch in Oracle Apps

set heading off
set feedback off
set line 132
set trimspool on
prompt
prompt ATG Patches
select decode(bug_number,
'6077487','R12.TXK.A.DELTA.3',
'6141000','12.0.3- RUP3',
'6077669','R12.ATG_PF.A.Delta.3',
'5484000’,’12.0.2 RUP2’,
'6510214',' R12.AD.A.DELTA.4',
'5484000','Oracle E-Business Suite 12.0.2 Release Update Pack (RUP2)',
'6145693','R12 RAPIDCLONE CONSOLIDATED FIXES JAN/2008',
‘6776948’,’R12 RAPIDCLONE CONSOLIDATED FIXES JUL/2008’,
'7237006', 'R12.ATG_PF.A.delta.6' ,
'Other / error'
) ||
' is installed'
from apps.ad_bugs where
bug_number in ('6077487','6141000','6077669'.’5484000’,'6510214','5484000','6145693',’67769
48’, '7237006')
/