Finding Host_Name and Host_Address and Profile Option Using Query

select utl_inaddr.get_host_name FROM dual;

select utl_inaddr.get_host_address FROM dual;

select * from icx_parameters

 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