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_WPM_PERSON_ACTIONS#

Source

View Text - Preformatted


select WPM_PERSON_ACTION_ID WPM_PERSON_ACTION_ID, WPM_BATCH_ACTION_ID WPM_BATCH_ACTION_ID, PERSON_ID PERSON_ID, ASSIGNMENT_ID ASSIGNMENT_ID, BUSINESS_GROUP_ID BUSINESS_GROUP_ID, PROCESSING_STATUS PROCESSING_STATUS, ELIGIBILITY_STATUS ELIGIBILITY_STATUS, MESSAGE_TYPE MESSAGE_TYPE, MESSAGE_NUMBER MESSAGE_NUMBER, MESSAGE_TEXT MESSAGE_TEXT, TRANSACTION_REF_TABLE TRANSACTION_REF_TABLE, TRANSACTION_REF_ID TRANSACTION_REF_ID, INFORMATION_CATEGORY INFORMATION_CATEGORY, INFORMATION1 INFORMATION1, INFORMATION2 INFORMATION2, INFORMATION3 INFORMATION3, INFORMATION4 INFORMATION4, INFORMATION5 INFORMATION5, INFORMATION6 INFORMATION6, INFORMATION7 INFORMATION7, INFORMATION8 INFORMATION8, INFORMATION9 INFORMATION9, INFORMATION10 INFORMATION10, INFORMATION11 INFORMATION11, INFORMATION12 INFORMATION12, INFORMATION13 INFORMATION13, INFORMATION14 INFORMATION14, INFORMATION15 INFORMATION15, INFORMATION16 INFORMATION16, INFORMATION17 INFORMATION17, INFORMATION18 INFORMATION18, INFORMATION19 INFORMATION19, INFORMATION20 INFORMATION20, 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"."PER_WPM_PERSON_ACTIONS"

View Text - HTML Formatted

SELECT WPM_PERSON_ACTION_ID WPM_PERSON_ACTION_ID
, WPM_BATCH_ACTION_ID WPM_BATCH_ACTION_ID
, PERSON_ID PERSON_ID
, ASSIGNMENT_ID ASSIGNMENT_ID
, BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, PROCESSING_STATUS PROCESSING_STATUS
, ELIGIBILITY_STATUS ELIGIBILITY_STATUS
, MESSAGE_TYPE MESSAGE_TYPE
, MESSAGE_NUMBER MESSAGE_NUMBER
, MESSAGE_TEXT MESSAGE_TEXT
, TRANSACTION_REF_TABLE TRANSACTION_REF_TABLE
, TRANSACTION_REF_ID TRANSACTION_REF_ID
, INFORMATION_CATEGORY INFORMATION_CATEGORY
, INFORMATION1 INFORMATION1
, INFORMATION2 INFORMATION2
, INFORMATION3 INFORMATION3
, INFORMATION4 INFORMATION4
, INFORMATION5 INFORMATION5
, INFORMATION6 INFORMATION6
, INFORMATION7 INFORMATION7
, INFORMATION8 INFORMATION8
, INFORMATION9 INFORMATION9
, INFORMATION10 INFORMATION10
, INFORMATION11 INFORMATION11
, INFORMATION12 INFORMATION12
, INFORMATION13 INFORMATION13
, INFORMATION14 INFORMATION14
, INFORMATION15 INFORMATION15
, INFORMATION16 INFORMATION16
, INFORMATION17 INFORMATION17
, INFORMATION18 INFORMATION18
, INFORMATION19 INFORMATION19
, INFORMATION20 INFORMATION20
, 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"."PER_WPM_PERSON_ACTIONS"