Oracle EBS-SQL (SYS-20):职责使用菜单2.sql
select frt.responsibility_name,fr.menu_id,
fm.menu_name,
fr.request_group_id,
frg.request_group_name
from fnd_responsibility fr,
fnd_responsibility_tl frt,
fnd_menus fm,
fnd_request_groups frg
where frt.responsibility_id = fr.responsibility_id
and frt.language = userenv('LANG')
and frt.responsibility_name like '%X%'
and fm.menu_id = fr.menu_id
and frg.request_group_id = fr.request_group_id
页:
[1]