using Query / as Apps User :
DECODE (b.status, ‘I’, ‘Installed’, ‘S’, ‘Shared’, ‘N/A’) status,
patch_levelFROM apps.fnd_application_vl a,
WHERE a.application_id = b.application_id
and b.status=’I’ order by product_code asc;
Using adutconf.sql scripts which is located in $AD_TOP
This script include information about Product installation status, version and other information.
Using Oracle Application Manager ( OAM )
Site Map —> License Manager Which licensed word means installed.