Patches applied

There are two tables that contain information about patches applied to your Oracle E-Business Suite applications:

AD_APPLIED_PATCHES contains the list of patches that were directly applied.
AD_BUGS contains the list of all the patches that were directly applied or were contained in the patches that were directly applied.
For example, if you are trying to find out if a certain pre-requisite patch has been applied, query AD_BUGS. If you are trying to find
out patches applied in a date range, query AD_APPLIED_PATCHES.

SELECT *
FROM ad_bugs
WHERE bug_number = 'patch_number‘;

SELECT *
FROM ad_applied_patches
WHERE patch_name = ‘patch_number‘;
Replace patch_number with the number of the patch you want to check.