eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: PQH_POSITION_EXTRA_INFO_V

Product:	PQH - Public Sector HR
Description:
Implementation/DBA Data:	APPS.PQH_POSITION_EXTRA_INFO_V

View Text

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

Columns

Name
POSITION_EXTRA_INFO_ID
POSITION_ID
INFORMATION_TYPE
REQUEST_ID
PROGRAM_APPLICATION_ID
PROGRAM_ID
PROGRAM_UPDATE_DATE
ATTRIBUTE_CATEGORY
ATTRIBUTE1
ATTRIBUTE2
ATTRIBUTE3
ATTRIBUTE4
ATTRIBUTE5
ATTRIBUTE6
ATTRIBUTE7
ATTRIBUTE8
ATTRIBUTE9
ATTRIBUTE10
ATTRIBUTE11
ATTRIBUTE12
ATTRIBUTE13
ATTRIBUTE14
ATTRIBUTE15
ATTRIBUTE16
ATTRIBUTE17
ATTRIBUTE18
ATTRIBUTE19
ATTRIBUTE20
INFORMATION_CATEGORY
INFORMATION1
INFORMATION2
INFORMATION3
INFORMATION4
INFORMATION5
INFORMATION6
INFORMATION7
INFORMATION8
INFORMATION9
INFORMATION10
INFORMATION11
INFORMATION12
INFORMATION13
INFORMATION14
INFORMATION15
INFORMATION16
INFORMATION17
INFORMATION18
INFORMATION19
INFORMATION20
INFORMATION21
INFORMATION22
INFORMATION23
INFORMATION24
INFORMATION25
INFORMATION26
INFORMATION27
INFORMATION28
INFORMATION29
INFORMATION30
OBJECT_VERSION_NUMBER
LAST_UPDATE_DATE
LAST_UPDATED_BY
LAST_UPDATE_LOGIN
CREATED_BY
CREATION_DATE