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

Source

View Text - Preformatted


select EVENT_ID EVENT_ID, ENTITY_ID ENTITY_ID, AE_HEADER_ID AE_HEADER_ID, AE_LINE_NUM AE_LINE_NUM, ACCOUNTING_DATE ACCOUNTING_DATE, BALANCE_TYPE_CODE BALANCE_TYPE_CODE, JE_CATEGORY_NAME JE_CATEGORY_NAME, BUDGET_VERSION_ID BUDGET_VERSION_ID, LEDGER_ID LEDGER_ID, ENTERED_CURRENCY_CODE ENTERED_CURRENCY_CODE, ENTERED_DR ENTERED_DR, ENTERED_CR ENTERED_CR, ACCOUNTED_DR ACCOUNTED_DR, ACCOUNTED_CR ACCOUNTED_CR, CODE_COMBINATION_ID CODE_COMBINATION_ID, BALANCING_LINE_TYPE BALANCING_LINE_TYPE, ENCUMBRANCE_TYPE_ID ENCUMBRANCE_TYPE_ID, ACCOUNTING_ENTRY_STATUS_CODE ACCOUNTING_ENTRY_STATUS_CODE, PERIOD_NAME PERIOD_NAME, PHASE PHASE, CREATION_DATE CREATION_DATE from "PSA"."PSA_XLA_VALIDATION_LINES_LOGS"

View Text - HTML Formatted

SELECT EVENT_ID EVENT_ID
, ENTITY_ID ENTITY_ID
, AE_HEADER_ID AE_HEADER_ID
, AE_LINE_NUM AE_LINE_NUM
, ACCOUNTING_DATE ACCOUNTING_DATE
, BALANCE_TYPE_CODE BALANCE_TYPE_CODE
, JE_CATEGORY_NAME JE_CATEGORY_NAME
, BUDGET_VERSION_ID BUDGET_VERSION_ID
, LEDGER_ID LEDGER_ID
, ENTERED_CURRENCY_CODE ENTERED_CURRENCY_CODE
, ENTERED_DR ENTERED_DR
, ENTERED_CR ENTERED_CR
, ACCOUNTED_DR ACCOUNTED_DR
, ACCOUNTED_CR ACCOUNTED_CR
, CODE_COMBINATION_ID CODE_COMBINATION_ID
, BALANCING_LINE_TYPE BALANCING_LINE_TYPE
, ENCUMBRANCE_TYPE_ID ENCUMBRANCE_TYPE_ID
, ACCOUNTING_ENTRY_STATUS_CODE ACCOUNTING_ENTRY_STATUS_CODE
, PERIOD_NAME PERIOD_NAME
, PHASE PHASE
, CREATION_DATE CREATION_DATE
FROM "PSA"."PSA_XLA_VALIDATION_LINES_LOGS"