Some Useful Queries to know Information about your Oracle Instance

Query to find Oracle Apps Login URL

SELECT home_url FROM icx_parameters;

Query to find Oracle Apps Instance Version

SELECT release_name FROM fnd_product_groups;

Query to find Oracle Apps Instance Name

SELECT instance_name FROM v$instance;

Query to find Oracle Apps Instance is set up for MultiOrg

SELECT multi_org_flag FROM fnd_product_groups;

Query to find Oracle Apps Database Version

SELECT version FROM v$instance;

Query to find host name of Oracle Apps Instance

SELECT host_name FROM v$instance;

Query to find your Oracle Apps Instance Name

SELECT instance_name FROM v$instance;

Query to find list of Products and their version installed on your Oracle Apps Instance

SELECT * FROM product_component_version;

Query to find size of database

SELECT SUM(bytes)/1024/1024 mb FROM dba_extents;

Query to find workflow version

SELECT wf_core.translate('WF_VERSION') FROM dual;
[OR]
SELECT text FROM WF_RESOURCES WHERE name= 'WF_VERSION';

Query to find Application Patch Level

SELECT patch_level
 FROM fnd_product_installations
WHERE patch_level LIKE '%&Your_Application_Short_Name%';

Query to find Database Version and PL/SQL version

SELECT *
 FROM v$version;