Responsibility and User Query

[abbasmalik]

Dear all

Can any one provide a query to extract this information
Responsibility name
menus and functions available with Responsibility
users assigned to that Responsibility
position of users
Responsibility start date
THANKS

[vijayakumar.kasi]

Dear Abbas,

Use these queries to extract the information. Thanks in Anticipation.

TO GET USER,APPLICATION AND ASSIGNED RESPONSIBILITY

select unique
u.user_id, substr(u.user_name,1,30) user_name,
SubStr(A.APPLICATION_NAME,1,50) Application,
SubStr(R.RESPONSIBILITY_NAME,1,60) Responsiblity
From
fnd_user u, FND_USER_RESP_GROUPS G, fnd_application_tl A, FND_RESPONSIBILITY_TL R
Where
G.User_Id(+) = U.User_ID
And G.RESPONSIBILITY_APPLICATION_ID = A.Application_Id
And A.Application_Id = R.Application_Id
And G.RESPONSIBILITY_ID = R.RESPONSIBILITY_ID
order by
substr(user_name,1,30),
SubStr(A.APPLICATION_NAME,1,50),
SubStr(R.RESPONSIBILITY_NAME,1,60)


TO GET APPLICATION,RESPONSIBILITY AND ASSIGNED MENU

SELECT DISTINCT e.application_name, a.responsibility_name, a.LANGUAGE,
b.responsibility_key, c.user_menu_name
FROM apps.fnd_responsibility_tl a,
apps.fnd_responsibility b,
apps.fnd_menus_tl c,
apps.fnd_menus d,
apps.fnd_application_tl e,
apps.fnd_application f
WHERE a.responsibility_id(+) = b.responsibility_id
AND b.menu_id = c.menu_id
AND b.menu_id = d.menu_id
AND e.application_id = f.application_id
AND f.application_id = b.application_id
AND a.LANGUAGE = 'US'


TO GET USER HAVING RESPONSIBILITY FOR A SPECIFIC APPLICATION

SELECT UNIQUE U.USER_ID, SUBSTR (U.USER_NAME, 1, 30) USER_NAME,
SUBSTR (R.RESPONSIBILITY_NAME, 1, 60) RESPONSIBLITY,
SUBSTR (A.APPLICATION_NAME, 1, 50) APPLICATION
FROM FND_USER U,
FND_USER_RESP_GROUPS G,
FND_APPLICATION_TL A,
FND_RESPONSIBILITY_TL R
WHERE G.USER_ID(+) = U.USER_ID
AND G.RESPONSIBILITY_APPLICATION_ID = A.APPLICATION_ID
AND A.APPLICATION_ID = R.APPLICATION_ID
AND G.RESPONSIBILITY_ID = R.RESPONSIBILITY_ID
AND A.APPLICATION_NAME = 'Purchasing' ---Application name
ORDER BY SUBSTR (USER_NAME, 1, 30),
SUBSTR (A.APPLICATION_NAME, 1, 50),
SUBSTR (R.RESPONSIBILITY_NAME, 1, 60);

Regards

Kasi, Vijayakumar

[abbasmalik]

<font size="3">Dear Kasi, Vijayakumar
thank you vey much for your help
i will try these queries
thanks again</font id="size3">