Query to get Patch Details in Oracle Apps

 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 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-JAN-21';

ORDER BY 1 DESC;