Query to get Oracle Apps Cloned Datetime, Version and URL details

--Query to get cloned date_time from prod of an oracle instance
SELECT xx.resetlogs_time clone_date_time
      ,xx.name instance_name
      ,xx.*
  FROM v$database xx;

--Query to get the frontend URL from backend
SELECT xx.home_url
      ,xx.*
  FROM icx_parameters xx;
 
--Query to get Database and Application servers info
SELECT xx.name
      ,xx.server_type
  FROM fnd_app_servers fas
      ,fnd_nodes fn
 WHERE fas.node_id = fn.node_id