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 |
THALAIMUTHU | Application Developer |
THALAIMUTHU | System Administrator |
THALAIMUTHU | Oracle Sales Administrator |
THALAIMUTHU | Quality |
THALAIMUTHU | Bills of Material |
THALAIMUTHU | Inventory |
THALAIMUTHU | Workflow Administrator Web Applications |
THALAIMUTHU | Order Management Super User |
THALAIMUTHU | Oracle Pricing Manager |
THALAIMUTHU | CRM Resource Manager |
THALAIMUTHU | CRM Task Manager |
THALAIMUTHU | SFM System Administrator |
THALAIMUTHU | Quoting Sales Manager |
THALAIMUTHU | Customer Support |
THALAIMUTHU | CRM Administrator |
THALAIMUTHU | CRM HTML Administration |
THALAIMUTHU | Call Center Administration |
THALAIMUTHU | Oracle Installed Base Admin |
THALAIMUTHU | Oracle Installed Base User |
THALAIMUTHU | CRM Application Foundation User |
THALAIMUTHU | CRM Employee |
THALAIMUTHU | XML Publisher Administrator |
THALAIMUTHU | Workflow Administrator Event Manager |
THALAIMUTHU | Workflow Administrator Web (New) |
THALAIMUTHU | Workflow User Web (New) |
THALAIMUTHU | Number Management |
THALAIMUTHU | Number Management User |
THALAIMUTHU | Qtel Installation Team |
THALAIMUTHU | Qtel BackOffice Responsibility |
THALAIMUTHU | NMS Admin |
THALAIMUTHU | Call Center Agent |
THALAIMUTHU | Ban Call Centre Representative |
No comments:
Post a Comment