How to know the Frontnd url from backnd?

From SQL Query:
--------------
For Ex:-

SQL> select home_url from apps.icx_parameters;

HOME_URL
---------------------------------------------
https://testinstance.com

From Command Prompt:
-------------------
For Ex:-

$ env |grep http
FORMS60_MAPPING=https://testinstance.com

or

$ grep FORMS60_MAPPING Test_Instance11.xml
                        <FORMS60_MAPPING oa_var="s_f60map">https://testinstance.com/OA_TEMP</FORMS60_MAPPING>
$

Note: Here https://testinstance.com is the url.