VIEW: APPS.PER_ROLES_V

Source

View Text - Preformatted

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(+)

View Text - HTML Formatted

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(+)