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: HR.HR_API_TRANSACTION_STEPS#

Source

View Text - Preformatted


select TRANSACTION_STEP_ID TRANSACTION_STEP_ID, TRANSACTION_ID TRANSACTION_ID, API_NAME API_NAME, API_DISPLAY_NAME API_DISPLAY_NAME, PROCESSING_ORDER PROCESSING_ORDER, ITEM_TYPE ITEM_TYPE, ITEM_KEY ITEM_KEY, ACTIVITY_ID ACTIVITY_ID, CREATOR_PERSON_ID CREATOR_PERSON_ID, UPDATE_PERSON_ID UPDATE_PERSON_ID, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, OBJECT_TYPE OBJECT_TYPE, OBJECT_NAME OBJECT_NAME, OBJECT_IDENTIFIER OBJECT_IDENTIFIER, PK1 PK1, PK2 PK2, PK3 PK3, PK4 PK4, PK5 PK5, OBJECT_STATE OBJECT_STATE, 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, INFORMATION21 INFORMATION21, INFORMATION22 INFORMATION22, INFORMATION23 INFORMATION23, INFORMATION24 INFORMATION24, INFORMATION25 INFORMATION25, INFORMATION26 INFORMATION26, INFORMATION27 INFORMATION27, INFORMATION28 INFORMATION28, INFORMATION29 INFORMATION29, INFORMATION30 INFORMATION30 from "HR"."HR_API_TRANSACTION_STEPS"

View Text - HTML Formatted

SELECT TRANSACTION_STEP_ID TRANSACTION_STEP_ID
, TRANSACTION_ID TRANSACTION_ID
, API_NAME API_NAME
, API_DISPLAY_NAME API_DISPLAY_NAME
, PROCESSING_ORDER PROCESSING_ORDER
, ITEM_TYPE ITEM_TYPE
, ITEM_KEY ITEM_KEY
, ACTIVITY_ID ACTIVITY_ID
, CREATOR_PERSON_ID CREATOR_PERSON_ID
, UPDATE_PERSON_ID UPDATE_PERSON_ID
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, OBJECT_TYPE OBJECT_TYPE
, OBJECT_NAME OBJECT_NAME
, OBJECT_IDENTIFIER OBJECT_IDENTIFIER
, PK1 PK1
, PK2 PK2
, PK3 PK3
, PK4 PK4
, PK5 PK5
, OBJECT_STATE OBJECT_STATE
, 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
, INFORMATION21 INFORMATION21
, INFORMATION22 INFORMATION22
, INFORMATION23 INFORMATION23
, INFORMATION24 INFORMATION24
, INFORMATION25 INFORMATION25
, INFORMATION26 INFORMATION26
, INFORMATION27 INFORMATION27
, INFORMATION28 INFORMATION28
, INFORMATION29 INFORMATION29
, INFORMATION30 INFORMATION30
FROM "HR"."HR_API_TRANSACTION_STEPS"