VIEW: APPS.GHR_MT_POSITION_EI_V

Source

View Text - Preformatted

SELECT INTERFACE_ID GHR_INTERFACE_ID , PROCESS_DATE MT_PROCESS_DATE , SOURCE_NAME MT_SOURCE , DATE_FROM MT_EFFECTIVE_DATE , INFORMATION1 MT_NAME , INFORMATION2 MT_STATUS , INFORMATION3 MT_PERSON_ID , INFORMATION4 MT_TABLE_NAME , INFORMATION5 MT_INFORMATION_TYPE , INFORMATION6 MT_INTER_BG_TRANSFER , INFORMATION7 POSITION_EXTRA_INFO_ID , INFORMATION8 POSITION_ID , INFORMATION9 INFORMATION_TYPE , INFORMATION10 REQUEST_ID , INFORMATION11 PROGRAM_APPLICATION_ID , INFORMATION12 PROGRAM_ID , INFORMATION13 PROGRAM_UPDATE_DATE , INFORMATION14 POEI_ATTRIBUTE_CATEGORY , INFORMATION15 POEI_ATTRIBUTE1 , INFORMATION16 POEI_ATTRIBUTE2 , INFORMATION17 POEI_ATTRIBUTE3 , INFORMATION18 POEI_ATTRIBUTE4 , INFORMATION19 POEI_ATTRIBUTE5 , INFORMATION20 POEI_ATTRIBUTE6 , INFORMATION21 POEI_ATTRIBUTE7 , INFORMATION22 POEI_ATTRIBUTE8 , INFORMATION23 POEI_ATTRIBUTE9 , INFORMATION24 POEI_ATTRIBUTE10 , INFORMATION25 POEI_ATTRIBUTE11 , INFORMATION26 POEI_ATTRIBUTE12 , INFORMATION27 POEI_ATTRIBUTE13 , INFORMATION28 POEI_ATTRIBUTE14, INFORMATION29 POEI_ATTRIBUTE15 , INFORMATION30 POEI_ATTRIBUTE16 , INFORMATION31 POEI_ATTRIBUTE17 , INFORMATION32 POEI_ATTRIBUTE18 , INFORMATION33 POEI_ATTRIBUTE19 , INFORMATION34 POEI_ATTRIBUTE20 , INFORMATION35 POEI_INFORMATION_CATEGORY , INFORMATION36 POEI_INFORMATION1 , INFORMATION37 POEI_INFORMATION2 , INFORMATION38 POEI_INFORMATION3 , INFORMATION39 POEI_INFORMATION4 , INFORMATION40 POEI_INFORMATION5 , INFORMATION41 POEI_INFORMATION6 , INFORMATION42 POEI_INFORMATION7 , INFORMATION43 POEI_INFORMATION8 , INFORMATION44 POEI_INFORMATION9 , INFORMATION45 POEI_INFORMATION10 , INFORMATION46 POEI_INFORMATION11 , INFORMATION47 POEI_INFORMATION12 , INFORMATION48 POEI_INFORMATION13 , INFORMATION49 POEI_INFORMATION14 , INFORMATION50 POEI_INFORMATION15 , INFORMATION51 POEI_INFORMATION16 , INFORMATION52 POEI_INFORMATION17 , INFORMATION53 POEI_INFORMATION18 , INFORMATION54 POEI_INFORMATION19 , INFORMATION55 POEI_INFORMATION20 , INFORMATION56 POEI_INFORMATION21 , INFORMATION57 POEI_INFORMATION22, INFORMATION58 POEI_INFORMATION23 , INFORMATION59 POEI_INFORMATION24 , INFORMATION60 POEI_INFORMATION25 , INFORMATION61 POEI_INFORMATION26 , INFORMATION62 POEI_INFORMATION27 , INFORMATION63 POEI_INFORMATION28 , INFORMATION64 POEI_INFORMATION29 , INFORMATION65 POEI_INFORMATION30 , INFORMATION66 OBJECT_VERSION_NUMBER , INFORMATION67 LAST_UPDATE_DATE , INFORMATION68 LAST_UPDATED_BY , INFORMATION69 LAST_UPDATE_LOGIN , INFORMATION70 CREATED_BY , INFORMATION71 CREATION_DATE , INFORMATION75 INFO3_MEANING , INFORMATION76 INFO4_MEANING , INFORMATION77 INFO5_MEANING , INFORMATION78 INFO6_MEANING , INFORMATION79 INFO7_MEANING , INFORMATION80 INFO8_MEANING , INFORMATION81 INFO9_MEANING , INFORMATION82 INFO10_MEANING , INFORMATION83 INFO11_MEANING , INFORMATION84 INFO12_MEANING , INFORMATION85 INFO13_MEANING , INFORMATION86 INFO14_MEANING , INFORMATION87 INFO15_MEANING , INFORMATION88 INFO16_MEANING , INFORMATION89 INFO17_MEANING , INFORMATION90 INFO18_MEANING , INFORMATION91 INFO19_MEANING , INFORMATION92 INFO20_MEANING, INFORMATION93 INFO21_MEANING , INFORMATION94 INFO22_MEANING , INFORMATION95 INFO23_MEANING , INFORMATION96 INFO24_MEANING , INFORMATION97 INFO25_MEANING , INFORMATION98 INFO26_MEANING , INFORMATION99 INFO27_MEANING , INFORMATION100 INFO28_MEANING , INFORMATION101 INFO29_MEANING , INFORMATION102 INFO30_MEANING , INFORMATION103 INFO31_MEANING , INFORMATION104 INFO32_MEANING FROM GHR_INTERFACE WHERE INFORMATION4 = 'PER_POSITION_EXTRA_INFO'

View Text - HTML Formatted

SELECT INTERFACE_ID GHR_INTERFACE_ID
, PROCESS_DATE MT_PROCESS_DATE
, SOURCE_NAME MT_SOURCE
, DATE_FROM MT_EFFECTIVE_DATE
, INFORMATION1 MT_NAME
, INFORMATION2 MT_STATUS
, INFORMATION3 MT_PERSON_ID
, INFORMATION4 MT_TABLE_NAME
, INFORMATION5 MT_INFORMATION_TYPE
, INFORMATION6 MT_INTER_BG_TRANSFER
, INFORMATION7 POSITION_EXTRA_INFO_ID
, INFORMATION8 POSITION_ID
, INFORMATION9 INFORMATION_TYPE
, INFORMATION10 REQUEST_ID
, INFORMATION11 PROGRAM_APPLICATION_ID
, INFORMATION12 PROGRAM_ID
, INFORMATION13 PROGRAM_UPDATE_DATE
, INFORMATION14 POEI_ATTRIBUTE_CATEGORY
, INFORMATION15 POEI_ATTRIBUTE1
, INFORMATION16 POEI_ATTRIBUTE2
, INFORMATION17 POEI_ATTRIBUTE3
, INFORMATION18 POEI_ATTRIBUTE4
, INFORMATION19 POEI_ATTRIBUTE5
, INFORMATION20 POEI_ATTRIBUTE6
, INFORMATION21 POEI_ATTRIBUTE7
, INFORMATION22 POEI_ATTRIBUTE8
, INFORMATION23 POEI_ATTRIBUTE9
, INFORMATION24 POEI_ATTRIBUTE10
, INFORMATION25 POEI_ATTRIBUTE11
, INFORMATION26 POEI_ATTRIBUTE12
, INFORMATION27 POEI_ATTRIBUTE13
, INFORMATION28 POEI_ATTRIBUTE14
, INFORMATION29 POEI_ATTRIBUTE15
, INFORMATION30 POEI_ATTRIBUTE16
, INFORMATION31 POEI_ATTRIBUTE17
, INFORMATION32 POEI_ATTRIBUTE18
, INFORMATION33 POEI_ATTRIBUTE19
, INFORMATION34 POEI_ATTRIBUTE20
, INFORMATION35 POEI_INFORMATION_CATEGORY
, INFORMATION36 POEI_INFORMATION1
, INFORMATION37 POEI_INFORMATION2
, INFORMATION38 POEI_INFORMATION3
, INFORMATION39 POEI_INFORMATION4
, INFORMATION40 POEI_INFORMATION5
, INFORMATION41 POEI_INFORMATION6
, INFORMATION42 POEI_INFORMATION7
, INFORMATION43 POEI_INFORMATION8
, INFORMATION44 POEI_INFORMATION9
, INFORMATION45 POEI_INFORMATION10
, INFORMATION46 POEI_INFORMATION11
, INFORMATION47 POEI_INFORMATION12
, INFORMATION48 POEI_INFORMATION13
, INFORMATION49 POEI_INFORMATION14
, INFORMATION50 POEI_INFORMATION15
, INFORMATION51 POEI_INFORMATION16
, INFORMATION52 POEI_INFORMATION17
, INFORMATION53 POEI_INFORMATION18
, INFORMATION54 POEI_INFORMATION19
, INFORMATION55 POEI_INFORMATION20
, INFORMATION56 POEI_INFORMATION21
, INFORMATION57 POEI_INFORMATION22
, INFORMATION58 POEI_INFORMATION23
, INFORMATION59 POEI_INFORMATION24
, INFORMATION60 POEI_INFORMATION25
, INFORMATION61 POEI_INFORMATION26
, INFORMATION62 POEI_INFORMATION27
, INFORMATION63 POEI_INFORMATION28
, INFORMATION64 POEI_INFORMATION29
, INFORMATION65 POEI_INFORMATION30
, INFORMATION66 OBJECT_VERSION_NUMBER
, INFORMATION67 LAST_UPDATE_DATE
, INFORMATION68 LAST_UPDATED_BY
, INFORMATION69 LAST_UPDATE_LOGIN
, INFORMATION70 CREATED_BY
, INFORMATION71 CREATION_DATE
, INFORMATION75 INFO3_MEANING
, INFORMATION76 INFO4_MEANING
, INFORMATION77 INFO5_MEANING
, INFORMATION78 INFO6_MEANING
, INFORMATION79 INFO7_MEANING
, INFORMATION80 INFO8_MEANING
, INFORMATION81 INFO9_MEANING
, INFORMATION82 INFO10_MEANING
, INFORMATION83 INFO11_MEANING
, INFORMATION84 INFO12_MEANING
, INFORMATION85 INFO13_MEANING
, INFORMATION86 INFO14_MEANING
, INFORMATION87 INFO15_MEANING
, INFORMATION88 INFO16_MEANING
, INFORMATION89 INFO17_MEANING
, INFORMATION90 INFO18_MEANING
, INFORMATION91 INFO19_MEANING
, INFORMATION92 INFO20_MEANING
, INFORMATION93 INFO21_MEANING
, INFORMATION94 INFO22_MEANING
, INFORMATION95 INFO23_MEANING
, INFORMATION96 INFO24_MEANING
, INFORMATION97 INFO25_MEANING
, INFORMATION98 INFO26_MEANING
, INFORMATION99 INFO27_MEANING
, INFORMATION100 INFO28_MEANING
, INFORMATION101 INFO29_MEANING
, INFORMATION102 INFO30_MEANING
, INFORMATION103 INFO31_MEANING
, INFORMATION104 INFO32_MEANING
FROM GHR_INTERFACE
WHERE INFORMATION4 = 'PER_POSITION_EXTRA_INFO'