Get Version number for Oracle apps, Database, Workflow, XML, OS

How to find front end url through backend

--------------------------------------------------

select * from icx_parameters;  ---- URL

select * from fnd_product_groups; --- find the release_name of version R12 EBIZ

select * from V$version;  --- find out the database Version 

Oracle Database version along with hostname and instance name

1 2 3 4 5 6

SELECT instance_name, host_name, version, status, database_status FROM v$instance;

— Database version along with operating system platform

1	SELECT name, DB_UNIQUE_NAME, platform_name FROM v$database;

— Oracle Apps version

1 2 3 4

SELECT release_name, applications_system_name, aru_release_name FROM FND_PRODUCT_GROUPS;

— Database Version, PLSQL Version, TNS Version

1	SELECT * FROM v$version;

— Oracle workflow version

1	SELECT text ,name FROM wf_resources WHERE name LIKE ‘%WF_VERSION%’;

— Oracle XML Publisher / BI Publisher Version

1	SELECT WF_EVENT_XML.XMLVersion() XML_BI_VERSION FROM dual;