Product: | PQH - Public Sector HR |
---|---|
Description: | |
Implementation/DBA Data: | APPS.PQH_ROLE_PEOPLE_V |
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)