Check Current Applied Patch

SELECT patch_name, patch_type,

maint_pack_level,

creation_date

FROM applsys.ad_applied_patches

ORDER BY creation_date DESC

Query used to view the patch level status of all modules

SELECT a.application_name,

DECODE (b.status, ‘I’, ‘Installed’, ‘S’, ‘Shared’, ‘N/A’) status,

patch_level

FROM apps.fnd_application_vl a,

apps.fnd_product_installations b

WHERE a.application_id = b.application_id;