Patch LeveL of Various Application Modules

SELECT i.instance_name
     , i.host_name
     , i.version db_version
     , f.release_name release
     , fa.Application_name
     , DECODE ( fpi.status, 'I', 'INSTALLED'
                          , 'S', 'SHARED'
                          , 'N', 'NOTINSTALLED'
                          , fpi.status
              ) status
     , fpi.patch_level
  FROM v$instance                        i
     , fnd_product_groups                f
     , applsys.fnd_product_installations fpi
     , apps.fnd_application_tl           fa
 WHERE UPPER(SUBSTR(i.instance_name,1,3)) = UPPER(SUBSTR(f.applications_system_name,1,3)) 
   AND fa.application_id                  = fpi.application_id;