1.
SQL> SELECT home_url FROM icx_parameters; HOME_URL -------------------------------------------------------------------------------- http://test.example.com:8000/OA_HTML/AppsLogin
2.
SQL> SELECT profile_option_value 2 FROM fnd_profile_option_values 3 WHERE profile_option_id = 4 (SELECT profile_option_id 5 FROM fnd_profile_options 6 WHERE profile_option_name = 'APPS_FRAMEWORK_AGENT') 7 AND level_value = 0; PROFILE_OPTION_VALUE -------------------------------------------------------------------------------- http://test.example.com:8000