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.

VIEW: APPS.GHR_POSITION_EXTRA_INFO_H_V

Source

View Text - Preformatted


SELECT PA_HISTORY_ID , PROCESS_DATE , EFFECTIVE_DATE , DML_OPERATION , PRE_VALUES_FLAG , ALTERED_PA_REQUEST_ID , PA_REQUEST_ID , NATURE_OF_ACTION_ID , GHR_GENERAL.RETURN_NUMBER(INFORMATION1) POSITION_EXTRA_INFO_ID , GHR_GENERAL.RETURN_NUMBER(INFORMATION4) POSITION_ID , SUBSTR(INFORMATION5,1,40) INFORMATION_TYPE , SUBSTR(INFORMATION6,1,30) POEI_INFORMATION_CATEGORY , SUBSTR(INFORMATION7,1,150) POEI_INFORMATION1 , SUBSTR(INFORMATION8,1,150) POEI_INFORMATION2 , SUBSTR(INFORMATION9,1,150) POEI_INFORMATION3 , SUBSTR(INFORMATION10,1,150) POEI_INFORMATION4 , SUBSTR(INFORMATION11,1,150) POEI_INFORMATION5 , SUBSTR(INFORMATION12,1,150) POEI_INFORMATION6 , SUBSTR(INFORMATION13,1,150) POEI_INFORMATION7 , SUBSTR(INFORMATION14,1,150) POEI_INFORMATION8 , SUBSTR(INFORMATION15,1,150) POEI_INFORMATION9 , SUBSTR(INFORMATION16,1,150) POEI_INFORMATION10 , SUBSTR(INFORMATION17,1,150) POEI_INFORMATION11 , SUBSTR(INFORMATION18,1,150) POEI_INFORMATION12 , SUBSTR(INFORMATION19,1,150) POEI_INFORMATION13 , SUBSTR(INFORMATION20,1,150) POEI_INFORMATION14 , SUBSTR(INFORMATION21,1,150) POEI_INFORMATION15 , SUBSTR(INFORMATION22,1,150) POEI_INFORMATION16 , SUBSTR(INFORMATION23,1,150) POEI_INFORMATION17 , SUBSTR(INFORMATION24,1,150) POEI_INFORMATION18 , SUBSTR(INFORMATION25,1,150) POEI_INFORMATION19 , SUBSTR(INFORMATION26,1,150) POEI_INFORMATION20 , SUBSTR(INFORMATION27,1,150) POEI_INFORMATION21 , SUBSTR(INFORMATION28,1,150) POEI_INFORMATION22 , SUBSTR(INFORMATION29,1,150) POEI_INFORMATION23 , SUBSTR(INFORMATION30,1,150) POEI_INFORMATION24 , SUBSTR(INFORMATION31,1,150) POEI_INFORMATION25 , SUBSTR(INFORMATION32,1,150) POEI_INFORMATION26 , SUBSTR(INFORMATION33,1,150) POEI_INFORMATION27 , SUBSTR(INFORMATION34,1,150) POEI_INFORMATION28 , SUBSTR(INFORMATION35,1,150) POEI_INFORMATION29 , SUBSTR(INFORMATION36,1,150) POEI_INFORMATION30 , GHR_GENERAL.RETURN_NUMBER(INFORMATION121) REQUEST_ID , GHR_GENERAL.RETURN_NUMBER(INFORMATION122) PROGRAM_APPLICATION_ID , GHR_GENERAL.RETURN_NUMBER(INFORMATION123) PROGRAM_ID , FND_DATE.CANONICAL_TO_DATE(INFORMATION124) PROGRAM_UPDATE_DATE , SUBSTR(INFORMATION125,1,30) POEI_ATTRIBUTE_CATEGORY , SUBSTR(INFORMATION126,1,150) POEI_ATTRIBUTE1 , SUBSTR(INFORMATION127,1,150) POEI_ATTRIBUTE2 , SUBSTR(INFORMATION128,1,150) POEI_ATTRIBUTE3 , SUBSTR(INFORMATION129,1,150) POEI_ATTRIBUTE4 , SUBSTR(INFORMATION130,1,150) POEI_ATTRIBUTE5 , SUBSTR(INFORMATION131,1,150) POEI_ATTRIBUTE6 , SUBSTR(INFORMATION132,1,150) POEI_ATTRIBUTE7 , SUBSTR(INFORMATION133,1,150) POEI_ATTRIBUTE8 , SUBSTR(INFORMATION134,1,150) POEI_ATTRIBUTE9 , SUBSTR(INFORMATION135,1,150) POEI_ATTRIBUTE10 , SUBSTR(INFORMATION136,1,150) POEI_ATTRIBUTE11 , SUBSTR(INFORMATION137,1,150) POEI_ATTRIBUTE12 , SUBSTR(INFORMATION138,1,150) POEI_ATTRIBUTE13 , SUBSTR(INFORMATION139,1,150) POEI_ATTRIBUTE14 , SUBSTR(INFORMATION140,1,150) POEI_ATTRIBUTE15 , SUBSTR(INFORMATION141,1,150) POEI_ATTRIBUTE16 , SUBSTR(INFORMATION142,1,150) POEI_ATTRIBUTE17 , SUBSTR(INFORMATION143,1,150) POEI_ATTRIBUTE18 , SUBSTR(INFORMATION144,1,150) POEI_ATTRIBUTE19 , SUBSTR(INFORMATION145,1,150) POEI_ATTRIBUTE20 FROM GHR_PA_HISTORY WHERE TABLE_NAME = 'PER_POSITION_EXTRA_INFO'

View Text - HTML Formatted

SELECT PA_HISTORY_ID
, PROCESS_DATE
, EFFECTIVE_DATE
, DML_OPERATION
, PRE_VALUES_FLAG
, ALTERED_PA_REQUEST_ID
, PA_REQUEST_ID
, NATURE_OF_ACTION_ID
, GHR_GENERAL.RETURN_NUMBER(INFORMATION1) POSITION_EXTRA_INFO_ID
, GHR_GENERAL.RETURN_NUMBER(INFORMATION4) POSITION_ID
, SUBSTR(INFORMATION5
, 1
, 40) INFORMATION_TYPE
, SUBSTR(INFORMATION6
, 1
, 30) POEI_INFORMATION_CATEGORY
, SUBSTR(INFORMATION7
, 1
, 150) POEI_INFORMATION1
, SUBSTR(INFORMATION8
, 1
, 150) POEI_INFORMATION2
, SUBSTR(INFORMATION9
, 1
, 150) POEI_INFORMATION3
, SUBSTR(INFORMATION10
, 1
, 150) POEI_INFORMATION4
, SUBSTR(INFORMATION11
, 1
, 150) POEI_INFORMATION5
, SUBSTR(INFORMATION12
, 1
, 150) POEI_INFORMATION6
, SUBSTR(INFORMATION13
, 1
, 150) POEI_INFORMATION7
, SUBSTR(INFORMATION14
, 1
, 150) POEI_INFORMATION8
, SUBSTR(INFORMATION15
, 1
, 150) POEI_INFORMATION9
, SUBSTR(INFORMATION16
, 1
, 150) POEI_INFORMATION10
, SUBSTR(INFORMATION17
, 1
, 150) POEI_INFORMATION11
, SUBSTR(INFORMATION18
, 1
, 150) POEI_INFORMATION12
, SUBSTR(INFORMATION19
, 1
, 150) POEI_INFORMATION13
, SUBSTR(INFORMATION20
, 1
, 150) POEI_INFORMATION14
, SUBSTR(INFORMATION21
, 1
, 150) POEI_INFORMATION15
, SUBSTR(INFORMATION22
, 1
, 150) POEI_INFORMATION16
, SUBSTR(INFORMATION23
, 1
, 150) POEI_INFORMATION17
, SUBSTR(INFORMATION24
, 1
, 150) POEI_INFORMATION18
, SUBSTR(INFORMATION25
, 1
, 150) POEI_INFORMATION19
, SUBSTR(INFORMATION26
, 1
, 150) POEI_INFORMATION20
, SUBSTR(INFORMATION27
, 1
, 150) POEI_INFORMATION21
, SUBSTR(INFORMATION28
, 1
, 150) POEI_INFORMATION22
, SUBSTR(INFORMATION29
, 1
, 150) POEI_INFORMATION23
, SUBSTR(INFORMATION30
, 1
, 150) POEI_INFORMATION24
, SUBSTR(INFORMATION31
, 1
, 150) POEI_INFORMATION25
, SUBSTR(INFORMATION32
, 1
, 150) POEI_INFORMATION26
, SUBSTR(INFORMATION33
, 1
, 150) POEI_INFORMATION27
, SUBSTR(INFORMATION34
, 1
, 150) POEI_INFORMATION28
, SUBSTR(INFORMATION35
, 1
, 150) POEI_INFORMATION29
, SUBSTR(INFORMATION36
, 1
, 150) POEI_INFORMATION30
, GHR_GENERAL.RETURN_NUMBER(INFORMATION121) REQUEST_ID
, GHR_GENERAL.RETURN_NUMBER(INFORMATION122) PROGRAM_APPLICATION_ID
, GHR_GENERAL.RETURN_NUMBER(INFORMATION123) PROGRAM_ID
, FND_DATE.CANONICAL_TO_DATE(INFORMATION124) PROGRAM_UPDATE_DATE
, SUBSTR(INFORMATION125
, 1
, 30) POEI_ATTRIBUTE_CATEGORY
, SUBSTR(INFORMATION126
, 1
, 150) POEI_ATTRIBUTE1
, SUBSTR(INFORMATION127
, 1
, 150) POEI_ATTRIBUTE2
, SUBSTR(INFORMATION128
, 1
, 150) POEI_ATTRIBUTE3
, SUBSTR(INFORMATION129
, 1
, 150) POEI_ATTRIBUTE4
, SUBSTR(INFORMATION130
, 1
, 150) POEI_ATTRIBUTE5
, SUBSTR(INFORMATION131
, 1
, 150) POEI_ATTRIBUTE6
, SUBSTR(INFORMATION132
, 1
, 150) POEI_ATTRIBUTE7
, SUBSTR(INFORMATION133
, 1
, 150) POEI_ATTRIBUTE8
, SUBSTR(INFORMATION134
, 1
, 150) POEI_ATTRIBUTE9
, SUBSTR(INFORMATION135
, 1
, 150) POEI_ATTRIBUTE10
, SUBSTR(INFORMATION136
, 1
, 150) POEI_ATTRIBUTE11
, SUBSTR(INFORMATION137
, 1
, 150) POEI_ATTRIBUTE12
, SUBSTR(INFORMATION138
, 1
, 150) POEI_ATTRIBUTE13
, SUBSTR(INFORMATION139
, 1
, 150) POEI_ATTRIBUTE14
, SUBSTR(INFORMATION140
, 1
, 150) POEI_ATTRIBUTE15
, SUBSTR(INFORMATION141
, 1
, 150) POEI_ATTRIBUTE16
, SUBSTR(INFORMATION142
, 1
, 150) POEI_ATTRIBUTE17
, SUBSTR(INFORMATION143
, 1
, 150) POEI_ATTRIBUTE18
, SUBSTR(INFORMATION144
, 1
, 150) POEI_ATTRIBUTE19
, SUBSTR(INFORMATION145
, 1
, 150) POEI_ATTRIBUTE20
FROM GHR_PA_HISTORY
WHERE TABLE_NAME = 'PER_POSITION_EXTRA_INFO'