20 September 2011

How to get the FND User name and Responsibility


SELECT c.user_name , RESPONSIBILITY_NAME
    FROM FND_USER_RESP_GROUPS_DIRECT a,
            FND_RESPONSIBILITY_VL b,
            fnd_user c
   WHERE     a.user_id(+) = c.user_id
         AND a.RESPONSIBILITY_ID = b.RESPONSIBILITY_ID(+)
         AND c.user_name = NVL (:user_name, c.user_name)
         --and RESPONSIBILITY_NAME is null
ORDER BY 1;
:user_name =  Enter your username
Output :-
USER_NAME        RESPONSIBILITY
THALAIMUTHUApplication Developer
THALAIMUTHUSystem Administrator
THALAIMUTHUOracle Sales Administrator
THALAIMUTHUQuality
THALAIMUTHUBills of Material
THALAIMUTHUInventory
THALAIMUTHUWorkflow Administrator Web Applications
THALAIMUTHUOrder Management Super User
THALAIMUTHUOracle Pricing Manager
THALAIMUTHUCRM Resource Manager
THALAIMUTHUCRM Task Manager
THALAIMUTHUSFM System Administrator
THALAIMUTHUQuoting Sales Manager
THALAIMUTHUCustomer Support
THALAIMUTHUCRM Administrator
THALAIMUTHUCRM HTML Administration
THALAIMUTHUCall Center Administration
THALAIMUTHUOracle Installed Base Admin
THALAIMUTHUOracle Installed Base User
THALAIMUTHUCRM Application Foundation User
THALAIMUTHUCRM Employee
THALAIMUTHUXML Publisher Administrator
THALAIMUTHUWorkflow Administrator Event Manager
THALAIMUTHUWorkflow Administrator Web (New)
THALAIMUTHUWorkflow User Web (New)
THALAIMUTHUNumber Management
THALAIMUTHUNumber Management User
THALAIMUTHUQtel Installation Team
THALAIMUTHUQtel BackOffice Responsibility
THALAIMUTHUNMS Admin
THALAIMUTHUCall Center Agent
THALAIMUTHUBan Call Centre Representative

No comments: