VIEW: HR.PER_JOBS#

Source

View Text - Preformatted

select JOB_ID JOB_ID, BUSINESS_GROUP_ID BUSINESS_GROUP_ID, JOB_DEFINITION_ID JOB_DEFINITION_ID, DATE_FROM DATE_FROM, DATE_TO DATE_TO, NAME NAME, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, 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, 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, JOB_INFORMATION_CATEGORY JOB_INFORMATION_CATEGORY, JOB_INFORMATION1 JOB_INFORMATION1, JOB_INFORMATION2 JOB_INFORMATION2, JOB_INFORMATION3 JOB_INFORMATION3, JOB_INFORMATION4 JOB_INFORMATION4, JOB_INFORMATION5 JOB_INFORMATION5, JOB_INFORMATION6 JOB_INFORMATION6, JOB_INFORMATION7 JOB_INFORMATION7, JOB_INFORMATION8 JOB_INFORMATION8, JOB_INFORMATION9 JOB_INFORMATION9, JOB_INFORMATION10 JOB_INFORMATION10, JOB_INFORMATION11 JOB_INFORMATION11, JOB_INFORMATION12 JOB_INFORMATION12, JOB_INFORMATION13 JOB_INFORMATION13, JOB_INFORMATION14 JOB_INFORMATION14, JOB_INFORMATION15 JOB_INFORMATION15, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, JOB_INFORMATION16 JOB_INFORMATION16, JOB_INFORMATION17 JOB_INFORMATION17, JOB_INFORMATION18 JOB_INFORMATION18, JOB_INFORMATION19 JOB_INFORMATION19, JOB_INFORMATION20 JOB_INFORMATION20, BENCHMARK_JOB_FLAG BENCHMARK_JOB_FLAG, BENCHMARK_JOB_ID BENCHMARK_JOB_ID, EMP_RIGHTS_FLAG EMP_RIGHTS_FLAG, JOB_GROUP_ID JOB_GROUP_ID, APPROVAL_AUTHORITY APPROVAL_AUTHORITY, COMMENTS COMMENTS from "HR"."PER_JOBS"

View Text - HTML Formatted

SELECT JOB_ID JOB_ID
, BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, JOB_DEFINITION_ID JOB_DEFINITION_ID
, DATE_FROM DATE_FROM
, DATE_TO DATE_TO
, NAME NAME
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, 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
, 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
, JOB_INFORMATION_CATEGORY JOB_INFORMATION_CATEGORY
, JOB_INFORMATION1 JOB_INFORMATION1
, JOB_INFORMATION2 JOB_INFORMATION2
, JOB_INFORMATION3 JOB_INFORMATION3
, JOB_INFORMATION4 JOB_INFORMATION4
, JOB_INFORMATION5 JOB_INFORMATION5
, JOB_INFORMATION6 JOB_INFORMATION6
, JOB_INFORMATION7 JOB_INFORMATION7
, JOB_INFORMATION8 JOB_INFORMATION8
, JOB_INFORMATION9 JOB_INFORMATION9
, JOB_INFORMATION10 JOB_INFORMATION10
, JOB_INFORMATION11 JOB_INFORMATION11
, JOB_INFORMATION12 JOB_INFORMATION12
, JOB_INFORMATION13 JOB_INFORMATION13
, JOB_INFORMATION14 JOB_INFORMATION14
, JOB_INFORMATION15 JOB_INFORMATION15
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, JOB_INFORMATION16 JOB_INFORMATION16
, JOB_INFORMATION17 JOB_INFORMATION17
, JOB_INFORMATION18 JOB_INFORMATION18
, JOB_INFORMATION19 JOB_INFORMATION19
, JOB_INFORMATION20 JOB_INFORMATION20
, BENCHMARK_JOB_FLAG BENCHMARK_JOB_FLAG
, BENCHMARK_JOB_ID BENCHMARK_JOB_ID
, EMP_RIGHTS_FLAG EMP_RIGHTS_FLAG
, JOB_GROUP_ID JOB_GROUP_ID
, APPROVAL_AUTHORITY APPROVAL_AUTHORITY
, COMMENTS COMMENTS
FROM "HR"."PER_JOBS"