`
xitong
  • 浏览: 6196438 次
文章分类
社区版块
存档分类
最新评论

[Script]Get APPL_TOP and <PROD>_TOP

 
阅读更多
Get APPL_TOP
select name,
node_id,
path,
shared,
created_by,
creation_date,
last_updated_by,
last_update_date,
FILE_SYSTEM_GUID,
appl_top_guid
FROM APPLSYS.FND_APPL_TOPS;

Get <PROD>_TOP
select variable_name,
value
from fnd_env_context
where variable_name like '%\_TOP' escape '\'
and concurrent_process_id = (select max(concurrent_process_id) from fnd_env_context)
order by 1;
分享到:
评论

相关推荐

Global site tag (gtag.js) - Google Analytics