VIEW: HR.GHR_PA_REQUEST_EXTRA_INFO#

Source

View Text - Preformatted

select PA_REQUEST_EXTRA_INFO_ID PA_REQUEST_EXTRA_INFO_ID, PA_REQUEST_ID PA_REQUEST_ID, INFORMATION_TYPE INFORMATION_TYPE, REI_ATTRIBUTE_CATEGORY REI_ATTRIBUTE_CATEGORY, REI_ATTRIBUTE1 REI_ATTRIBUTE1, REI_ATTRIBUTE2 REI_ATTRIBUTE2, REI_ATTRIBUTE3 REI_ATTRIBUTE3, REI_ATTRIBUTE4 REI_ATTRIBUTE4, REI_ATTRIBUTE5 REI_ATTRIBUTE5, REI_ATTRIBUTE6 REI_ATTRIBUTE6, REI_ATTRIBUTE7 REI_ATTRIBUTE7, REI_ATTRIBUTE8 REI_ATTRIBUTE8, REI_ATTRIBUTE9 REI_ATTRIBUTE9, REI_ATTRIBUTE10 REI_ATTRIBUTE10, REI_ATTRIBUTE11 REI_ATTRIBUTE11, REI_ATTRIBUTE12 REI_ATTRIBUTE12, REI_ATTRIBUTE13 REI_ATTRIBUTE13, REI_ATTRIBUTE14 REI_ATTRIBUTE14, REI_ATTRIBUTE15 REI_ATTRIBUTE15, REI_ATTRIBUTE16 REI_ATTRIBUTE16, REI_ATTRIBUTE17 REI_ATTRIBUTE17, REI_ATTRIBUTE18 REI_ATTRIBUTE18, REI_ATTRIBUTE19 REI_ATTRIBUTE19, REI_ATTRIBUTE20 REI_ATTRIBUTE20, REI_INFORMATION_CATEGORY REI_INFORMATION_CATEGORY, REI_INFORMATION1 REI_INFORMATION1, REI_INFORMATION2 REI_INFORMATION2, REI_INFORMATION3 REI_INFORMATION3, REI_INFORMATION4 REI_INFORMATION4, REI_INFORMATION5 REI_INFORMATION5, REI_INFORMATION6 REI_INFORMATION6, REI_INFORMATION7 REI_INFORMATION7, REI_INFORMATION8 REI_INFORMATION8, REI_INFORMATION9 REI_INFORMATION9, REI_INFORMATION10 REI_INFORMATION10, REI_INFORMATION11 REI_INFORMATION11, REI_INFORMATION12 REI_INFORMATION12, REI_INFORMATION13 REI_INFORMATION13, REI_INFORMATION14 REI_INFORMATION14, REI_INFORMATION15 REI_INFORMATION15, REI_INFORMATION16 REI_INFORMATION16, REI_INFORMATION17 REI_INFORMATION17, REI_INFORMATION18 REI_INFORMATION18, REI_INFORMATION19 REI_INFORMATION19, REI_INFORMATION20 REI_INFORMATION20, REI_INFORMATION21 REI_INFORMATION21, REI_INFORMATION22 REI_INFORMATION22, REI_INFORMATION28 REI_INFORMATION28, REI_INFORMATION29 REI_INFORMATION29, REI_INFORMATION23 REI_INFORMATION23, REI_INFORMATION24 REI_INFORMATION24, REI_INFORMATION25 REI_INFORMATION25, REI_INFORMATION26 REI_INFORMATION26, REI_INFORMATION27 REI_INFORMATION27, REI_INFORMATION30 REI_INFORMATION30, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, 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 from "HR"."GHR_PA_REQUEST_EXTRA_INFO"

View Text - HTML Formatted

SELECT PA_REQUEST_EXTRA_INFO_ID PA_REQUEST_EXTRA_INFO_ID
, PA_REQUEST_ID PA_REQUEST_ID
, INFORMATION_TYPE INFORMATION_TYPE
, REI_ATTRIBUTE_CATEGORY REI_ATTRIBUTE_CATEGORY
, REI_ATTRIBUTE1 REI_ATTRIBUTE1
, REI_ATTRIBUTE2 REI_ATTRIBUTE2
, REI_ATTRIBUTE3 REI_ATTRIBUTE3
, REI_ATTRIBUTE4 REI_ATTRIBUTE4
, REI_ATTRIBUTE5 REI_ATTRIBUTE5
, REI_ATTRIBUTE6 REI_ATTRIBUTE6
, REI_ATTRIBUTE7 REI_ATTRIBUTE7
, REI_ATTRIBUTE8 REI_ATTRIBUTE8
, REI_ATTRIBUTE9 REI_ATTRIBUTE9
, REI_ATTRIBUTE10 REI_ATTRIBUTE10
, REI_ATTRIBUTE11 REI_ATTRIBUTE11
, REI_ATTRIBUTE12 REI_ATTRIBUTE12
, REI_ATTRIBUTE13 REI_ATTRIBUTE13
, REI_ATTRIBUTE14 REI_ATTRIBUTE14
, REI_ATTRIBUTE15 REI_ATTRIBUTE15
, REI_ATTRIBUTE16 REI_ATTRIBUTE16
, REI_ATTRIBUTE17 REI_ATTRIBUTE17
, REI_ATTRIBUTE18 REI_ATTRIBUTE18
, REI_ATTRIBUTE19 REI_ATTRIBUTE19
, REI_ATTRIBUTE20 REI_ATTRIBUTE20
, REI_INFORMATION_CATEGORY REI_INFORMATION_CATEGORY
, REI_INFORMATION1 REI_INFORMATION1
, REI_INFORMATION2 REI_INFORMATION2
, REI_INFORMATION3 REI_INFORMATION3
, REI_INFORMATION4 REI_INFORMATION4
, REI_INFORMATION5 REI_INFORMATION5
, REI_INFORMATION6 REI_INFORMATION6
, REI_INFORMATION7 REI_INFORMATION7
, REI_INFORMATION8 REI_INFORMATION8
, REI_INFORMATION9 REI_INFORMATION9
, REI_INFORMATION10 REI_INFORMATION10
, REI_INFORMATION11 REI_INFORMATION11
, REI_INFORMATION12 REI_INFORMATION12
, REI_INFORMATION13 REI_INFORMATION13
, REI_INFORMATION14 REI_INFORMATION14
, REI_INFORMATION15 REI_INFORMATION15
, REI_INFORMATION16 REI_INFORMATION16
, REI_INFORMATION17 REI_INFORMATION17
, REI_INFORMATION18 REI_INFORMATION18
, REI_INFORMATION19 REI_INFORMATION19
, REI_INFORMATION20 REI_INFORMATION20
, REI_INFORMATION21 REI_INFORMATION21
, REI_INFORMATION22 REI_INFORMATION22
, REI_INFORMATION28 REI_INFORMATION28
, REI_INFORMATION29 REI_INFORMATION29
, REI_INFORMATION23 REI_INFORMATION23
, REI_INFORMATION24 REI_INFORMATION24
, REI_INFORMATION25 REI_INFORMATION25
, REI_INFORMATION26 REI_INFORMATION26
, REI_INFORMATION27 REI_INFORMATION27
, REI_INFORMATION30 REI_INFORMATION30
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, 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
FROM "HR"."GHR_PA_REQUEST_EXTRA_INFO"