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;