Query to Find Patches which are loaded in oracle apps instance based on the Application Name level

Hi All,

Based on my friend's request i am adding the updated query with the following requirement. 

This will help you to fetch the details of the patch based on the application level. Thanks my friend for your request.

SELECT   SUBSTR (a.application_name, 1, 60) "Application Name",
         SUBSTR (i.product_version, 1, 4) "Version",
         i.patch_level "Patch Level", i.application_id "Application ID",
         i.last_update_date "Last Update"
    FROM apps.fnd_product_installations i, apps.fnd_application_all_view a
   WHERE i.application_id = a.application_id
   and a.application_name='Payables'  ----- Add the application name here as per your request
ORDER BY a.application_name;

Regards

Prasad