How to find Oracle Application version/name and their module details?
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.
FND_PRODUCT_GROUPS stores information about what release, language and type of product group (for example, Standard or Demonstration),application system name etc.
By running this query, you will able to derive which database enterprise edition, their platform and 32/64 bit etc details.