SQL Query to get EBS URL and EBS Version

Use the below SQL Query to get EBS URL and EBS Version

 

--Get EBS URL
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;



--Get EBS Version
SELECT applications_system_name,aru_release_name,
release_name,multi_org_flag FROM FND_PRODUCT_GROUPS;