如何查询EBS模块的版本号

最新推荐文章于 2024-11-27 14:47:48 发布

最新推荐文章于 2024-11-27 14:47:48 发布 · 181 阅读

文章标签：

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'));

REF:

1. How to check if certain Oracle Applications product/module is implemented? [ID 443699.1]

2. https://blogs.oracle.com/stevenChan/entry/products_and_families_and_vers