How to Check Installed Modules In EBS 11i,R12

bash3.2# Source Application Enviroment
bash3.2# sqlplus apps/apps
SQL>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;


Source:Internet