I could not find a simple query to use.
You can build your own query by getting the CPU patch numbers from each of the CPU documents.
For example, based on Doc ID 2051000.1 for EBS 12.2:
select decode(bug_number, '21507429', 'ORACLE APPLICATIONS RELEASE 12.2: CPU PATCH FOR OCT 2015') CPU_Level
where bug_number in ('21507429');
Here is a link to all CPU patches:
Apart from these all other techstack patches you need to check individually. you can write some shell script to check if all patches are appiied or not
I finally found looking for each PSU patch definitinon on the Security Alerts webpage, using the info in ad_bugs and ad_patches_applied, i found out last CPU applied was for the Apr 2012 release.
Thanks for the help!
You are welcome!
Please close the discussion by marking correct/helpful answers to help others find the answers quickly.