Getting user information

[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

[gmohan]

hi

Please query up with fnd_user table
I believe this is your expectation

Thanks
Mohan

[hamid]

in which user account this table exit

i check in system acount but it give me error table does not exist

[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)