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: FV.FV_SF1219_AUDITS#

Source

View Text - Preformatted


select ORG_ID ORG_ID, RECORD_TYPE RECORD_TYPE, 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, BATCH_ID BATCH_ID, REPORTED_MONTH REPORTED_MONTH, SF1219_TYPE_CODE SF1219_TYPE_CODE, EXCEPTION_CATEGORY EXCEPTION_CATEGORY, GL_PERIOD GL_PERIOD, REPORTED_GL_PERIOD REPORTED_GL_PERIOD, TREASURY_SYMBOL TREASURY_SYMBOL, ACCOUNTABILITY_BALANCE ACCOUNTABILITY_BALANCE, TREASURY_SYMBOL_ID TREASURY_SYMBOL_ID, ALC_CODE ALC_CODE, INTER_AGENCY_FLAG INTER_AGENCY_FLAG, JE_HEADER_ID JE_HEADER_ID, JE_LINE_NUM JE_LINE_NUM, SUPPLEMENT_NUMBER SUPPLEMENT_NUMBER from "FV"."FV_SF1219_AUDITS"

View Text - HTML Formatted

SELECT ORG_ID ORG_ID
, RECORD_TYPE RECORD_TYPE
, 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
, BATCH_ID BATCH_ID
, REPORTED_MONTH REPORTED_MONTH
, SF1219_TYPE_CODE SF1219_TYPE_CODE
, EXCEPTION_CATEGORY EXCEPTION_CATEGORY
, GL_PERIOD GL_PERIOD
, REPORTED_GL_PERIOD REPORTED_GL_PERIOD
, TREASURY_SYMBOL TREASURY_SYMBOL
, ACCOUNTABILITY_BALANCE ACCOUNTABILITY_BALANCE
, TREASURY_SYMBOL_ID TREASURY_SYMBOL_ID
, ALC_CODE ALC_CODE
, INTER_AGENCY_FLAG INTER_AGENCY_FLAG
, JE_HEADER_ID JE_HEADER_ID
, JE_LINE_NUM JE_LINE_NUM
, SUPPLEMENT_NUMBER SUPPLEMENT_NUMBER
FROM "FV"."FV_SF1219_AUDITS"