R12 SQL for responsabilities and menu
Hello
I would like to ask you if you can share with me any SQL to get the user, responsabilities and menus.
I have the following example.
Thanks
It shows what is current and has columns on the right showing what is ended or excluded.
--Matrix of Application, Responsibility, Menu, Prompt, Function, SubMenu, SubFunction
--that shows resposibility end date and identifies exclusions
select second.application_id "App ID"
, second.application_name "App Name"
, second.responsibility_id "Resp ID"
, second.responsibility_name "Responsibility"
, second.menu_id "Menu ID"
, second.user_menu_name "Main Menu Name"
, second.entry_sequence "Seq"
, second.prompt "Prompt"