Oracle Applications Product Status

----------------------------------
-Product Status of Oracle Applications
-File Name: product_status.sql
-Usage: @product_status
-----------------------------------

col APPLICATION_SHORT_NAME for a10
col APPLICATION_NAME for a60
set line 200
select fav.application_short_name
,fav.application_name
,fpi.patch_level
,decode(fpi.status,'N','None','I','Installed','S','Shared') "Status"
from apps.fnd_product_installations fpi
,apps.fnd_application_vl fav
where fav.application_id=fpi.application_id
order by 1
/