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