How to check if a product is implemented or installed and Patch Level in Oracle Applications

How to check if a product is implemented / installed in Oracle Applications

SELECT   fa.application_short_name,

         fat.application_name,

         fpi.patch_level,

         DECODE (fpi.status,

                 'I', 'Installed',

                 'S', 'Shared',

                 'N', 'Inactive',

                 fpi.status)

            Status,

         fpi.db_status

  FROM   fnd_product_installations fpi, 

         fnd_application fa,

         fnd_application_tl fat

 WHERE   fa.application_id = fpi.application_id 

   --AND   fa.application_short_name LIKE '<APPL SHORT NAME>' /* Replace Application Short Name with a product to restrict the query for a specific product. Ex: AR for Receivables */

   AND   fa.application_id = fat.application_id

   AND   fat.language = USERENV ('LANG')

 ORDER BY fa.application_short_name

Details on Status Column from the Query:

Installed - Implemented

Shared - Not fully Implemented

Inactive --> Not fully implemented and not used
L --> Custom 

***Please leave a comment***