Joining 4 queries
I have to create a query which on the entry of the user_name should display the responsibilities under that particular user_name. How can I do that?
The tables that should be used are:
FND_USER
FND_RESPONSIBILITITY_VL
FND_APPLICATION_VL
FND_USER_RESP_GROUPS_DIRECT

Please help...
the username is the mandatory field. 
Joining 4 queries
===

I have to create a query which on the entry of the user_name should display the responsibilities under that particular user_name. How can I do that?
The tables that should be used are:
FND_USER
FND_RESPONSIBILITITY_VL
FND_APPLICATION_VL
FND_USER_RESP_GROUPS_DIRECT

Please help...
the username is the mandatory field. 