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: XLA.XLA_EVENTS#

Source

View Text - Preformatted


select EVENT_ID EVENT_ID, APPLICATION_ID APPLICATION_ID, EVENT_TYPE_CODE EVENT_TYPE_CODE, EVENT_DATE EVENT_DATE, ENTITY_ID ENTITY_ID, EVENT_STATUS_CODE EVENT_STATUS_CODE, PROCESS_STATUS_CODE PROCESS_STATUS_CODE, REFERENCE_NUM_1 REFERENCE_NUM_1, REFERENCE_NUM_2 REFERENCE_NUM_2, REFERENCE_NUM_3 REFERENCE_NUM_3, REFERENCE_NUM_4 REFERENCE_NUM_4, REFERENCE_CHAR_1 REFERENCE_CHAR_1, REFERENCE_CHAR_2 REFERENCE_CHAR_2, REFERENCE_CHAR_3 REFERENCE_CHAR_3, REFERENCE_CHAR_4 REFERENCE_CHAR_4, REFERENCE_DATE_1 REFERENCE_DATE_1, REFERENCE_DATE_2 REFERENCE_DATE_2, REFERENCE_DATE_3 REFERENCE_DATE_3, REFERENCE_DATE_4 REFERENCE_DATE_4, EVENT_NUMBER EVENT_NUMBER, ON_HOLD_FLAG ON_HOLD_FLAG, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, REQUEST_ID REQUEST_ID, UPG_BATCH_ID UPG_BATCH_ID, UPG_SOURCE_APPLICATION_ID UPG_SOURCE_APPLICATION_ID, UPG_VALID_FLAG UPG_VALID_FLAG, TRANSACTION_DATE TRANSACTION_DATE, BUDGETARY_CONTROL_FLAG BUDGETARY_CONTROL_FLAG, MERGE_EVENT_SET_ID MERGE_EVENT_SET_ID from "XLA"."XLA_EVENTS"

View Text - HTML Formatted

SELECT EVENT_ID EVENT_ID
, APPLICATION_ID APPLICATION_ID
, EVENT_TYPE_CODE EVENT_TYPE_CODE
, EVENT_DATE EVENT_DATE
, ENTITY_ID ENTITY_ID
, EVENT_STATUS_CODE EVENT_STATUS_CODE
, PROCESS_STATUS_CODE PROCESS_STATUS_CODE
, REFERENCE_NUM_1 REFERENCE_NUM_1
, REFERENCE_NUM_2 REFERENCE_NUM_2
, REFERENCE_NUM_3 REFERENCE_NUM_3
, REFERENCE_NUM_4 REFERENCE_NUM_4
, REFERENCE_CHAR_1 REFERENCE_CHAR_1
, REFERENCE_CHAR_2 REFERENCE_CHAR_2
, REFERENCE_CHAR_3 REFERENCE_CHAR_3
, REFERENCE_CHAR_4 REFERENCE_CHAR_4
, REFERENCE_DATE_1 REFERENCE_DATE_1
, REFERENCE_DATE_2 REFERENCE_DATE_2
, REFERENCE_DATE_3 REFERENCE_DATE_3
, REFERENCE_DATE_4 REFERENCE_DATE_4
, EVENT_NUMBER EVENT_NUMBER
, ON_HOLD_FLAG ON_HOLD_FLAG
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, REQUEST_ID REQUEST_ID
, UPG_BATCH_ID UPG_BATCH_ID
, UPG_SOURCE_APPLICATION_ID UPG_SOURCE_APPLICATION_ID
, UPG_VALID_FLAG UPG_VALID_FLAG
, TRANSACTION_DATE TRANSACTION_DATE
, BUDGETARY_CONTROL_FLAG BUDGETARY_CONTROL_FLAG
, MERGE_EVENT_SET_ID MERGE_EVENT_SET_ID
FROM "XLA"."XLA_EVENTS"