VIEW: HR.PAY_ELEMENT_TYPE_EXTRA_INFO#

Source

View Text - Preformatted

select ELEMENT_TYPE_EXTRA_INFO_ID ELEMENT_TYPE_EXTRA_INFO_ID, ELEMENT_TYPE_ID ELEMENT_TYPE_ID, INFORMATION_TYPE INFORMATION_TYPE, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, EEI_ATTRIBUTE_CATEGORY EEI_ATTRIBUTE_CATEGORY, EEI_ATTRIBUTE1 EEI_ATTRIBUTE1, EEI_ATTRIBUTE2 EEI_ATTRIBUTE2, EEI_ATTRIBUTE3 EEI_ATTRIBUTE3, EEI_ATTRIBUTE4 EEI_ATTRIBUTE4, EEI_ATTRIBUTE5 EEI_ATTRIBUTE5, EEI_ATTRIBUTE6 EEI_ATTRIBUTE6, EEI_ATTRIBUTE7 EEI_ATTRIBUTE7, EEI_ATTRIBUTE8 EEI_ATTRIBUTE8, EEI_ATTRIBUTE9 EEI_ATTRIBUTE9, EEI_ATTRIBUTE10 EEI_ATTRIBUTE10, EEI_ATTRIBUTE11 EEI_ATTRIBUTE11, EEI_ATTRIBUTE12 EEI_ATTRIBUTE12, EEI_ATTRIBUTE13 EEI_ATTRIBUTE13, EEI_ATTRIBUTE14 EEI_ATTRIBUTE14, EEI_ATTRIBUTE15 EEI_ATTRIBUTE15, EEI_ATTRIBUTE16 EEI_ATTRIBUTE16, EEI_ATTRIBUTE17 EEI_ATTRIBUTE17, EEI_ATTRIBUTE18 EEI_ATTRIBUTE18, EEI_ATTRIBUTE19 EEI_ATTRIBUTE19, EEI_ATTRIBUTE20 EEI_ATTRIBUTE20, EEI_INFORMATION_CATEGORY EEI_INFORMATION_CATEGORY, EEI_INFORMATION1 EEI_INFORMATION1, EEI_INFORMATION2 EEI_INFORMATION2, EEI_INFORMATION3 EEI_INFORMATION3, EEI_INFORMATION4 EEI_INFORMATION4, EEI_INFORMATION5 EEI_INFORMATION5, EEI_INFORMATION6 EEI_INFORMATION6, EEI_INFORMATION7 EEI_INFORMATION7, EEI_INFORMATION8 EEI_INFORMATION8, EEI_INFORMATION9 EEI_INFORMATION9, EEI_INFORMATION10 EEI_INFORMATION10, EEI_INFORMATION11 EEI_INFORMATION11, EEI_INFORMATION12 EEI_INFORMATION12, EEI_INFORMATION13 EEI_INFORMATION13, EEI_INFORMATION14 EEI_INFORMATION14, EEI_INFORMATION15 EEI_INFORMATION15, EEI_INFORMATION16 EEI_INFORMATION16, EEI_INFORMATION17 EEI_INFORMATION17, EEI_INFORMATION18 EEI_INFORMATION18, EEI_INFORMATION19 EEI_INFORMATION19, EEI_INFORMATION20 EEI_INFORMATION20, EEI_INFORMATION21 EEI_INFORMATION21, EEI_INFORMATION22 EEI_INFORMATION22, EEI_INFORMATION23 EEI_INFORMATION23, EEI_INFORMATION24 EEI_INFORMATION24, EEI_INFORMATION25 EEI_INFORMATION25, EEI_INFORMATION26 EEI_INFORMATION26, EEI_INFORMATION27 EEI_INFORMATION27, EEI_INFORMATION28 EEI_INFORMATION28, EEI_INFORMATION29 EEI_INFORMATION29, EEI_INFORMATION30 EEI_INFORMATION30, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, 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"."PAY_ELEMENT_TYPE_EXTRA_INFO"

View Text - HTML Formatted

SELECT ELEMENT_TYPE_EXTRA_INFO_ID ELEMENT_TYPE_EXTRA_INFO_ID
, ELEMENT_TYPE_ID ELEMENT_TYPE_ID
, INFORMATION_TYPE INFORMATION_TYPE
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, EEI_ATTRIBUTE_CATEGORY EEI_ATTRIBUTE_CATEGORY
, EEI_ATTRIBUTE1 EEI_ATTRIBUTE1
, EEI_ATTRIBUTE2 EEI_ATTRIBUTE2
, EEI_ATTRIBUTE3 EEI_ATTRIBUTE3
, EEI_ATTRIBUTE4 EEI_ATTRIBUTE4
, EEI_ATTRIBUTE5 EEI_ATTRIBUTE5
, EEI_ATTRIBUTE6 EEI_ATTRIBUTE6
, EEI_ATTRIBUTE7 EEI_ATTRIBUTE7
, EEI_ATTRIBUTE8 EEI_ATTRIBUTE8
, EEI_ATTRIBUTE9 EEI_ATTRIBUTE9
, EEI_ATTRIBUTE10 EEI_ATTRIBUTE10
, EEI_ATTRIBUTE11 EEI_ATTRIBUTE11
, EEI_ATTRIBUTE12 EEI_ATTRIBUTE12
, EEI_ATTRIBUTE13 EEI_ATTRIBUTE13
, EEI_ATTRIBUTE14 EEI_ATTRIBUTE14
, EEI_ATTRIBUTE15 EEI_ATTRIBUTE15
, EEI_ATTRIBUTE16 EEI_ATTRIBUTE16
, EEI_ATTRIBUTE17 EEI_ATTRIBUTE17
, EEI_ATTRIBUTE18 EEI_ATTRIBUTE18
, EEI_ATTRIBUTE19 EEI_ATTRIBUTE19
, EEI_ATTRIBUTE20 EEI_ATTRIBUTE20
, EEI_INFORMATION_CATEGORY EEI_INFORMATION_CATEGORY
, EEI_INFORMATION1 EEI_INFORMATION1
, EEI_INFORMATION2 EEI_INFORMATION2
, EEI_INFORMATION3 EEI_INFORMATION3
, EEI_INFORMATION4 EEI_INFORMATION4
, EEI_INFORMATION5 EEI_INFORMATION5
, EEI_INFORMATION6 EEI_INFORMATION6
, EEI_INFORMATION7 EEI_INFORMATION7
, EEI_INFORMATION8 EEI_INFORMATION8
, EEI_INFORMATION9 EEI_INFORMATION9
, EEI_INFORMATION10 EEI_INFORMATION10
, EEI_INFORMATION11 EEI_INFORMATION11
, EEI_INFORMATION12 EEI_INFORMATION12
, EEI_INFORMATION13 EEI_INFORMATION13
, EEI_INFORMATION14 EEI_INFORMATION14
, EEI_INFORMATION15 EEI_INFORMATION15
, EEI_INFORMATION16 EEI_INFORMATION16
, EEI_INFORMATION17 EEI_INFORMATION17
, EEI_INFORMATION18 EEI_INFORMATION18
, EEI_INFORMATION19 EEI_INFORMATION19
, EEI_INFORMATION20 EEI_INFORMATION20
, EEI_INFORMATION21 EEI_INFORMATION21
, EEI_INFORMATION22 EEI_INFORMATION22
, EEI_INFORMATION23 EEI_INFORMATION23
, EEI_INFORMATION24 EEI_INFORMATION24
, EEI_INFORMATION25 EEI_INFORMATION25
, EEI_INFORMATION26 EEI_INFORMATION26
, EEI_INFORMATION27 EEI_INFORMATION27
, EEI_INFORMATION28 EEI_INFORMATION28
, EEI_INFORMATION29 EEI_INFORMATION29
, EEI_INFORMATION30 EEI_INFORMATION30
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, 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"."PAY_ELEMENT_TYPE_EXTRA_INFO"