查找在标准请求组里提交的报表所在的职责

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 '%杂项出入库报表%'


posted @ 2010-12-31 11:43  郭振斌  阅读(554)  评论(0编辑  收藏  举报