Get Oracle Application url from Database in Oracle Apps R12

Find Oracle applications login url by running the below query from the database

SELECT home_url

  FROM icx_parameters;

When we have lot many instances(DEV/TEST/SIT/PROD) then we can use this query to get the application url for corresponding database