View: PER_QH_EIT_V

Product:	PER - Human Resources
Description:	View of person and assignment extra information used by People Management form
Implementation/DBA Data:	APPS.PER_QH_EIT_V

View Text

SELECT PERSON_EXTRA_INFO_ID
, PERSON_ID
, INFORMATION_TYPE
, OBJECT_VERSION_NUMBER
, TO_NUMBER(NULL) ASSIGNMENT_EXTRA_INFO_ID
, TO_NUMBER(NULL) ASSIGNMENT_ID
, PEI_INFORMATION_CATEGORY
, PEI_INFORMATION1
, PEI_INFORMATION2
, PEI_INFORMATION3
, PEI_INFORMATION4
, PEI_INFORMATION5
, PEI_INFORMATION6
, PEI_INFORMATION7
, PEI_INFORMATION8
, PEI_INFORMATION9
, PEI_INFORMATION10
, PEI_INFORMATION11
, PEI_INFORMATION12
, PEI_INFORMATION13
, PEI_INFORMATION14
, PEI_INFORMATION15
, PEI_INFORMATION16
, PEI_INFORMATION17
, PEI_INFORMATION18
, PEI_INFORMATION19
, PEI_INFORMATION20
, PEI_INFORMATION21
, PEI_INFORMATION22
, PEI_INFORMATION23
, PEI_INFORMATION24
, PEI_INFORMATION25
, PEI_INFORMATION26
, PEI_INFORMATION27
, PEI_INFORMATION28
, PEI_INFORMATION29
, PEI_INFORMATION30
, '' AEI_INFORMATION_CATEGORY
, '' AEI_INFORMATION1
, '' AEI_INFORMATION2
, '' AEI_INFORMATION3
, '' AEI_INFORMATION4
, '' AEI_INFORMATION5
, '' AEI_INFORMATION6
, '' AEI_INFORMATION7
, '' AEI_INFORMATION8
, '' AEI_INFORMATION9
, '' AEI_INFORMATION10
, '' AEI_INFORMATION11
, '' AEI_INFORMATION12
, '' AEI_INFORMATION13
, '' AEI_INFORMATION14
, '' AEI_INFORMATION15
, '' AEI_INFORMATION16
, '' AEI_INFORMATION17
, '' AEI_INFORMATION18
, '' AEI_INFORMATION19
, '' AEI_INFORMATION20
, '' AEI_INFORMATION21
, '' AEI_INFORMATION22
, '' AEI_INFORMATION23
, '' AEI_INFORMATION24
, '' AEI_INFORMATION25
, '' AEI_INFORMATION26
, '' AEI_INFORMATION27
, '' AEI_INFORMATION28
, '' AEI_INFORMATION29
, '' AEI_INFORMATION30
FROM PER_PEOPLE_EXTRA_INFO UNION SELECT TO_NUMBER(NULL) PERSON_EXTRA_INFO_ID
, TO_NUMBER(NULL) PERSON_ID
, INFORMATION_TYPE
, OBJECT_VERSION_NUMBER
, ASSIGNMENT_EXTRA_INFO_ID
, ASSIGNMENT_ID
, '' PEI_INFORMATION_CATEGORY
, '' PEI_INFORMATION1
, '' PEI_INFORMATION2
, '' PEI_INFORMATION3
, '' PEI_INFORMATION4
, '' PEI_INFORMATION5
, '' PEI_INFORMATION6
, '' PEI_INFORMATION7
, '' PEI_INFORMATION8
, '' PEI_INFORMATION9
, '' PEI_INFORMATION10
, '' PEI_INFORMATION11
, '' PEI_INFORMATION12
, '' PEI_INFORMATION13
, '' PEI_INFORMATION14
, '' PEI_INFORMATION15
, '' PEI_INFORMATION16
, '' PEI_INFORMATION17
, '' PEI_INFORMATION18
, '' PEI_INFORMATION19
, '' PEI_INFORMATION20
, '' PEI_INFORMATION21
, '' PEI_INFORMATION22
, '' PEI_INFORMATION23
, '' PEI_INFORMATION24
, '' PEI_INFORMATION25
, '' PEI_INFORMATION26
, '' PEI_INFORMATION27
, '' PEI_INFORMATION28
, '' PEI_INFORMATION29
, '' PEI_INFORMATION30
, AEI_INFORMATION_CATEGORY
, AEI_INFORMATION1
, AEI_INFORMATION2
, AEI_INFORMATION3
, AEI_INFORMATION4
, AEI_INFORMATION5
, AEI_INFORMATION6
, AEI_INFORMATION7
, AEI_INFORMATION8
, AEI_INFORMATION9
, AEI_INFORMATION10
, AEI_INFORMATION11
, AEI_INFORMATION12
, AEI_INFORMATION13
, AEI_INFORMATION14
, AEI_INFORMATION15
, AEI_INFORMATION16
, AEI_INFORMATION17
, AEI_INFORMATION18
, AEI_INFORMATION19
, AEI_INFORMATION20
, AEI_INFORMATION21
, AEI_INFORMATION22
, AEI_INFORMATION23
, AEI_INFORMATION24
, AEI_INFORMATION25
, AEI_INFORMATION26
, AEI_INFORMATION27
, AEI_INFORMATION28
, AEI_INFORMATION29
, AEI_INFORMATION30
FROM PER_ASSIGNMENT_EXTRA_INFO

Columns