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
相关文章
- 07-19Oracle EBS-SQL (SYS-3):sys_人员用户名对应关系查询.sql
- 07-19Oracle EBS-SQL (SYS-21):sys_用户名与人员对应关系查询.sql
- 07-19Oracle EBS-SQL (SYS-19):sys-用户登陆纪录查询.sql
- 07-19Oracle EBS-SQL (SYS-6):sys_在线用户职责查询2.sql
- 07-19Oracle EBS-SQL (SYS-1): sysadmin_用户职责查询.sql
- 07-19Oracle EBS-SQL (SYS-5):sys_配置文件查询.sql
- 07-19Oracle EBS-SQL (SYS-2): sys_在线用户查询.sql
- 07-19Oracle EBS-SQL (SYS-3):sys_人员用户名对应关系查询.sql