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.PER_ASSIGNMENT_EXTRA_INFO_EFC#

Source

View Text - Preformatted


select ASSIGNMENT_EXTRA_INFO_ID ASSIGNMENT_EXTRA_INFO_ID, EFC_ACTION_ID EFC_ACTION_ID, AEI_INFORMATION7 AEI_INFORMATION7, AEI_INFORMATION6 AEI_INFORMATION6, AEI_INFORMATION13 AEI_INFORMATION13, INPUT_CURRENCY_CODE INPUT_CURRENCY_CODE, AEI_INFORMATION1 AEI_INFORMATION1, AEI_INFORMATION2 AEI_INFORMATION2, AEI_INFORMATION3 AEI_INFORMATION3, AEI_INFORMATION4 AEI_INFORMATION4, AEI_INFORMATION5 AEI_INFORMATION5, AEI_INFORMATION8 AEI_INFORMATION8, AEI_INFORMATION9 AEI_INFORMATION9, AEI_INFORMATION10 AEI_INFORMATION10, AEI_INFORMATION11 AEI_INFORMATION11, AEI_INFORMATION12 AEI_INFORMATION12, AEI_INFORMATION14 AEI_INFORMATION14, AEI_INFORMATION15 AEI_INFORMATION15, AEI_INFORMATION16 AEI_INFORMATION16, AEI_INFORMATION17 AEI_INFORMATION17, AEI_INFORMATION18 AEI_INFORMATION18, AEI_INFORMATION19 AEI_INFORMATION19, AEI_INFORMATION20 AEI_INFORMATION20, AEI_INFORMATION21 AEI_INFORMATION21, AEI_INFORMATION22 AEI_INFORMATION22, AEI_INFORMATION23 AEI_INFORMATION23, AEI_INFORMATION24 AEI_INFORMATION24, AEI_INFORMATION25 AEI_INFORMATION25, AEI_INFORMATION26 AEI_INFORMATION26, AEI_INFORMATION27 AEI_INFORMATION27, AEI_INFORMATION28 AEI_INFORMATION28, AEI_INFORMATION29 AEI_INFORMATION29, AEI_INFORMATION30 AEI_INFORMATION30 from "HR"."PER_ASSIGNMENT_EXTRA_INFO_EFC"

View Text - HTML Formatted

SELECT ASSIGNMENT_EXTRA_INFO_ID ASSIGNMENT_EXTRA_INFO_ID
, EFC_ACTION_ID EFC_ACTION_ID
, AEI_INFORMATION7 AEI_INFORMATION7
, AEI_INFORMATION6 AEI_INFORMATION6
, AEI_INFORMATION13 AEI_INFORMATION13
, INPUT_CURRENCY_CODE INPUT_CURRENCY_CODE
, AEI_INFORMATION1 AEI_INFORMATION1
, AEI_INFORMATION2 AEI_INFORMATION2
, AEI_INFORMATION3 AEI_INFORMATION3
, AEI_INFORMATION4 AEI_INFORMATION4
, AEI_INFORMATION5 AEI_INFORMATION5
, AEI_INFORMATION8 AEI_INFORMATION8
, AEI_INFORMATION9 AEI_INFORMATION9
, AEI_INFORMATION10 AEI_INFORMATION10
, AEI_INFORMATION11 AEI_INFORMATION11
, AEI_INFORMATION12 AEI_INFORMATION12
, AEI_INFORMATION14 AEI_INFORMATION14
, AEI_INFORMATION15 AEI_INFORMATION15
, AEI_INFORMATION16 AEI_INFORMATION16
, AEI_INFORMATION17 AEI_INFORMATION17
, AEI_INFORMATION18 AEI_INFORMATION18
, AEI_INFORMATION19 AEI_INFORMATION19
, AEI_INFORMATION20 AEI_INFORMATION20
, AEI_INFORMATION21 AEI_INFORMATION21
, AEI_INFORMATION22 AEI_INFORMATION22
, AEI_INFORMATION23 AEI_INFORMATION23
, AEI_INFORMATION24 AEI_INFORMATION24
, AEI_INFORMATION25 AEI_INFORMATION25
, AEI_INFORMATION26 AEI_INFORMATION26
, AEI_INFORMATION27 AEI_INFORMATION27
, AEI_INFORMATION28 AEI_INFORMATION28
, AEI_INFORMATION29 AEI_INFORMATION29
, AEI_INFORMATION30 AEI_INFORMATION30
FROM "HR"."PER_ASSIGNMENT_EXTRA_INFO_EFC"