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