Query for Appliation Products Installed

col application_short_name format a23
col APPLICATION_NAME format a27
col PATCH_LEVEL format a15
select fav.application_short_name
,fav.application_name
,fpi.patch_level
,decode(fpi.status,'N','None','I','Installed','S','Shared')
from fnd_product_installations fpi
,fnd_application_vl fav
where fav.application_id=fpi.application_id
order by 1;