User and Responsibility

[harrygulls]

Hi,

Can you help me writing a query from which I can find out the responsibilities of a particular user...?

Thanks
Harry

[marist89]

I think the Active Users report will show you that...

[harrygulls]

Yes U R right.
But I want to write the query by giving partiular USERNAME as parameter in the query, so that I can just get the all the responsibilities of a particular USER.

Thanks
Harry

[eddyng]

The following SQL show what you want. Please replace SYSADMIN with the user name that you want to display.

SELECT
rl.responsibility_name,
r.start_date,
r.end_date
FROM
fnd_responsibility r,
fnd_responsibility_tl rl,
fnd_user_resp_groups rg,
fnd_user u
WHERE
r.responsibility_id = rg.responsibility_id AND
r.responsibility_id = rl.responsibility_id AND
u.user_id = rg.user_id AND
u.user_name = 'SYSADMIN'

[harrygulls]

THANKS THATS HELPS

BUT THIS QUERY IS SHOWING DUPLICATE RECORDS

WE NEED TO MODIFY THE QUERY LITTLE BIT

I USED THE DISTINCT FUNCTION TO AVOID DUPLICATES.

THANKS AGAIN
HARRY