SQL script to find the patches applied with patch name on ERP R12.2

 use the following SQL to get the patch name applied since certain date 

SQL query:

SELECT DISTINCT e.patch_name, to_char(c.end_date, 'DD-MON-RRRR HH24:MI:SS') End_date, e.patch_type, d.patch_abstract

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 e.creation_date > to_date ('01-JAN-23')

order by 1,3 ASC;

sample output:

PATCH_NAME END_DATE             PATCH_TYPE                     PATCH_ABSTRACT

---------- -------------------- ------------------------------ --------------------

13839836   23-APR-2024 09:26:50 ONE-OFF

34766982   22-JAN-2024 10:59:05 ONE-OFF                        ISG Consolidated Patch for 12.2 (23_1_1)