Query to get Application Patch Applied History

select distinct aap.patch_name,  apr.patch_top,  aat.name,  aap.patch_type,  aap.creation_date,  fav.APPLICATION_NAME,apd.patch_abstract
from ad_patch_runs apr,
     ad_patch_drivers apd,
     ad_applied_patches aap,
     ad_patch_run_bugs aprb,
     ad_appl_tops aat,
     fnd_application_vl fav
where apr.appl_top_id = aat.appl_top_id
  and apr.patch_driver_id = apd.patch_driver_id
  and apr.patch_run_id = aprb.patch_run_id
  and apd.applied_patch_id = aap.applied_patch_id
  and UPPER(aprb.application_short_name) =fav.application_short_name
  and aprb.applied_flag = 'Y'
and aap.creation_date > to_date('01-DEC-2015','DD-MM-YYYY') -- Enter Date
and aat.name='appsnode1' -- Enter application node hostname
order by aap.creation_date;