/* 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;