Cloned Date, Version Details, URL of Oracle Applications oracle apps R12

Cloned Date, Version Details, URL of Oracle Applications,Cloned date of oracle application and Version

Query to get Version details..
++++++++++++++++++++++++++++++++++++

SELECT product, VERSION, status
FROM product_component_version;


Query to  get cloned date of an oracle instance
+++++++++++++++++++++++++++++++++++++++++

SELECT resetlogs_time FROM v$database;

========================

Query to get the front end URL from backend
++++++++++++++++++++++++++++++++++
SELECT home_url FROM icx_parameters;