VIEW: APPS.PER_PREV_JOB_EXTRA_INFO_V

Source

View Text - Preformatted

SELECT PREVIOUS_JOB_EXTRA_INFO_ID ,PREVIOUS_JOB_ID ,INFORMATION_TYPE ,PJI_ATTRIBUTE_CATEGORY ,PJI_ATTRIBUTE1 ,PJI_ATTRIBUTE2 ,PJI_ATTRIBUTE3 ,PJI_ATTRIBUTE4 ,PJI_ATTRIBUTE5 ,PJI_ATTRIBUTE6 ,PJI_ATTRIBUTE7 ,PJI_ATTRIBUTE8 ,PJI_ATTRIBUTE9 ,PJI_ATTRIBUTE10 ,PJI_ATTRIBUTE11 ,PJI_ATTRIBUTE12 ,PJI_ATTRIBUTE13 ,PJI_ATTRIBUTE14 ,PJI_ATTRIBUTE15 ,PJI_ATTRIBUTE16 ,PJI_ATTRIBUTE17 ,PJI_ATTRIBUTE18 ,PJI_ATTRIBUTE19 ,PJI_ATTRIBUTE20 ,PJI_ATTRIBUTE21 ,PJI_ATTRIBUTE22 ,PJI_ATTRIBUTE23 ,PJI_ATTRIBUTE24 ,PJI_ATTRIBUTE25 ,PJI_ATTRIBUTE26 ,PJI_ATTRIBUTE27 ,PJI_ATTRIBUTE28 ,PJI_ATTRIBUTE29 ,PJI_ATTRIBUTE30 ,PJI_INFORMATION_CATEGORY ,PJI_INFORMATION1 ,PJI_INFORMATION2 ,PJI_INFORMATION3 ,PJI_INFORMATION4 ,PJI_INFORMATION5 ,PJI_INFORMATION6 ,PJI_INFORMATION7 ,PJI_INFORMATION8 ,PJI_INFORMATION9 ,PJI_INFORMATION10 ,PJI_INFORMATION11 ,PJI_INFORMATION12 ,PJI_INFORMATION13 ,PJI_INFORMATION14 ,PJI_INFORMATION15 ,PJI_INFORMATION16 ,PJI_INFORMATION17 ,PJI_INFORMATION18 ,PJI_INFORMATION19 ,PJI_INFORMATION20 ,PJI_INFORMATION21 ,PJI_INFORMATION22 ,PJI_INFORMATION23 ,PJI_INFORMATION24 ,PJI_INFORMATION25 ,PJI_INFORMATION26 ,PJI_INFORMATION27 ,PJI_INFORMATION28 ,PJI_INFORMATION29 ,PJI_INFORMATION30 ,OBJECT_VERSION_NUMBER ,LAST_UPDATE_DATE ,LAST_UPDATED_BY ,LAST_UPDATE_LOGIN ,CREATED_BY ,CREATION_DATE from per_prev_job_extra_info

View Text - HTML Formatted

SELECT PREVIOUS_JOB_EXTRA_INFO_ID
, PREVIOUS_JOB_ID
, INFORMATION_TYPE
, PJI_ATTRIBUTE_CATEGORY
, PJI_ATTRIBUTE1
, PJI_ATTRIBUTE2
, PJI_ATTRIBUTE3
, PJI_ATTRIBUTE4
, PJI_ATTRIBUTE5
, PJI_ATTRIBUTE6
, PJI_ATTRIBUTE7
, PJI_ATTRIBUTE8
, PJI_ATTRIBUTE9
, PJI_ATTRIBUTE10
, PJI_ATTRIBUTE11
, PJI_ATTRIBUTE12
, PJI_ATTRIBUTE13
, PJI_ATTRIBUTE14
, PJI_ATTRIBUTE15
, PJI_ATTRIBUTE16
, PJI_ATTRIBUTE17
, PJI_ATTRIBUTE18
, PJI_ATTRIBUTE19
, PJI_ATTRIBUTE20
, PJI_ATTRIBUTE21
, PJI_ATTRIBUTE22
, PJI_ATTRIBUTE23
, PJI_ATTRIBUTE24
, PJI_ATTRIBUTE25
, PJI_ATTRIBUTE26
, PJI_ATTRIBUTE27
, PJI_ATTRIBUTE28
, PJI_ATTRIBUTE29
, PJI_ATTRIBUTE30
, PJI_INFORMATION_CATEGORY
, PJI_INFORMATION1
, PJI_INFORMATION2
, PJI_INFORMATION3
, PJI_INFORMATION4
, PJI_INFORMATION5
, PJI_INFORMATION6
, PJI_INFORMATION7
, PJI_INFORMATION8
, PJI_INFORMATION9
, PJI_INFORMATION10
, PJI_INFORMATION11
, PJI_INFORMATION12
, PJI_INFORMATION13
, PJI_INFORMATION14
, PJI_INFORMATION15
, PJI_INFORMATION16
, PJI_INFORMATION17
, PJI_INFORMATION18
, PJI_INFORMATION19
, PJI_INFORMATION20
, PJI_INFORMATION21
, PJI_INFORMATION22
, PJI_INFORMATION23
, PJI_INFORMATION24
, PJI_INFORMATION25
, PJI_INFORMATION26
, PJI_INFORMATION27
, PJI_INFORMATION28
, PJI_INFORMATION29
, PJI_INFORMATION30
, OBJECT_VERSION_NUMBER
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATED_BY
, CREATION_DATE
FROM PER_PREV_JOB_EXTRA_INFO