Check Current Applied Patch & Patch level status of all modules in oracle

Check Current Applied Patch

/* Formatted on 11/7/2016 1:00:42 PM (QP5 v5.114.809.3010) */
  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

/* Formatted on 11/7/2016 1:00:31 PM (QP5 v5.114.809.3010) */
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;