VIEW: APPS.PER_QH_EIT_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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