SQL to get application url dynamically

Summary

SQL to get application url dynamically

Content

Hi,

Please can some one advise how to get application URL of a fusion instance using SQL? Similar to EBS, where we can get the url using below SQLs.

1. SELECT home_url FROM icx_parameters;

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 ;

 

Thanks