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: GMF.GL_UPDT_CTL#

Source

View Text - Preformatted


select GUPROC_ID GUPROC_ID, CO_CODE CO_CODE, OF_SOB_ID OF_SOB_ID, FISCAL_YEAR FISCAL_YEAR, PERIOD PERIOD, PERIOD_START_DATE PERIOD_START_DATE, PERIOD_END_DATE PERIOD_END_DATE, ALL_SOURCE ALL_SOURCE, ONE_SOURCE ONE_SOURCE, FROM_SOURCE FROM_SOURCE, TO_SOURCE TO_SOURCE, ALL_EVENT ALL_EVENT, ONE_EVENT ONE_EVENT, FROM_EVENT FROM_EVENT, TO_EVENT TO_EVENT, ALL_SUB_EVENT ALL_SUB_EVENT, ONE_SUB_EVENT ONE_SUB_EVENT, FROM_SUB_EVENT FROM_SUB_EVENT, TO_SUB_EVENT TO_SUB_EVENT, OF_USER_ID OF_USER_ID, RUNNING_IND RUNNING_IND, SCHEDULED_ON SCHEDULED_ON, STARTED_BY STARTED_BY, STARTED_ON STARTED_ON, ENDED_ON ENDED_ON, ERRORS_FOUND ERRORS_FOUND, ERRORS_POSTED ERRORS_POSTED, ROWS_POSTED ROWS_POSTED, ABORT_IND ABORT_IND, ABORT_BY ABORT_BY, ABORT_REASON ABORT_REASON, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, IN_USE IN_USE, DELETE_MARK DELETE_MARK, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, REQUEST_ID REQUEST_ID from "GMF"."GL_UPDT_CTL"

View Text - HTML Formatted

SELECT GUPROC_ID GUPROC_ID
, CO_CODE CO_CODE
, OF_SOB_ID OF_SOB_ID
, FISCAL_YEAR FISCAL_YEAR
, PERIOD PERIOD
, PERIOD_START_DATE PERIOD_START_DATE
, PERIOD_END_DATE PERIOD_END_DATE
, ALL_SOURCE ALL_SOURCE
, ONE_SOURCE ONE_SOURCE
, FROM_SOURCE FROM_SOURCE
, TO_SOURCE TO_SOURCE
, ALL_EVENT ALL_EVENT
, ONE_EVENT ONE_EVENT
, FROM_EVENT FROM_EVENT
, TO_EVENT TO_EVENT
, ALL_SUB_EVENT ALL_SUB_EVENT
, ONE_SUB_EVENT ONE_SUB_EVENT
, FROM_SUB_EVENT FROM_SUB_EVENT
, TO_SUB_EVENT TO_SUB_EVENT
, OF_USER_ID OF_USER_ID
, RUNNING_IND RUNNING_IND
, SCHEDULED_ON SCHEDULED_ON
, STARTED_BY STARTED_BY
, STARTED_ON STARTED_ON
, ENDED_ON ENDED_ON
, ERRORS_FOUND ERRORS_FOUND
, ERRORS_POSTED ERRORS_POSTED
, ROWS_POSTED ROWS_POSTED
, ABORT_IND ABORT_IND
, ABORT_BY ABORT_BY
, ABORT_REASON ABORT_REASON
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, IN_USE IN_USE
, DELETE_MARK DELETE_MARK
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, REQUEST_ID REQUEST_ID
FROM "GMF"."GL_UPDT_CTL"