Patch

SELECT bug_number, creation_date FROM ad_bugs WHERE bug_number IN ('', '', '', '') ORDER BY creation_date DESC; 

 SELECT a.bug_number, e.patch_name, TRUNC(c.end_date) AS end_date, b.applied_flag FROM ad_bugs a, ad_patch_run_bugs b, ad_patch_runs c, ad_patch_drivers d, 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 a.bug_number IN ('', '', '', '') ORDER BY c.end_date DESC;