SQL Queries To Get Oracle Database And Application Information

Following are some of the queries that can be used to get the database and Application information.
SQL Query To Get Product Version Of The Oracle Database And Application:

SELECT product
     , VERSION
     , status
FROM   product_component_version

Or Just run the following query to get the details

select * from v$version;

SQL  Query To Get Oracle Applications Version and Patch Information:

SELECT   SUBSTR (a.application_name, 1, 60) Application_Name
       , SUBSTR (i.product_version, 1, 4) Version
       , i.patch_level 
       , i.application_id 
       , i.last_update_date 
FROM     apps.fnd_product_installations i
       , apps.fnd_application_all_view a
WHERE    i.application_id = a.application_id
ORDER BY a.application_name

SQL Query To Get The Information of Installed Patches  In Oracle Applications:  

AD_APPLIED_PATCHES table stores information about all the patches installed in the system. Use the following query to get the details.

SELECT applied_patch_id
     , patch_name
     , patch_type
     , source_code
     , creation_date
     , last_update_date
FROM   ad_applied_patches

SQL Query To Check Whether the Oracle application is setup for Multi-Org:

SELECT multi_org_flag
FROM   fnd_product_groups;