Find Oracle Applications login URL

How to find Oracle Applications Login URL from database

Logging into Oracle Applications database from "APPS" user:-
Scripts:-1 SELECT home_url
  FROM icx_parameters;

Scripts:-2

SELECT profile_option_value 

  FROM fnd_profile_option_values 

 WHERE profile_option_id= 

   (SELECT profile_option_id                             

      FROM fnd_profile_options WHERE profile_option_name = 'APPS_FRAMEWORK_AGENT')                              

   AND level_value = 0;

How to check Oracle Application URL in 11i and R12 on UNIX prompt

In Applications 11i:

Sujeet$ cd $APPL_TOP/admin

Sujeet$ pwd

/appl/apps/prodnewappl/admin

Sujeet$ ls -l *.xml



-rw-r--r--   1 appltest dbatest    84223 Oct  2 12:54 PRODTEST_testappl.xml



Sujeet$ cat PREPROD_testappl.xml | grep http | grep login

         login_page oa_var="s_login_page" http://testappl.orasol.com:8040/oa_servlets/AppsLogin/login_page

Sujeet$

Here URL is http://testappl.orasol.com:8040

In Applications R12:

Sujeet$ cd $INST_TOP

Sujeet$ ls

admin             appltmp           conf_ERPTEST.txt  ora               pids              rgf               temp

appl              certs             logs              out               portal            soa

Sujeet$ cd appl

Sujeet$ ls

admin  fnd

Sujeet$ cd admin

Sujeet$ ls -l

total 228

-rwxr-xr-x   1 applmgr  appsdba     90899 Nov  9 12:18 ERPTEST_orasolerp.xml

-rw-r--r--   1 applmgr  appsdba     10392 Nov  9 12:10 adovars_ERPTEST_orasolerp.env

-rw-------   1 applmgr  appsdba      1016 Nov  9 12:10 oamextensions.xml

-rw-------   1 applmgr  appsdba      3340 Nov  9 12:10 ojspCompile.conf

-rw-------   1 applmgr  appsdba      7476 Nov  9 12:10 ojspCompile.properties



Sujeet$ cat ERPTEST_orasolerp.xml | grep http | grep login

         login_page oa_var="s_login_page"http://orasolerp.orasol.com:8010/OA_HTML/AppsLogin/login_page

Sujeet$ pwd

/OrApps/appsR12/inst/apps/ERPTEST_orasolerp/appl/admin

Here URL is http://orasolerp.orasol.com:8010