EBS Customizations (MOSC)

MOSC Banner

R12 SQL for responsabilities and menu

edited Mar 26, 2015 3:24PM in EBS Customizations (MOSC) 1 commentAnswered ✓

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"

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center