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: PSA.PSA_XLA_EVENTS_LOGS#

Source

View Text - Preformatted


select LINE_NUMBER LINE_NUMBER, ENTITY_ID ENTITY_ID, APPLICATION_ID APPLICATION_ID, LEDGER_ID LEDGER_ID, ENTITY_CODE ENTITY_CODE, SOURCE_ID_INT_1 SOURCE_ID_INT_1, SOURCE_ID_CHAR_1 SOURCE_ID_CHAR_1, EVENT_ID EVENT_ID, EVENT_CLASS_CODE EVENT_CLASS_CODE, EVENT_STATUS_CODE EVENT_STATUS_CODE, PROCESS_STATUS_CODE PROCESS_STATUS_CODE, REFERENCE_NUM_1 REFERENCE_NUM_1, REFERENCE_CHAR_1 REFERENCE_CHAR_1, ON_HOLD_FLAG ON_HOLD_FLAG, TRANSACTION_DATE TRANSACTION_DATE, BUDGETARY_CONTROL_FLAG BUDGETARY_CONTROL_FLAG, PHASE PHASE, CREATION_DATE CREATION_DATE from "PSA"."PSA_XLA_EVENTS_LOGS"

View Text - HTML Formatted

SELECT LINE_NUMBER LINE_NUMBER
, ENTITY_ID ENTITY_ID
, APPLICATION_ID APPLICATION_ID
, LEDGER_ID LEDGER_ID
, ENTITY_CODE ENTITY_CODE
, SOURCE_ID_INT_1 SOURCE_ID_INT_1
, SOURCE_ID_CHAR_1 SOURCE_ID_CHAR_1
, EVENT_ID EVENT_ID
, EVENT_CLASS_CODE EVENT_CLASS_CODE
, EVENT_STATUS_CODE EVENT_STATUS_CODE
, PROCESS_STATUS_CODE PROCESS_STATUS_CODE
, REFERENCE_NUM_1 REFERENCE_NUM_1
, REFERENCE_CHAR_1 REFERENCE_CHAR_1
, ON_HOLD_FLAG ON_HOLD_FLAG
, TRANSACTION_DATE TRANSACTION_DATE
, BUDGETARY_CONTROL_FLAG BUDGETARY_CONTROL_FLAG
, PHASE PHASE
, CREATION_DATE CREATION_DATE
FROM "PSA"."PSA_XLA_EVENTS_LOGS"