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

时间:2022-01-01 04:41:09

/*线用户查询-1*/

SELECT FSAV.USER_NAME,
FU.DESCRIPTION,
FSAV.RESPONSIBILITY_NAME,
FSAV.USER_FORM_NAME,
FSAV.LOGIN_NAME,
FSAV.TIME,
FSAV.PID,
FSAV.TERMINAL_ID,
FSAV.USER_ID,
FSAV.RESP_APPL_ID,
FSAV.RESPONSIBILITY_ID,
FSAV.FORM_ID,
FSAV.FORM_APPL_ID
FROM FND_SIGNON_AUDIT_VIEW FSAV,
FND_USER FU
WHERE 1=1
AND FSAV.LOGIN_NAME='&test'
AND FSAV.USER_ID = FU.USER_ID
order by to_number(substr(FSAV.TIME,1,instr(FSAV.TIME,':')-1))*60
+ to_number(substr(FSAV.TIME,instr(FSAV.TIME,':')+1))

---------------------------------------------------------------------------------------

/*线用户查询-2*/

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