SQL Query to find application release,application module patch level, database version etc

How to find Oracle Application version/name and their module details?

FND_PRODUCT_INSTALLATIONS

This fnd_product_installations table stores information about Oracle Applications products at your site.

Each row includes-
A value identifying the application (APPLICATION_ID)
A value identifying the database account (ORACLE_ID)
The product's version number (PRODUCT_VERSION)
The product's status at your site (STATUS, where I means installed, L means custom, N means not installed, and S means installed as shared product)
The product's industry (INDUSTRY, where C means for commercial or for-profit use, G means for educational or not-for-profit use, B means Project Billing, and P means Project Costing)
And some other columns like patch level of each application and tablespace etc

Oracle Applications uses this information to display product version numbers when you choose \ Help Version, when installing and upgrading your database, and for other purposes.

select * from apps.fnd_product_installations  ;

--realated module specific and its patch level details,application module version etc.

FND_PRODUCT_GROUPS
 

FND_PRODUCT_GROUPS stores information about what release, language and type of product group (for example, Standard or Demonstration),application system name etc.

select * from apps.fnd_product_groups   ;

-- Oracle Application Version details(like 11.5.10 or 12.0.1)e.g.release name,application short name,application system name(fdev1,fsit1 like tht)

 

v$version

By running this query, you will able to derive which database enterprise edition, their platform and 32/64 bit etc details.

select * from v$version;

-- database version details(its 10g or 11g,platform,os details etc)