查询EBS中使用URL的SQL语句

SQL> SELECT A.PROFILE_OPTION_NAME, B.LEVEL_ID, PROFILE_OPTION_VALUE
? 2? FROM FND_PROFILE_OPTIONS A, FND_PROFILE_OPTION_VALUES B
? 3? WHERE A.PROFILE_OPTION_ID = B.PROFILE_OPTION_ID
? 4? AND A.APPLICATION_ID = B.APPLICATION_ID
? 5? AND A.PROFILE_OPTION_NAME IN
? 6? ('APPS_WEB_AGENT', 'TCF:HOST', 'ICX_REPORT_LAUNCHER',
? 7? 'ICX_FORMS_LAUNCHER', 'ICX_DISCOVERER_LAUNCHER',
? 8? 'APPS_SERVLET_AGENT', 'APPS_FRAMEWORK_AGENT', 'APPS_PORTAL',
? 9? 'ICX_DISCOVERER_VIEWER_LAUNCHER', 'APPS_JSP_AGENT')
?10? ORDER BY A.PROFILE_OPTION_NAME, B.LEVEL_ID
?11? ;

PROFILE_OPTION_NAME??????????????????????????????????????????????????????????????? LEVEL_ID PROFILE_OPTION_VALUE
-------------------------------------------- ---------- --------------------------------------------
APPS_FRAMEWORK_AGENT????????????????????????????????????????????????????????????????? 10001http://erptest.xxx.com:8020
APPS_JSP_AGENT??????????????????????????????????????????????????????????????????????? 10001http://erptest.xxx.com:8020
APPS_PORTAL?????????????????????????????????????????????????????????????????????????? 10001http://erptest.xxx:8020/pls/dev_portal30/portal30.home
APPS_SERVLET_AGENT??????????????????????????????????????????????????????????????????? 10001http://erptest.xxx:8020/oa_servlets
APPS_WEB_AGENT??????????????????????????????????????????????????????????????????????? 10001http://erptest.xxx:8020/pls/dev
ICX_DISCOVERER_LAUNCHER?????????????????????????????????????????????????????????????? 10001http://erptest.xxx:8020/discwb4/html/discolaunch.htm?Connect=[APPS_SE
ICX_DISCOVERER_VIEWER_LAUNCHER??????????????????????????????????????????????????????? 10001http://erptest.xxx:8020/discoverer4i/viewer?Connect=[APPS_SECURE]
ICX_FORMS_LAUNCHER??????????????????????????????????????????????????????????????????? 10001http://erptest.xxx:8020/dev60cgi/f60cgi
ICX_REPORT_LAUNCHER?????????????????????????????????????????????????????????????????? 10001http://erptest.xxx:8020/dev60cgi/rwcgi60
TCF:HOST????????????????????????????????????????????????????????????????????????????? 10001http://erptest.xxx:8020/oa_servlets

10 rows selected