Chinaunix首页 | 论坛 | 博客
  • 博客访问: 2519149
  • 博文数量: 323
  • 博客积分: 10211
  • 博客等级: 上将
  • 技术积分: 4934
  • 用 户 组: 普通用户
  • 注册时间: 2006-08-27 14:56
文章分类

全部博文(323)

文章存档

2012年(5)

2011年(3)

2010年(6)

2009年(140)

2008年(169)

分类: Oracle

2008-11-26 10:32:10

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>
阅读(1731) | 评论(0) | 转发(0) |
给主人留下些什么吧!~~