EBS已安装模块

/* Formatted on 2018/3/15 11:14:51 (QP5 v5.256.13226.35538) */

  SELECT fa.application_short_name

       , fpi.product_version

       , fpi.status

       , fpi.patch_level

    FROM fnd_product_installations fpi, fnd_application fa

   WHERE fpi.status IN ('I', 'S')

     AND fa.application_id = fpi.application_id

ORDER BY fa.application_short_name;