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.

[Home] [Help]

VIEW: HR.GHR_PA_REQUEST_EI_SHADOW#

Source

View Text - Preformatted


select PA_REQUEST_EXTRA_INFO_ID PA_REQUEST_EXTRA_INFO_ID, PA_REQUEST_ID PA_REQUEST_ID, INFORMATION_TYPE INFORMATION_TYPE, REI_INFORMATION1 REI_INFORMATION1, REI_INFORMATION2 REI_INFORMATION2, REI_INFORMATION3 REI_INFORMATION3, REI_INFORMATION4 REI_INFORMATION4, REI_INFORMATION5 REI_INFORMATION5, REI_INFORMATION6 REI_INFORMATION6, REI_INFORMATION7 REI_INFORMATION7, REI_INFORMATION8 REI_INFORMATION8, REI_INFORMATION9 REI_INFORMATION9, REI_INFORMATION10 REI_INFORMATION10, REI_INFORMATION11 REI_INFORMATION11, REI_INFORMATION12 REI_INFORMATION12, REI_INFORMATION13 REI_INFORMATION13, REI_INFORMATION14 REI_INFORMATION14, REI_INFORMATION15 REI_INFORMATION15, REI_INFORMATION16 REI_INFORMATION16, REI_INFORMATION17 REI_INFORMATION17, REI_INFORMATION18 REI_INFORMATION18, REI_INFORMATION19 REI_INFORMATION19, REI_INFORMATION20 REI_INFORMATION20, REI_INFORMATION21 REI_INFORMATION21, REI_INFORMATION22 REI_INFORMATION22, REI_INFORMATION28 REI_INFORMATION28, REI_INFORMATION29 REI_INFORMATION29, REI_INFORMATION23 REI_INFORMATION23, REI_INFORMATION24 REI_INFORMATION24, REI_INFORMATION25 REI_INFORMATION25, REI_INFORMATION26 REI_INFORMATION26, REI_INFORMATION27 REI_INFORMATION27, REI_INFORMATION30 REI_INFORMATION30, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE from "HR"."GHR_PA_REQUEST_EI_SHADOW"

View Text - HTML Formatted

SELECT PA_REQUEST_EXTRA_INFO_ID PA_REQUEST_EXTRA_INFO_ID
, PA_REQUEST_ID PA_REQUEST_ID
, INFORMATION_TYPE INFORMATION_TYPE
, REI_INFORMATION1 REI_INFORMATION1
, REI_INFORMATION2 REI_INFORMATION2
, REI_INFORMATION3 REI_INFORMATION3
, REI_INFORMATION4 REI_INFORMATION4
, REI_INFORMATION5 REI_INFORMATION5
, REI_INFORMATION6 REI_INFORMATION6
, REI_INFORMATION7 REI_INFORMATION7
, REI_INFORMATION8 REI_INFORMATION8
, REI_INFORMATION9 REI_INFORMATION9
, REI_INFORMATION10 REI_INFORMATION10
, REI_INFORMATION11 REI_INFORMATION11
, REI_INFORMATION12 REI_INFORMATION12
, REI_INFORMATION13 REI_INFORMATION13
, REI_INFORMATION14 REI_INFORMATION14
, REI_INFORMATION15 REI_INFORMATION15
, REI_INFORMATION16 REI_INFORMATION16
, REI_INFORMATION17 REI_INFORMATION17
, REI_INFORMATION18 REI_INFORMATION18
, REI_INFORMATION19 REI_INFORMATION19
, REI_INFORMATION20 REI_INFORMATION20
, REI_INFORMATION21 REI_INFORMATION21
, REI_INFORMATION22 REI_INFORMATION22
, REI_INFORMATION28 REI_INFORMATION28
, REI_INFORMATION29 REI_INFORMATION29
, REI_INFORMATION23 REI_INFORMATION23
, REI_INFORMATION24 REI_INFORMATION24
, REI_INFORMATION25 REI_INFORMATION25
, REI_INFORMATION26 REI_INFORMATION26
, REI_INFORMATION27 REI_INFORMATION27
, REI_INFORMATION30 REI_INFORMATION30
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
FROM "HR"."GHR_PA_REQUEST_EI_SHADOW"