Technology Stack - EBS (MOSC)

MOSC Banner

Queries: user id and employee number ,and reponsibility and menu exclusions

edited Aug 20, 2021 11:20AM in Technology Stack - EBS (MOSC) 3 commentsAnswered ✓
 hi,

I'm not quite sure which forum should i add my question to, so please bear with me.

I have two different queries that are requested and I do not have a document to guide me in the tables relationships.
Query 1:
need to represent the reponsibility name asscociated with the name of menu and the functions excluded from that menu in the responsibility.
i was only able to retrieve the reponsibility name and the menu name, i do not know what is the table that contains the menu exclusion and how can i link it to the responsibility.
Please help, my query so far is as follows:

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