VIEW: HR.PER_ROLES#

Source

View Text - Preformatted

select ROLE_ID ROLE_ID, JOB_GROUP_ID JOB_GROUP_ID, PERSON_ID PERSON_ID, ORGANIZATION_ID ORGANIZATION_ID, JOB_ID JOB_ID, START_DATE START_DATE, END_DATE END_DATE, CONFIDENTIAL_DATE CONFIDENTIAL_DATE, EMP_RIGHTS_FLAG EMP_RIGHTS_FLAG, END_OF_RIGHTS_DATE END_OF_RIGHTS_DATE, PRIMARY_CONTACT_FLAG PRIMARY_CONTACT_FLAG, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, ATTRIBUTE11 ATTRIBUTE11, ATTRIBUTE12 ATTRIBUTE12, ATTRIBUTE13 ATTRIBUTE13, ATTRIBUTE14 ATTRIBUTE14, ATTRIBUTE15 ATTRIBUTE15, ATTRIBUTE16 ATTRIBUTE16, ATTRIBUTE17 ATTRIBUTE17, ATTRIBUTE18 ATTRIBUTE18, ATTRIBUTE19 ATTRIBUTE19, ATTRIBUTE20 ATTRIBUTE20, ROLE_INFORMATION_CATEGORY ROLE_INFORMATION_CATEGORY, ROLE_INFORMATION1 ROLE_INFORMATION1, ROLE_INFORMATION2 ROLE_INFORMATION2, ROLE_INFORMATION3 ROLE_INFORMATION3, ROLE_INFORMATION4 ROLE_INFORMATION4, ROLE_INFORMATION5 ROLE_INFORMATION5, ROLE_INFORMATION6 ROLE_INFORMATION6, ROLE_INFORMATION7 ROLE_INFORMATION7, ROLE_INFORMATION8 ROLE_INFORMATION8, ROLE_INFORMATION9 ROLE_INFORMATION9, ROLE_INFORMATION10 ROLE_INFORMATION10, ROLE_INFORMATION11 ROLE_INFORMATION11, ROLE_INFORMATION12 ROLE_INFORMATION12, ROLE_INFORMATION13 ROLE_INFORMATION13, ROLE_INFORMATION14 ROLE_INFORMATION14, ROLE_INFORMATION15 ROLE_INFORMATION15, ROLE_INFORMATION16 ROLE_INFORMATION16, ROLE_INFORMATION17 ROLE_INFORMATION17, ROLE_INFORMATION18 ROLE_INFORMATION18, ROLE_INFORMATION19 ROLE_INFORMATION19, ROLE_INFORMATION20 ROLE_INFORMATION20, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, OLD_END_DATE OLD_END_DATE from "HR"."PER_ROLES"

View Text - HTML Formatted

SELECT ROLE_ID ROLE_ID
, JOB_GROUP_ID JOB_GROUP_ID
, PERSON_ID PERSON_ID
, ORGANIZATION_ID ORGANIZATION_ID
, JOB_ID JOB_ID
, START_DATE START_DATE
, END_DATE END_DATE
, CONFIDENTIAL_DATE CONFIDENTIAL_DATE
, EMP_RIGHTS_FLAG EMP_RIGHTS_FLAG
, END_OF_RIGHTS_DATE END_OF_RIGHTS_DATE
, PRIMARY_CONTACT_FLAG PRIMARY_CONTACT_FLAG
, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
, ATTRIBUTE16 ATTRIBUTE16
, ATTRIBUTE17 ATTRIBUTE17
, ATTRIBUTE18 ATTRIBUTE18
, ATTRIBUTE19 ATTRIBUTE19
, ATTRIBUTE20 ATTRIBUTE20
, ROLE_INFORMATION_CATEGORY ROLE_INFORMATION_CATEGORY
, ROLE_INFORMATION1 ROLE_INFORMATION1
, ROLE_INFORMATION2 ROLE_INFORMATION2
, ROLE_INFORMATION3 ROLE_INFORMATION3
, ROLE_INFORMATION4 ROLE_INFORMATION4
, ROLE_INFORMATION5 ROLE_INFORMATION5
, ROLE_INFORMATION6 ROLE_INFORMATION6
, ROLE_INFORMATION7 ROLE_INFORMATION7
, ROLE_INFORMATION8 ROLE_INFORMATION8
, ROLE_INFORMATION9 ROLE_INFORMATION9
, ROLE_INFORMATION10 ROLE_INFORMATION10
, ROLE_INFORMATION11 ROLE_INFORMATION11
, ROLE_INFORMATION12 ROLE_INFORMATION12
, ROLE_INFORMATION13 ROLE_INFORMATION13
, ROLE_INFORMATION14 ROLE_INFORMATION14
, ROLE_INFORMATION15 ROLE_INFORMATION15
, ROLE_INFORMATION16 ROLE_INFORMATION16
, ROLE_INFORMATION17 ROLE_INFORMATION17
, ROLE_INFORMATION18 ROLE_INFORMATION18
, ROLE_INFORMATION19 ROLE_INFORMATION19
, ROLE_INFORMATION20 ROLE_INFORMATION20
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, OLD_END_DATE OLD_END_DATE
FROM "HR"."PER_ROLES"