VIEW: APPS.PQH_ROLE_USERS_V

Source

View Text - Preformatted

SELECT pei.rowid row_id , pei.person_extra_info_id role_user_id , pei.person_id , ppf.full_name person_name , usr.user_name , usr.user_id , rls.role_name , decode(information_type, 'PQH_ROLE_USERS', to_number(pei.pei_information3), 0) role_id , pei.pei_information4 default_role , rls.enable_flag role_enable_flag, pei.created_by , pei.creation_date , pei.last_updated_by , pei.last_update_date , pei.last_update_login , pei.object_version_number from per_people_extra_info pei , per_all_people_f ppf , fnd_user usr , pqh_roles rls WHERE information_type = 'PQH_ROLE_USERS' and pei.person_id = ppf.person_id and (select ses.effective_date from fnd_sessions ses where ses.session_id = userenv('sessionid')) between ppf.effective_start_date and ppf.effective_end_date and usr.employee_id = ppf.person_id and rls.role_id = to_number(pei.pei_information3) and nvl(pei.pei_information5,'Y')='Y'

View Text - HTML Formatted

SELECT PEI.ROWID ROW_ID
, PEI.PERSON_EXTRA_INFO_ID ROLE_USER_ID
, PEI.PERSON_ID
, PPF.FULL_NAME PERSON_NAME
, USR.USER_NAME
, USR.USER_ID
, RLS.ROLE_NAME
, DECODE(INFORMATION_TYPE
, 'PQH_ROLE_USERS'
, TO_NUMBER(PEI.PEI_INFORMATION3)
, 0) ROLE_ID
, PEI.PEI_INFORMATION4 DEFAULT_ROLE
, RLS.ENABLE_FLAG ROLE_ENABLE_FLAG
, PEI.CREATED_BY
, PEI.CREATION_DATE
, PEI.LAST_UPDATED_BY
, PEI.LAST_UPDATE_DATE
, PEI.LAST_UPDATE_LOGIN
, PEI.OBJECT_VERSION_NUMBER
FROM PER_PEOPLE_EXTRA_INFO PEI
, PER_ALL_PEOPLE_F PPF
, FND_USER USR
, PQH_ROLES RLS
WHERE INFORMATION_TYPE = 'PQH_ROLE_USERS'
AND PEI.PERSON_ID = PPF.PERSON_ID
AND (SELECT SES.EFFECTIVE_DATE
FROM FND_SESSIONS SES
WHERE SES.SESSION_ID = USERENV('SESSIONID')) BETWEEN PPF.EFFECTIVE_START_DATE
AND PPF.EFFECTIVE_END_DATE
AND USR.EMPLOYEE_ID = PPF.PERSON_ID
AND RLS.ROLE_ID = TO_NUMBER(PEI.PEI_INFORMATION3)
AND NVL(PEI.PEI_INFORMATION5
, 'Y')='Y'