VIEW: APPS.PQH_ROLE_PEOPLE_V

Source

View Text - Preformatted

SELECT pei.rowid row_id , pei.person_extra_info_id role_user_id , pei.person_id , ppx.full_name person_name , rls.role_name , decode(pei.information_type, 'PQH_ROLE_USERS', to_number(pei.pei_information3), 0) role_id , pei.pei_information4 default_role , pei.created_by , pei.creation_date , pei.last_updated_by , pei.last_update_date , pei.last_update_login, pei.object_version_number, pei.information_type, pei_attribute_category, pei_attribute1, pei_attribute2, pei_attribute3, pei_attribute4, pei_attribute5, pei_attribute6, pei_attribute7, pei_attribute8, pei_attribute9, pei_attribute10, pei_attribute11, pei_attribute12, pei_attribute13, pei_attribute14, pei_attribute15, pei_attribute16, pei_attribute17, pei_attribute18, pei_attribute19, pei_attribute20, pei_information_category, pei_information1, pei_information2, pei_information3, pei_information4, pei_information5, pei_information6, pei_information7, pei_information8, pei_information9, pei_information10, pei_information11, pei_information12, pei_information13, pei_information14, pei_information15, pei_information16, pei_information17, pei_information18, pei_information19, pei_information20, pei_information21, pei_information22, pei_information23, pei_information24, pei_information25, pei_information26, pei_information27, pei_information28, pei_information29, pei_information30 from per_people_extra_info pei , per_people_x ppx , pqh_roles rls WHERE information_type = 'PQH_ROLE_USERS' and pei.person_id = ppx.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
, PPX.FULL_NAME PERSON_NAME
, RLS.ROLE_NAME
, DECODE(PEI.INFORMATION_TYPE
, 'PQH_ROLE_USERS'
, TO_NUMBER(PEI.PEI_INFORMATION3)
, 0) ROLE_ID
, PEI.PEI_INFORMATION4 DEFAULT_ROLE
, PEI.CREATED_BY
, PEI.CREATION_DATE
, PEI.LAST_UPDATED_BY
, PEI.LAST_UPDATE_DATE
, PEI.LAST_UPDATE_LOGIN
, PEI.OBJECT_VERSION_NUMBER
, PEI.INFORMATION_TYPE
, PEI_ATTRIBUTE_CATEGORY
, PEI_ATTRIBUTE1
, PEI_ATTRIBUTE2
, PEI_ATTRIBUTE3
, PEI_ATTRIBUTE4
, PEI_ATTRIBUTE5
, PEI_ATTRIBUTE6
, PEI_ATTRIBUTE7
, PEI_ATTRIBUTE8
, PEI_ATTRIBUTE9
, PEI_ATTRIBUTE10
, PEI_ATTRIBUTE11
, PEI_ATTRIBUTE12
, PEI_ATTRIBUTE13
, PEI_ATTRIBUTE14
, PEI_ATTRIBUTE15
, PEI_ATTRIBUTE16
, PEI_ATTRIBUTE17
, PEI_ATTRIBUTE18
, PEI_ATTRIBUTE19
, PEI_ATTRIBUTE20
, PEI_INFORMATION_CATEGORY
, PEI_INFORMATION1
, PEI_INFORMATION2
, PEI_INFORMATION3
, PEI_INFORMATION4
, PEI_INFORMATION5
, PEI_INFORMATION6
, PEI_INFORMATION7
, PEI_INFORMATION8
, PEI_INFORMATION9
, PEI_INFORMATION10
, PEI_INFORMATION11
, PEI_INFORMATION12
, PEI_INFORMATION13
, PEI_INFORMATION14
, PEI_INFORMATION15
, PEI_INFORMATION16
, PEI_INFORMATION17
, PEI_INFORMATION18
, PEI_INFORMATION19
, PEI_INFORMATION20
, PEI_INFORMATION21
, PEI_INFORMATION22
, PEI_INFORMATION23
, PEI_INFORMATION24
, PEI_INFORMATION25
, PEI_INFORMATION26
, PEI_INFORMATION27
, PEI_INFORMATION28
, PEI_INFORMATION29
, PEI_INFORMATION30
FROM PER_PEOPLE_EXTRA_INFO PEI
, PER_PEOPLE_X PPX
, PQH_ROLES RLS
WHERE INFORMATION_TYPE = 'PQH_ROLE_USERS'
AND PEI.PERSON_ID = PPX.PERSON_ID
AND RLS.ROLE_ID = TO_NUMBER(PEI.PEI_INFORMATION3)