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: GL.GL_CONSOLIDATION_HISTORY#

Source

View Text - Preformatted


select CONSOLIDATION_RUN_ID CONSOLIDATION_RUN_ID, CONSOLIDATION_ID CONSOLIDATION_ID, FROM_PERIOD_NAME FROM_PERIOD_NAME, TO_PERIOD_NAME TO_PERIOD_NAME, TO_CURRENCY_CODE TO_CURRENCY_CODE, METHOD_FLAG METHOD_FLAG, RUN_EASYLINK_FLAG RUN_EASYLINK_FLAG, ACTUAL_FLAG ACTUAL_FLAG, AVERAGE_CONSOLIDATION_FLAG AVERAGE_CONSOLIDATION_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, FROM_BUDGET_NAME FROM_BUDGET_NAME, FROM_BUDGET_VERSION_ID FROM_BUDGET_VERSION_ID, TO_BUDGET_NAME TO_BUDGET_NAME, TO_BUDGET_VERSION_ID TO_BUDGET_VERSION_ID, AMOUNT_TYPE AMOUNT_TYPE, FROM_DATE FROM_DATE, AVERAGE_TO_PERIOD_NAME AVERAGE_TO_PERIOD_NAME, CONSOLIDATION_SET_ID CONSOLIDATION_SET_ID, OBSOLETE_CONSOLIDATION_FLAG OBSOLETE_CONSOLIDATION_FLAG, STATUS STATUS, REQUEST_ID REQUEST_ID, GROUP_ID GROUP_ID, JE_BATCH_ID JE_BATCH_ID, RUN_POSTING_FLAG RUN_POSTING_FLAG, TARGET_USER_NAME TARGET_USER_NAME, TARGET_RESP_NAME TARGET_RESP_NAME, TARGET_DATABASE_NAME TARGET_DATABASE_NAME from "GL"."GL_CONSOLIDATION_HISTORY"

View Text - HTML Formatted

SELECT CONSOLIDATION_RUN_ID CONSOLIDATION_RUN_ID
, CONSOLIDATION_ID CONSOLIDATION_ID
, FROM_PERIOD_NAME FROM_PERIOD_NAME
, TO_PERIOD_NAME TO_PERIOD_NAME
, TO_CURRENCY_CODE TO_CURRENCY_CODE
, METHOD_FLAG METHOD_FLAG
, RUN_EASYLINK_FLAG RUN_EASYLINK_FLAG
, ACTUAL_FLAG ACTUAL_FLAG
, AVERAGE_CONSOLIDATION_FLAG AVERAGE_CONSOLIDATION_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
, FROM_BUDGET_NAME FROM_BUDGET_NAME
, FROM_BUDGET_VERSION_ID FROM_BUDGET_VERSION_ID
, TO_BUDGET_NAME TO_BUDGET_NAME
, TO_BUDGET_VERSION_ID TO_BUDGET_VERSION_ID
, AMOUNT_TYPE AMOUNT_TYPE
, FROM_DATE FROM_DATE
, AVERAGE_TO_PERIOD_NAME AVERAGE_TO_PERIOD_NAME
, CONSOLIDATION_SET_ID CONSOLIDATION_SET_ID
, OBSOLETE_CONSOLIDATION_FLAG OBSOLETE_CONSOLIDATION_FLAG
, STATUS STATUS
, REQUEST_ID REQUEST_ID
, GROUP_ID GROUP_ID
, JE_BATCH_ID JE_BATCH_ID
, RUN_POSTING_FLAG RUN_POSTING_FLAG
, TARGET_USER_NAME TARGET_USER_NAME
, TARGET_RESP_NAME TARGET_RESP_NAME
, TARGET_DATABASE_NAME TARGET_DATABASE_NAME
FROM "GL"."GL_CONSOLIDATION_HISTORY"