Tuesday, 8 March 2016

List Responsibilities that can access a form

select rt.responsibility_name, metl.prompt
from fnd_responsibility_tl rt
,    fnd_responsibility r
,    fnd_menus m
,    fnd_menu_entries me
,    fnd_menu_entries_tl metl
,    fnd_form_functions ff
,    fnd_form f
where f.form_id = ff.form_id
and   ff.function_id = me.function_id
and   m.menu_id = me.menu_id
and   m.menu_id = metl.menu_id
and   me.entry_sequence = metl.entry_sequence
and   r.menu_id = m.menu_id
and   r.responsibility_id = rt.responsibility_id
and   metl.language = 'US'
and   f.form_name = 'FORM_NAME'
and   ff.function_name = 'FUNCTION_NAME'

No comments:

Post a comment