查询EBS中应用URL的SQL语句
SQL> SELECT A.PROFILE_OPTION_NAME, B.LEVEL_ID, PROFILE_OPTION_VALUE2 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=
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
页:
[1]