VIEW: APPS.PER_SECURITY_USERS_V

Source

View Text - Preformatted

SELECT psu.security_user_id , psu.security_profile_id , psu.user_id , fndu.user_name , fndu.employee_id , papf.full_name , psu.process_in_next_run_flag , psu.object_version_number , psu.created_by , psu.creation_date , psu.last_updated_by , psu.last_update_login , psu.last_update_date FROM per_security_users psu , per_all_people_f papf , fnd_user fndu , fnd_sessions fnds WHERE psu.user_id = fndu.user_id AND fndu.employee_id = papf.person_id(+) AND fnds.session_id = userenv('SESSIONID') AND fnds.effective_date BETWEEN NVL(papf.effective_start_date, fnds.effective_date) AND NVL(papf.effective_end_date, fnds.effective_date) ORDER BY fndu.user_name

View Text - HTML Formatted

SELECT PSU.SECURITY_USER_ID
, PSU.SECURITY_PROFILE_ID
, PSU.USER_ID
, FNDU.USER_NAME
, FNDU.EMPLOYEE_ID
, PAPF.FULL_NAME
, PSU.PROCESS_IN_NEXT_RUN_FLAG
, PSU.OBJECT_VERSION_NUMBER
, PSU.CREATED_BY
, PSU.CREATION_DATE
, PSU.LAST_UPDATED_BY
, PSU.LAST_UPDATE_LOGIN
, PSU.LAST_UPDATE_DATE
FROM PER_SECURITY_USERS PSU
, PER_ALL_PEOPLE_F PAPF
, FND_USER FNDU
, FND_SESSIONS FNDS
WHERE PSU.USER_ID = FNDU.USER_ID
AND FNDU.EMPLOYEE_ID = PAPF.PERSON_ID(+)
AND FNDS.SESSION_ID = USERENV('SESSIONID')
AND FNDS.EFFECTIVE_DATE BETWEEN NVL(PAPF.EFFECTIVE_START_DATE
, FNDS.EFFECTIVE_DATE)
AND NVL(PAPF.EFFECTIVE_END_DATE
, FNDS.EFFECTIVE_DATE) ORDER BY FNDU.USER_NAME