ERPstuff - Oracle EBS Community

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

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

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