Query to check Modules Licenses

SELECT fat.application_name
      ,fa.application_id
      ,fpi.patch_level
      ,decode(fpi.STATUS,'I','Licensed', 'N','Not Licensed','S','Shared','Undetermined') STATUS
  FROM apps.fnd_product_installations fpi
      ,apps.fnd_application fa
      ,apps.fnd_application_tl fat
 WHERE fpi.application_id = fa.application_id
   AND fat.application_id = fa.application_id --AND fpi.STATUS ='I'
   AND fat.LANGUAGE = 'US';