打印报表以显示具有给定责任的用户-FNDSCRUR责任用户
select --&p_hint
distinct
user_name,
decode (
greatest (u.start_date,
ur.start_date,
r.start_date,
to_date ('1000-01-01', 'YYYY-MM-DD')),
to_date ('1000-01-01', 'YYYY-MM-DD'), '',
to_char (greatest (u.start_date, ur.start_date, r.start_date)))
resp_start_date,
decode (
least (nvl (u.end_date, to_date ('4712-01-01', 'YYYY-MM-DD')),
nvl (ur.end_date, to_date ('4712-01-01', 'YYYY-MM-DD')),
nvl (r.end_date, to_date ('4712-01-01', 'YYYY-MM-DD'))),
to_date ('4712-01-01', 'YYYY-MM-DD'), '',
to_char (
least (nvl (u.end_date, nvl (ur.end_date, r.end_date)),
nvl (ur.end_date, nvl (u.end_date, r.end_date)),
nvl (r.end_date, nvl (u.end_date, ur.end_date)))))
resp_end_date,
s.security_group_name
-- , u.description
, rt.responsibility_name,
rt.description
from fnd_user u,
fnd_user_resp_groups_all ur,
fnd_responsibility r,
fnd_security_groups_vl s,
fnd_responsibility_tl rt
where 1 = 1
and rt.responsibility_id = r.responsibility_id
and rt.application_id = r.application_id
--AND r.application_id = :application_id
-- and r.responsibility_id = :responsibility_id
and user_name = 'QUANWEIRU'
and ur.responsibility_application_id = r.application_id
and ur.responsibility_id = r.responsibility_id
and u.user_id = ur.user_id
and ur.security_group_id = s.security_group_id
order by user_name, security_group_name
最新文章
- [课程设计]Scrum 1.3 多鱼点餐系统开发进度
- scrapy系统学习(1)--概要
- HTML5基础知识(1)--上标和下标文本
- Nginx的作用
- poi 读取 excel (.xls) 97-2003
- poj 3237 Tree 树链剖分+线段树
- Makefile中include、-include、sinclude的区别
- 关于常用却忘记的css,jQuery
- 【转】linux命令useradd添加用户详解
- python3.5 修改 IIS WEB.CONFIG的相关方法
- 镜像命名的最佳实践 - 每天5分钟玩转 Docker 容器技术(18)
- MYSQL报错注入方法整理
- FileBeat安装配置
- 使用paginate分页后数据处理
- protel dxp 2004安装与破解
- Android ScrollView内部组件设置android:layout_height=";fill_parent";无效的解决办法
- mysql(5.7以上)查询报错:ORDER BY clause is not in GROUP BY..this is incompatible with sql_mode=only_full_group_by
- zabbix宏(macro)使用:自定义监控阈值
- 倒数第N个字符串
- (转) argparse — 解析命令参数和选项