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

— Oracle Database version along with hostname and instance name

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

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;