Query To Get Applied Patch Details In Oracle APPS

SELECT af.filename ,
       afv.version,
       af.subdir,
       aap.patch_name,
       aap.creation_date
FROM apps.ad_applied_patches aap,
     apps.ad_patch_drivers apd,
     apps.ad_patch_runs apr,
     apps.ad_patch_run_bugs aprb,
     apps.ad_patch_run_bug_actions aprba,
     apps.ad_file_versions afv ,
     apps.ad_files af
WHERE aap.applied_patch_id=apd.applied_patch_id
  AND apd.patch_driver_id = apr.patch_driver_id
  AND apr.patch_run_id=aprb.patch_run_id
  AND aprb.patch_run_bug_id=aprba.patch_run_bug_id
  AND NVL(aprba.patch_file_version_id,aprba.onsite_file_version_id)=afv.file_version_id
  AND afv.file_id = af.file_id
  AND aap.patch_name LIKE '%Patch_Name%' ;