Search This Blog

Sunday, May 12, 2013

Query to find Installed Applications in Oracle


Query to find Installed Applications in Oracle

SELECT   fatl.application_name,
         SUBSTR (fa.application_short_name, 1, 8) product,
         SUBSTR (fpi.product_version, 1, 14) VERSION,
         SUBSTR (fpi.patch_level, 1, 11) patch_level, fpi.status,
         flv.meaning status_meaning
    FROM fnd_application fa,
         fnd_product_installations fpi,
         fnd_application_tl fatl,
         fnd_lookup_values flv
   WHERE fa.application_id = fpi.application_id
     AND fatl.application_id = fa.application_id
     AND UPPER (flv.lookup_type) = 'APP_INSTALL_STATUS'
     AND fpi.status = flv.lookup_code
     AND flv.LANGUAGE = 'US'
     AND flv.lookup_type = 'APP_INSTALL_STATUS'
     AND fatl.LANGUAGE = 'US'
ORDER BY fa.application_short_name