查询EBS中应用URL的SQL语句

457475451

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