VIEW: APPS.PQH_POSITION_EXTRA_INFO_V

Source

View Text - Preformatted

SELECT position_extra_info_id, position_id, information_type, request_id, program_application_id, program_id, program_update_date, poei_attribute_category attribute_category, poei_attribute1 attribute1, poei_attribute2 attribute2, poei_attribute3 attribute3, poei_attribute4 attribute4, poei_attribute5 attribute5, poei_attribute6 attribute6, poei_attribute7 attribute7, poei_attribute8 attribute8, poei_attribute9 attribute9, poei_attribute10 attribute10, poei_attribute11 attribute11, poei_attribute12 attribute12, poei_attribute13 attribute13, poei_attribute14 attribute14, poei_attribute15 attribute15, poei_attribute16 attribute16, poei_attribute17 attribute17, poei_attribute18 attribute18, poei_attribute19 attribute19, poei_attribute20 attribute20, poei_information_category information_category, poei_information1 information1, poei_information2 information2, poei_information3 information3, poei_information4 information4, poei_information5 information5, poei_information6 information6, poei_information7 information7, poei_information8 information8, poei_information9 information9, poei_information10 information10, poei_information11 information11, poei_information12 information12, poei_information13 information13, poei_information14 information14, poei_information15 information15, poei_information16 information16, poei_information17 information17, poei_information18 information18, poei_information19 information19, poei_information20 information20, poei_information21 information21, poei_information22 information22, poei_information23 information23, poei_information24 information24, poei_information25 information25, poei_information26 information26, poei_information27 information27, poei_information28 information28, poei_information29 information29, poei_information30 information30, object_version_number, last_update_date, last_updated_by, last_update_login, created_by, creation_date from per_position_extra_info

View Text - HTML Formatted

SELECT POSITION_EXTRA_INFO_ID
, POSITION_ID
, INFORMATION_TYPE
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, POEI_ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, POEI_ATTRIBUTE1 ATTRIBUTE1
, POEI_ATTRIBUTE2 ATTRIBUTE2
, POEI_ATTRIBUTE3 ATTRIBUTE3
, POEI_ATTRIBUTE4 ATTRIBUTE4
, POEI_ATTRIBUTE5 ATTRIBUTE5
, POEI_ATTRIBUTE6 ATTRIBUTE6
, POEI_ATTRIBUTE7 ATTRIBUTE7
, POEI_ATTRIBUTE8 ATTRIBUTE8
, POEI_ATTRIBUTE9 ATTRIBUTE9
, POEI_ATTRIBUTE10 ATTRIBUTE10
, POEI_ATTRIBUTE11 ATTRIBUTE11
, POEI_ATTRIBUTE12 ATTRIBUTE12
, POEI_ATTRIBUTE13 ATTRIBUTE13
, POEI_ATTRIBUTE14 ATTRIBUTE14
, POEI_ATTRIBUTE15 ATTRIBUTE15
, POEI_ATTRIBUTE16 ATTRIBUTE16
, POEI_ATTRIBUTE17 ATTRIBUTE17
, POEI_ATTRIBUTE18 ATTRIBUTE18
, POEI_ATTRIBUTE19 ATTRIBUTE19
, POEI_ATTRIBUTE20 ATTRIBUTE20
, POEI_INFORMATION_CATEGORY INFORMATION_CATEGORY
, POEI_INFORMATION1 INFORMATION1
, POEI_INFORMATION2 INFORMATION2
, POEI_INFORMATION3 INFORMATION3
, POEI_INFORMATION4 INFORMATION4
, POEI_INFORMATION5 INFORMATION5
, POEI_INFORMATION6 INFORMATION6
, POEI_INFORMATION7 INFORMATION7
, POEI_INFORMATION8 INFORMATION8
, POEI_INFORMATION9 INFORMATION9
, POEI_INFORMATION10 INFORMATION10
, POEI_INFORMATION11 INFORMATION11
, POEI_INFORMATION12 INFORMATION12
, POEI_INFORMATION13 INFORMATION13
, POEI_INFORMATION14 INFORMATION14
, POEI_INFORMATION15 INFORMATION15
, POEI_INFORMATION16 INFORMATION16
, POEI_INFORMATION17 INFORMATION17
, POEI_INFORMATION18 INFORMATION18
, POEI_INFORMATION19 INFORMATION19
, POEI_INFORMATION20 INFORMATION20
, POEI_INFORMATION21 INFORMATION21
, POEI_INFORMATION22 INFORMATION22
, POEI_INFORMATION23 INFORMATION23
, POEI_INFORMATION24 INFORMATION24
, POEI_INFORMATION25 INFORMATION25
, POEI_INFORMATION26 INFORMATION26
, POEI_INFORMATION27 INFORMATION27
, POEI_INFORMATION28 INFORMATION28
, POEI_INFORMATION29 INFORMATION29
, POEI_INFORMATION30 INFORMATION30
, OBJECT_VERSION_NUMBER
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATED_BY
, CREATION_DATE
FROM PER_POSITION_EXTRA_INFO