查看各模块版本号

SELECT fa.application_short_name
      ,fa.application_name
      ,fpi.patch_level
      ,fpi.product_version
      ,DECODE (fpi.status
              ,'I', 'Installed'
              ,'S', 'Shared'
              ,'N', 'Inactive'
              ,fpi.status
              ) status
      ,fpi.db_status
  FROM fnd_product_installations fpi
      ,fnd_application_vl fa
 WHERE fa.application_id = fpi.application_id
   AND fpi.application_id IN (
                      SELECT application_id
                        FROM fnd_application
                       WHERE application_short_name IN
                                                     ('SQLAP', 'AR', 'SQLGL'));