Query to get Patch Details

SELECT DISTINCT

  RPAD(a.bug_number,11)

  || RPAD(e.patch_name,11)

  || RPAD(TRUNC(c.end_date),12)

  || RPAD(b.applied_flag, 4)  BUG_APPLIED

FROM

  apps.ad_bugs a,

  apps.ad_patch_run_bugs b,

  apps.ad_patch_runs c,

  apps.ad_patch_drivers d ,

  apps.ad_applied_patches e

WHERE 1=1

AND a.bug_id = b.bug_id

AND b.patch_run_id = c.patch_run_id

AND c.patch_driver_id = d.patch_driver_id

AND d.applied_patch_id = e.applied_patch_id

AND C.END_DATE > '01-SEP-16';

ORDER BY 1 DESC;