Technology Stack - EBS (MOSC)

MOSC Banner

Oracle responsibilities - menu and submenu in a FORM on oracle e-business suite 12.2

edited Aug 20, 2021 10:51AM in Technology Stack - EBS (MOSC) 5 commentsAnswered ✓
I need to review Oracle responsibilities using seeded menu and submenu in a FORM on oracle e-business suite 12.2

I am using the following SQLs to get responsibility_name and description fields.

 

select a.application_name, r.responsibility_name, r.description

  from apps.fnd_user u, apps.fnd_user_resp_groups_all ur,

       apps.fnd_responsibility_vl r, apps.fnd_application_vl a

 where a.application_id = r.application_id

   and r.end_date is null

   and r.version in ('4','W','M')

   and r.application_id = ur.responsibility_application_id

   and r.responsibility_id = ur.responsibility_id  

   and ur.user_id = u.user_id

Tagged:

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