您的位置:首页 > 博客中心 > 数据库 >

Oracle EBS-SQL (SYS-2): sys_在线用户查询.sql

时间:2022-03-10 17:32

SELECT fs.USER_NAME,
       fu.description,
       fs.RESPONSIBILITY_NAME,
       fs.USER_FORM_NAME,
       fs.TIME,
       fs.RESP_APPL_ID,
       fs.RESPONSIBILITY_ID,
       fs.FORM_ID,
       fs.FORM_APPL_ID
  FROM FND_SIGNON_AUDIT_VIEW fs,
       fnd_user fu
WHERE fs.user_id=fu.user_id
and fs.RESPONSIBILITY_NAME is not null
order by 1

Oracle EBS-SQL (SYS-2): sys_在线用户查询.sql,布布扣,bubuko.com

热门排行

今日推荐

热门手游