查询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                                                                  10001
APPS_JSP_AGENT                                                                        10001
APPS_PORTAL                                                                           10001 http://erptest.xxx:8020/pls/dev_portal30/portal30.home
APPS_SERVLET_AGENT                                                                    10001
APPS_WEB_AGENT                                                                        10001 http://erptest.xxx:8020/pls/dev
ICX_DISCOVERER_LAUNCHER                                                               10001
ICX_DISCOVERER_VIEWER_LAUNCHER                                                        10001 ]
ICX_FORMS_LAUNCHER                                                                    10001 http://erptest.xxx:8020/dev60cgi/f60cgi
ICX_REPORT_LAUNCHER                                                                   10001 http://erptest.xxx:8020/dev60cgi/rwcgi60
TCF:HOST                                                                              10001

10 rows selected

SQL>