VIEW: APPS.PQH_ROLE_USERS_V1

Source

View Text - Preformatted

SELECT pei.rowid row_id , pei.person_extra_info_id role_user_id , pei.person_id person_id, ppf.full_name person_name , usr.user_name user_name, usr.user_id user_id, rls.role_name 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.pei_information5 user_enable_flag, pei.created_by created_by, pei.creation_date creation_date, pei.last_updated_by last_updated_by, pei.last_update_date last_update_date, pei.last_update_login last_update_login, pei.object_version_number object_version_number, pei.pei_information6 pei_information6, pei.pei_information7 pei_information7, pei.pei_information8 pei_information8, pei.pei_information9 pei_information9, pei.pei_information10 pei_information10, pei.pei_information11 pei_information11, pei.pei_information12 pei_information12, pei.pei_information13 pei_information13, pei.pei_information14 pei_information14, pei.pei_information15 pei_information15, pei.pei_information16 pei_information16, pei.pei_information17 pei_information17, pei.pei_information18 pei_information18, pei.pei_information19 pei_information19, pei.pei_information20 pei_information20, pei.pei_information21 pei_information21, pei.pei_information22 pei_information22, pei.pei_information23 pei_information23, pei.pei_information24 pei_information24, pei.pei_information25 pei_information25, pei.pei_information26 pei_information26, pei.pei_information27 pei_information27, pei.pei_information28 pei_information28, pei.pei_information29 pei_information29, pei.pei_information30 pei_information30 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)

View Text - HTML Formatted

SELECT PEI.ROWID ROW_ID
, PEI.PERSON_EXTRA_INFO_ID ROLE_USER_ID
, PEI.PERSON_ID PERSON_ID
, PPF.FULL_NAME PERSON_NAME
, USR.USER_NAME USER_NAME
, USR.USER_ID USER_ID
, RLS.ROLE_NAME 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.PEI_INFORMATION5 USER_ENABLE_FLAG
, PEI.CREATED_BY CREATED_BY
, PEI.CREATION_DATE CREATION_DATE
, PEI.LAST_UPDATED_BY LAST_UPDATED_BY
, PEI.LAST_UPDATE_DATE LAST_UPDATE_DATE
, PEI.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, PEI.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, PEI.PEI_INFORMATION6 PEI_INFORMATION6
, PEI.PEI_INFORMATION7 PEI_INFORMATION7
, PEI.PEI_INFORMATION8 PEI_INFORMATION8
, PEI.PEI_INFORMATION9 PEI_INFORMATION9
, PEI.PEI_INFORMATION10 PEI_INFORMATION10
, PEI.PEI_INFORMATION11 PEI_INFORMATION11
, PEI.PEI_INFORMATION12 PEI_INFORMATION12
, PEI.PEI_INFORMATION13 PEI_INFORMATION13
, PEI.PEI_INFORMATION14 PEI_INFORMATION14
, PEI.PEI_INFORMATION15 PEI_INFORMATION15
, PEI.PEI_INFORMATION16 PEI_INFORMATION16
, PEI.PEI_INFORMATION17 PEI_INFORMATION17
, PEI.PEI_INFORMATION18 PEI_INFORMATION18
, PEI.PEI_INFORMATION19 PEI_INFORMATION19
, PEI.PEI_INFORMATION20 PEI_INFORMATION20
, PEI.PEI_INFORMATION21 PEI_INFORMATION21
, PEI.PEI_INFORMATION22 PEI_INFORMATION22
, PEI.PEI_INFORMATION23 PEI_INFORMATION23
, PEI.PEI_INFORMATION24 PEI_INFORMATION24
, PEI.PEI_INFORMATION25 PEI_INFORMATION25
, PEI.PEI_INFORMATION26 PEI_INFORMATION26
, PEI.PEI_INFORMATION27 PEI_INFORMATION27
, PEI.PEI_INFORMATION28 PEI_INFORMATION28
, PEI.PEI_INFORMATION29 PEI_INFORMATION29
, PEI.PEI_INFORMATION30 PEI_INFORMATION30
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)