|
Re: Financial Inquiry - Rules/Responsibilities ... [message #367243 is a reply to message #367242] |
Tue, 12 September 2000 14:41 |
Alan Ferrante
Messages: 5 Registered: May 2000
|
Junior Member |
|
|
In AOL 10.7, a simple query can determine if a user has a specific responsibility:
select count(*)
from
fnd_user A,
fnd_user_responsibility B,
fnd_responsibility C
where
A.user_name = 'RSMITH'
and A.user_id = B.user_id(+)
and B.responsibility_id = C.responsibility_id
and C.responsibility_name = 'FINANCIAL INQUIRY'
Hope this is helpful.
|
|
|
Forgot the Date! [message #367244 is a reply to message #367242] |
Tue, 12 September 2000 14:45 |
Alan Ferrante
Messages: 5 Registered: May 2000
|
Junior Member |
|
|
In AOL 10.7, a simple query can determine if a user has a specific responsibility:
select count(*)
from
fnd_user A,
fnd_user_responsibility B,
fnd_responsibility C
where
A.user_name = 'RSMITH'
and A.user_id = B.user_id(+)
and B.responsibility_id = C.responsibility_id
and C.responsibility_name = 'FINANCIAL INQUIRY'
and sysdate between B.start_date and B.end_date
Hope this is helpful.
|
|
|
Re: Forgot the Date! [message #367245 is a reply to message #367244] |
Wed, 13 September 2000 07:51 |
Bob Harrison
Messages: 3 Registered: September 2000
|
Junior Member |
|
|
Thanks Allan, but I am trying to take this a few steps past this.
What I want in the end is to show what segments a User is allowed for a Responsibility.
ie: for 102752 inclued - exclude = 100-300 and X-Y
for 102753 ....
for 102754 ....
In the end I want
User A has permissions to look at
0000-000-000-0000-000000-0000-0000-000
Can It be accomplished ?? I get as far as the include/exclude and stall there
|
|
|