VIEW: HR.HR_LOCATION_EXTRA_INFO#

Source

View Text - Preformatted

select LOCATION_EXTRA_INFO_ID LOCATION_EXTRA_INFO_ID, INFORMATION_TYPE INFORMATION_TYPE, LOCATION_ID LOCATION_ID, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, LEI_ATTRIBUTE_CATEGORY LEI_ATTRIBUTE_CATEGORY, LEI_ATTRIBUTE1 LEI_ATTRIBUTE1, LEI_ATTRIBUTE2 LEI_ATTRIBUTE2, LEI_ATTRIBUTE3 LEI_ATTRIBUTE3, LEI_ATTRIBUTE4 LEI_ATTRIBUTE4, LEI_ATTRIBUTE5 LEI_ATTRIBUTE5, LEI_ATTRIBUTE6 LEI_ATTRIBUTE6, LEI_ATTRIBUTE7 LEI_ATTRIBUTE7, LEI_ATTRIBUTE8 LEI_ATTRIBUTE8, LEI_ATTRIBUTE9 LEI_ATTRIBUTE9, LEI_ATTRIBUTE10 LEI_ATTRIBUTE10, LEI_ATTRIBUTE11 LEI_ATTRIBUTE11, LEI_ATTRIBUTE12 LEI_ATTRIBUTE12, LEI_ATTRIBUTE13 LEI_ATTRIBUTE13, LEI_ATTRIBUTE14 LEI_ATTRIBUTE14, LEI_ATTRIBUTE15 LEI_ATTRIBUTE15, LEI_ATTRIBUTE16 LEI_ATTRIBUTE16, LEI_ATTRIBUTE17 LEI_ATTRIBUTE17, LEI_ATTRIBUTE18 LEI_ATTRIBUTE18, LEI_ATTRIBUTE19 LEI_ATTRIBUTE19, LEI_ATTRIBUTE20 LEI_ATTRIBUTE20, LEI_INFORMATION_CATEGORY LEI_INFORMATION_CATEGORY, LEI_INFORMATION1 LEI_INFORMATION1, LEI_INFORMATION2 LEI_INFORMATION2, LEI_INFORMATION3 LEI_INFORMATION3, LEI_INFORMATION4 LEI_INFORMATION4, LEI_INFORMATION5 LEI_INFORMATION5, LEI_INFORMATION6 LEI_INFORMATION6, LEI_INFORMATION7 LEI_INFORMATION7, LEI_INFORMATION8 LEI_INFORMATION8, LEI_INFORMATION9 LEI_INFORMATION9, LEI_INFORMATION10 LEI_INFORMATION10, LEI_INFORMATION11 LEI_INFORMATION11, LEI_INFORMATION12 LEI_INFORMATION12, LEI_INFORMATION13 LEI_INFORMATION13, LEI_INFORMATION14 LEI_INFORMATION14, LEI_INFORMATION15 LEI_INFORMATION15, LEI_INFORMATION16 LEI_INFORMATION16, LEI_INFORMATION17 LEI_INFORMATION17, LEI_INFORMATION18 LEI_INFORMATION18, LEI_INFORMATION19 LEI_INFORMATION19, LEI_INFORMATION20 LEI_INFORMATION20, LEI_INFORMATION21 LEI_INFORMATION21, LEI_INFORMATION22 LEI_INFORMATION22, LEI_INFORMATION23 LEI_INFORMATION23, LEI_INFORMATION24 LEI_INFORMATION24, LEI_INFORMATION25 LEI_INFORMATION25, LEI_INFORMATION26 LEI_INFORMATION26, LEI_INFORMATION27 LEI_INFORMATION27, LEI_INFORMATION28 LEI_INFORMATION28, LEI_INFORMATION29 LEI_INFORMATION29, LEI_INFORMATION30 LEI_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"."HR_LOCATION_EXTRA_INFO"

View Text - HTML Formatted

SELECT LOCATION_EXTRA_INFO_ID LOCATION_EXTRA_INFO_ID
, INFORMATION_TYPE INFORMATION_TYPE
, LOCATION_ID LOCATION_ID
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, LEI_ATTRIBUTE_CATEGORY LEI_ATTRIBUTE_CATEGORY
, LEI_ATTRIBUTE1 LEI_ATTRIBUTE1
, LEI_ATTRIBUTE2 LEI_ATTRIBUTE2
, LEI_ATTRIBUTE3 LEI_ATTRIBUTE3
, LEI_ATTRIBUTE4 LEI_ATTRIBUTE4
, LEI_ATTRIBUTE5 LEI_ATTRIBUTE5
, LEI_ATTRIBUTE6 LEI_ATTRIBUTE6
, LEI_ATTRIBUTE7 LEI_ATTRIBUTE7
, LEI_ATTRIBUTE8 LEI_ATTRIBUTE8
, LEI_ATTRIBUTE9 LEI_ATTRIBUTE9
, LEI_ATTRIBUTE10 LEI_ATTRIBUTE10
, LEI_ATTRIBUTE11 LEI_ATTRIBUTE11
, LEI_ATTRIBUTE12 LEI_ATTRIBUTE12
, LEI_ATTRIBUTE13 LEI_ATTRIBUTE13
, LEI_ATTRIBUTE14 LEI_ATTRIBUTE14
, LEI_ATTRIBUTE15 LEI_ATTRIBUTE15
, LEI_ATTRIBUTE16 LEI_ATTRIBUTE16
, LEI_ATTRIBUTE17 LEI_ATTRIBUTE17
, LEI_ATTRIBUTE18 LEI_ATTRIBUTE18
, LEI_ATTRIBUTE19 LEI_ATTRIBUTE19
, LEI_ATTRIBUTE20 LEI_ATTRIBUTE20
, LEI_INFORMATION_CATEGORY LEI_INFORMATION_CATEGORY
, LEI_INFORMATION1 LEI_INFORMATION1
, LEI_INFORMATION2 LEI_INFORMATION2
, LEI_INFORMATION3 LEI_INFORMATION3
, LEI_INFORMATION4 LEI_INFORMATION4
, LEI_INFORMATION5 LEI_INFORMATION5
, LEI_INFORMATION6 LEI_INFORMATION6
, LEI_INFORMATION7 LEI_INFORMATION7
, LEI_INFORMATION8 LEI_INFORMATION8
, LEI_INFORMATION9 LEI_INFORMATION9
, LEI_INFORMATION10 LEI_INFORMATION10
, LEI_INFORMATION11 LEI_INFORMATION11
, LEI_INFORMATION12 LEI_INFORMATION12
, LEI_INFORMATION13 LEI_INFORMATION13
, LEI_INFORMATION14 LEI_INFORMATION14
, LEI_INFORMATION15 LEI_INFORMATION15
, LEI_INFORMATION16 LEI_INFORMATION16
, LEI_INFORMATION17 LEI_INFORMATION17
, LEI_INFORMATION18 LEI_INFORMATION18
, LEI_INFORMATION19 LEI_INFORMATION19
, LEI_INFORMATION20 LEI_INFORMATION20
, LEI_INFORMATION21 LEI_INFORMATION21
, LEI_INFORMATION22 LEI_INFORMATION22
, LEI_INFORMATION23 LEI_INFORMATION23
, LEI_INFORMATION24 LEI_INFORMATION24
, LEI_INFORMATION25 LEI_INFORMATION25
, LEI_INFORMATION26 LEI_INFORMATION26
, LEI_INFORMATION27 LEI_INFORMATION27
, LEI_INFORMATION28 LEI_INFORMATION28
, LEI_INFORMATION29 LEI_INFORMATION29
, LEI_INFORMATION30 LEI_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"."HR_LOCATION_EXTRA_INFO"