查询ebs中应用url的sql

查询ebs中应用url的sql：
SELECT A.PROFILE_OPTION_NAME, B.LEVEL_ID, PROFILE_OPTION_VALUE
FROM FND_PROFILE_OPTIONS A, FND_PROFILE_OPTION_VALUES B
WHERE A.PROFILE_OPTION_ID = B.PROFILE_OPTION_ID
AND A.APPLICATION_ID = B.APPLICATION_ID
AND A.PROFILE_OPTION_NAME IN
('APPS_WEB_AGENT', 'TCF:HOST', 'ICX_REPORT_LAUNCHER',
'ICX_FORMS_LAUNCHER', 'ICX_DISCOVERER_LAUNCHER',
'APPS_SERVLET_AGENT', 'APPS_FRAMEWORK_AGENT', 'APPS_PORTAL',
'ICX_DISCOVERER_VIEWER_LAUNCHER', 'APPS_JSP_AGENT')
ORDER BY A.PROFILE_OPTION_NAME, B.LEVEL_ID

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/594850/viewspace-577984/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/594850/viewspace-577984/