List of Installed Modules in your Company

SELECT a.application_name,a.product_code,
DECODE (b.status, 'I', 'Installed', 'S', 'Shared', 'N/A') status, 
patch_level 
FROM apps.fnd_application_vl a, 
apps.fnd_product_installations b 
WHERE a.application_id = b.application_id
and b.status='I'
order by product_code asc;