top of page
Search
Writer's picturemdvorkin

User's Active Responsibilities

-- Change SYSADMIN to whatever you need

select distinct u.user_name, r.responsibility_name, g.start_date, g.end_date

from fnd_responsibility_tl r,

fnd_user_resp_groups g,

fnd_user u

where u.user_id = g.user_id

and r.application_id = g.responsibility_application_id

and r.responsibility_id = g.responsibility_id

and r.language = 'US'

and (sysdate between g.start_date and g.end_date or g.end_date is null)

and u.user_name = 'SYSADMIN'

order by r.responsibility_name;

5 views0 comments

Recent Posts

See All

Get DDL for Oracle object

set feed off set long 1000000 set longchunksize 1000000 set pages 0 set lines 32767 set trimspool on set feed off set wrap on set...

Comments


bottom of page