Query to find modules installed in Oracle Apps

select

fav.application_short_name,

fav.application_name,

fpi.patch_level,

decode(fpi.status,'N','None','I','Installed','S','Shared',fpi.status)

from

fnd_application_vl fav,

fnd_product_installations fpi

where

fav.application_id=fpi.application_id 

order by 1,2;