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

Source

View Text - Preformatted


select TRANSACTION_ID TRANSACTION_ID, CREATOR_PERSON_ID CREATOR_PERSON_ID, TRANSACTION_PRIVILEGE TRANSACTION_PRIVILEGE, 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, PRODUCT_CODE PRODUCT_CODE, STATUS STATUS, SECTION_DISPLAY_NAME SECTION_DISPLAY_NAME, FUNCTION_ID FUNCTION_ID, TRANSACTION_REF_TABLE TRANSACTION_REF_TABLE, TRANSACTION_REF_ID TRANSACTION_REF_ID, TRANSACTION_TYPE TRANSACTION_TYPE, ASSIGNMENT_ID ASSIGNMENT_ID, API_ADDTNL_INFO API_ADDTNL_INFO, SELECTED_PERSON_ID SELECTED_PERSON_ID, ITEM_TYPE ITEM_TYPE, ITEM_KEY ITEM_KEY, TRANSACTION_EFFECTIVE_DATE TRANSACTION_EFFECTIVE_DATE, PROCESS_NAME PROCESS_NAME, URL URL, TRANSACTION_STATE TRANSACTION_STATE, EFFECTIVE_DATE_OPTION EFFECTIVE_DATE_OPTION, RPTG_GRP_ID RPTG_GRP_ID, PLAN_ID PLAN_ID, TRANSACTION_DOCUMENT TRANSACTION_DOCUMENT, RELAUNCH_FUNCTION RELAUNCH_FUNCTION, TRANSACTION_GROUP TRANSACTION_GROUP, TRANSACTION_IDENTIFIER TRANSACTION_IDENTIFIER, PARENT_TRANSACTION_ID PARENT_TRANSACTION_ID, CREATOR_ROLE CREATOR_ROLE, LAST_UPDATE_ROLE LAST_UPDATE_ROLE from "HR"."HR_API_TRANSACTIONS"

View Text - HTML Formatted

SELECT TRANSACTION_ID TRANSACTION_ID
, CREATOR_PERSON_ID CREATOR_PERSON_ID
, TRANSACTION_PRIVILEGE TRANSACTION_PRIVILEGE
, 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
, PRODUCT_CODE PRODUCT_CODE
, STATUS STATUS
, SECTION_DISPLAY_NAME SECTION_DISPLAY_NAME
, FUNCTION_ID FUNCTION_ID
, TRANSACTION_REF_TABLE TRANSACTION_REF_TABLE
, TRANSACTION_REF_ID TRANSACTION_REF_ID
, TRANSACTION_TYPE TRANSACTION_TYPE
, ASSIGNMENT_ID ASSIGNMENT_ID
, API_ADDTNL_INFO API_ADDTNL_INFO
, SELECTED_PERSON_ID SELECTED_PERSON_ID
, ITEM_TYPE ITEM_TYPE
, ITEM_KEY ITEM_KEY
, TRANSACTION_EFFECTIVE_DATE TRANSACTION_EFFECTIVE_DATE
, PROCESS_NAME PROCESS_NAME
, URL URL
, TRANSACTION_STATE TRANSACTION_STATE
, EFFECTIVE_DATE_OPTION EFFECTIVE_DATE_OPTION
, RPTG_GRP_ID RPTG_GRP_ID
, PLAN_ID PLAN_ID
, TRANSACTION_DOCUMENT TRANSACTION_DOCUMENT
, RELAUNCH_FUNCTION RELAUNCH_FUNCTION
, TRANSACTION_GROUP TRANSACTION_GROUP
, TRANSACTION_IDENTIFIER TRANSACTION_IDENTIFIER
, PARENT_TRANSACTION_ID PARENT_TRANSACTION_ID
, CREATOR_ROLE CREATOR_ROLE
, LAST_UPDATE_ROLE LAST_UPDATE_ROLE
FROM "HR"."HR_API_TRANSACTIONS"