Page 1 of 1
Getting user information
Posted: Tue Nov 06, 2007 4:25 am
by hamid
AOA
i create lot of users i want there name
any one help me in which table it was store.
how can i access all these user name
Posted: Tue Nov 06, 2007 7:45 am
by gmohan
hi
Please query up with fnd_user table
I believe this is your expectation
Thanks
Mohan
Posted: Tue Nov 06, 2007 7:53 am
by hamid
in which user account this table exit
i check in system acount but it give me error table does not exist
Posted: Tue Nov 06, 2007 8:53 am
by sudhir
hi
Please query up with fnd_user table
I believe this is your expectation
Thanks
Mohan
<i><div align="right">Originally posted by gmohan - Nov 06 2007 : 02:45:55 AM</div id="right"></i>
hi try this query, this will give you the employee name and responsibilities attached:
select f1.FULL_NAME Employee_Name,f2.USER_NAME User_Name,f4.RESPONSIBILITY_NAME Resp_Name
from per_all_people_f f1,
fnd_user f2,
FND_USER_RESP_GROUPS_DIRECT f3,
FND_RESPONSIBILITY_VL f4
where f1.PERSON_ID = f2.EMPLOYEE_ID
and f2.USER_ID = f3.USER_ID
and f3.RESPONSIBILITY_ID = f4.RESPONSIBILITY_ID
and f2.USER_NAME like '%'
(enter the user name if being specific)