Oracle EBS - SQL Query to find Cloned Date, Version Details, URL of Oracle Applications

Subject: SQL Query to find Cloned Date, Version Details, URL of Oracle Applications

Query to get Instance 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 back-end

SELECT home_url FROM   icx_parameters;