Product: | PER - Human Resources |
---|---|
Description: | |
Implementation/DBA Data: | APPS.PER_ROLES_V |
SELECT ROL.ROWID ROW_ID
, ROL.ROLE_ID
, ROL.PERSON_ID
, ROL.ORGANIZATION_ID
, ROL.JOB_GROUP_ID
, ORG.NAME
, JGR.DISPLAYED_NAME
, ROL.JOB_ID
, JBT.NAME
, ROL.START_DATE
, ROL.END_DATE
, ROL.CONFIDENTIAL_DATE
, ROL.EMP_RIGHTS_FLAG
, ROL.END_OF_RIGHTS_DATE
, ROL.PRIMARY_CONTACT_FLAG
, ROL.ATTRIBUTE_CATEGORY
, ROL.ATTRIBUTE1
, ROL.ATTRIBUTE2
, ROL.ATTRIBUTE3
, ROL.ATTRIBUTE4
, ROL.ATTRIBUTE5
, ROL.ATTRIBUTE6
, ROL.ATTRIBUTE7
, ROL.ATTRIBUTE8
, ROL.ATTRIBUTE9
, ROL.ATTRIBUTE10
, ROL.ATTRIBUTE11
, ROL.ATTRIBUTE12
, ROL.ATTRIBUTE13
, ROL.ATTRIBUTE14
, ROL.ATTRIBUTE15
, ROL.ATTRIBUTE16
, ROL.ATTRIBUTE17
, ROL.ATTRIBUTE18
, ROL.ATTRIBUTE19
, ROL.ATTRIBUTE20
, ROL.ROLE_INFORMATION_CATEGORY
, ROL.ROLE_INFORMATION1
, ROL.ROLE_INFORMATION2
, ROL.ROLE_INFORMATION3
, ROL.ROLE_INFORMATION4
, ROL.ROLE_INFORMATION5
, ROL.ROLE_INFORMATION6
, ROL.ROLE_INFORMATION7
, ROL.ROLE_INFORMATION8
, ROL.ROLE_INFORMATION9
, ROL.ROLE_INFORMATION10
, ROL.ROLE_INFORMATION11
, ROL.ROLE_INFORMATION12
, ROL.ROLE_INFORMATION13
, ROL.ROLE_INFORMATION14
, ROL.ROLE_INFORMATION15
, ROL.ROLE_INFORMATION16
, ROL.ROLE_INFORMATION17
, ROL.ROLE_INFORMATION18
, ROL.ROLE_INFORMATION19
, ROL.ROLE_INFORMATION20
, ROL.LAST_UPDATE_DATE
, ROL.LAST_UPDATED_BY
, ROL.LAST_UPDATE_LOGIN
, ROL.CREATED_BY
, ROL.CREATION_DATE
, ROL.OBJECT_VERSION_NUMBER
FROM PER_ROLES ROL
, PER_JOBS JOB
, PER_JOBS_TL JBT
, PER_JOB_GROUPS JGR
, HR_ALL_ORGANIZATION_UNITS ORG
WHERE ROL.JOB_ID = JOB.JOB_ID
AND ROL.JOB_GROUP_ID = JGR.JOB_GROUP_ID
AND JOB.JOB_ID = JBT.JOB_ID
AND JBT.LANGUAGE = USERENV('LANG')
AND ROL.ORGANIZATION_ID = ORG.ORGANIZATION_ID(+)