查找在标准请求组里提交的报表所在的职责
select a.responsibility_name,
b.user_concurrent_program_name,
b.concurrent_program_name
from fnd_responsibility_vl a,
fnd_concurrent_programs_vl b,
fnd_request_group_units c
where a.application_id = c.application_id
and a.request_group_id = c.request_group_id
and b.application_id = c.unit_application_id
and b.concurrent_program_id = c.request_unit_id
and b.user_concurrent_program_name like '%杂项出入库报表%'
b.user_concurrent_program_name,
b.concurrent_program_name
from fnd_responsibility_vl a,
fnd_concurrent_programs_vl b,
fnd_request_group_units c
where a.application_id = c.application_id
and a.request_group_id = c.request_group_id
and b.application_id = c.unit_application_id
and b.concurrent_program_id = c.request_unit_id
and b.user_concurrent_program_name like '%杂项出入库报表%'
成长
/ | \
学习 总结 分享
QQ交流群:122230156