VIEW: GMF.GL_SUBR_STA#

Source

View Text - Preformatted

select CLOSED_PER_IND CLOSED_PER_IND, GL_DATE GL_DATE, GL_FISCAL_YEAR GL_FISCAL_YEAR, REFERENCE_NO REFERENCE_NO, GL_PERIOD GL_PERIOD, CO_CODE CO_CODE, CURRENT_STATE CURRENT_STATE, START_TIME START_TIME, END_TIME END_TIME, COMPLETION_IND COMPLETION_IND, STARTED_BY STARTED_BY, STOP_IND STOP_IND, FISCAL_YEAR FISCAL_YEAR, PERIOD PERIOD, PERIOD_START_DATE PERIOD_START_DATE, PERIOD_END_DATE PERIOD_END_DATE, TEST_POSTING TEST_POSTING, POST_IC POST_IC, POST_OP POST_OP, POST_PM POST_PM, POST_PO POST_PO, POST_CM POST_CM, SCHEDULED_ON SCHEDULED_ON, ABORTED_BY ABORTED_BY, UPDATE_STAGE UPDATE_STAGE, ERRORS_FOUND ERRORS_FOUND, ERRORS_POSTED ERRORS_POSTED, ERRORS_LIMIT ERRORS_LIMIT, ROWS_POSTED ROWS_POSTED, ABORT_REASON ABORT_REASON, 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, DELETE_MARK DELETE_MARK, IN_USE IN_USE, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, REQUEST_ID REQUEST_ID, POST_OM POST_OM, INCL_NO_COST INCL_NO_COST, POST_PUR POST_PUR, DEFAULT_LANGUAGE DEFAULT_LANGUAGE, CREV_CURR_CALENDAR CREV_CURR_CALENDAR, CREV_CURR_MTHD CREV_CURR_MTHD, CREV_CURR_PERIOD CREV_CURR_PERIOD, CREV_GL_TRANS_DATE CREV_GL_TRANS_DATE, CREV_INV_PREV_CAL CREV_INV_PREV_CAL, CREV_INV_PREV_PER CREV_INV_PREV_PER, CREV_PREV_CALENDAR CREV_PREV_CALENDAR, CREV_PREV_MTHD CREV_PREV_MTHD, CREV_PREV_PERIOD CREV_PREV_PERIOD, BASE_CURRENCY BASE_CURRENCY, COST_BASIS COST_BASIS, COST_MTHD_CODE COST_MTHD_CODE, COST_TYPE COST_TYPE, COST_TYPE_ID COST_TYPE_ID, CREV_CURR_COST_TYPE_ID CREV_CURR_COST_TYPE_ID, CREV_CURR_PERIOD_ID CREV_CURR_PERIOD_ID, CREV_PREV_COST_TYPE_ID CREV_PREV_COST_TYPE_ID, CREV_PREV_PERIOD_ID CREV_PREV_PERIOD_ID, DEFAULT_COST_MTHD_CODE DEFAULT_COST_MTHD_CODE, DEFAULT_COST_TYPE_ID DEFAULT_COST_TYPE_ID, EXTRACT_HDR_ROWS_POSTED EXTRACT_HDR_ROWS_POSTED, EXTRACT_LINE_ROWS_POSTED EXTRACT_LINE_ROWS_POSTED, LEDGER_ID LEDGER_ID, LEGAL_ENTITY_ID LEGAL_ENTITY_ID, LEGAL_ENTITY_NAME LEGAL_ENTITY_NAME, PERIOD_ID PERIOD_ID, PROCESS_CATEGORY PROCESS_CATEGORY, POST_CM_CADJ POST_CM_CADJ, POST_CM_RVAL POST_CM_RVAL, POST_GL_ALOC POST_GL_ALOC, BATCH_ID_FROM BATCH_ID_FROM, BATCH_ID_TO BATCH_ID_TO, NUM_OF_PROCESS NUM_OF_PROCESS, POST_TXN_CMPT_COST POST_TXN_CMPT_COST from "GMF"."GL_SUBR_STA"

View Text - HTML Formatted

SELECT CLOSED_PER_IND CLOSED_PER_IND
, GL_DATE GL_DATE
, GL_FISCAL_YEAR GL_FISCAL_YEAR
, REFERENCE_NO REFERENCE_NO
, GL_PERIOD GL_PERIOD
, CO_CODE CO_CODE
, CURRENT_STATE CURRENT_STATE
, START_TIME START_TIME
, END_TIME END_TIME
, COMPLETION_IND COMPLETION_IND
, STARTED_BY STARTED_BY
, STOP_IND STOP_IND
, FISCAL_YEAR FISCAL_YEAR
, PERIOD PERIOD
, PERIOD_START_DATE PERIOD_START_DATE
, PERIOD_END_DATE PERIOD_END_DATE
, TEST_POSTING TEST_POSTING
, POST_IC POST_IC
, POST_OP POST_OP
, POST_PM POST_PM
, POST_PO POST_PO
, POST_CM POST_CM
, SCHEDULED_ON SCHEDULED_ON
, ABORTED_BY ABORTED_BY
, UPDATE_STAGE UPDATE_STAGE
, ERRORS_FOUND ERRORS_FOUND
, ERRORS_POSTED ERRORS_POSTED
, ERRORS_LIMIT ERRORS_LIMIT
, ROWS_POSTED ROWS_POSTED
, ABORT_REASON ABORT_REASON
, 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
, DELETE_MARK DELETE_MARK
, IN_USE IN_USE
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, REQUEST_ID REQUEST_ID
, POST_OM POST_OM
, INCL_NO_COST INCL_NO_COST
, POST_PUR POST_PUR
, DEFAULT_LANGUAGE DEFAULT_LANGUAGE
, CREV_CURR_CALENDAR CREV_CURR_CALENDAR
, CREV_CURR_MTHD CREV_CURR_MTHD
, CREV_CURR_PERIOD CREV_CURR_PERIOD
, CREV_GL_TRANS_DATE CREV_GL_TRANS_DATE
, CREV_INV_PREV_CAL CREV_INV_PREV_CAL
, CREV_INV_PREV_PER CREV_INV_PREV_PER
, CREV_PREV_CALENDAR CREV_PREV_CALENDAR
, CREV_PREV_MTHD CREV_PREV_MTHD
, CREV_PREV_PERIOD CREV_PREV_PERIOD
, BASE_CURRENCY BASE_CURRENCY
, COST_BASIS COST_BASIS
, COST_MTHD_CODE COST_MTHD_CODE
, COST_TYPE COST_TYPE
, COST_TYPE_ID COST_TYPE_ID
, CREV_CURR_COST_TYPE_ID CREV_CURR_COST_TYPE_ID
, CREV_CURR_PERIOD_ID CREV_CURR_PERIOD_ID
, CREV_PREV_COST_TYPE_ID CREV_PREV_COST_TYPE_ID
, CREV_PREV_PERIOD_ID CREV_PREV_PERIOD_ID
, DEFAULT_COST_MTHD_CODE DEFAULT_COST_MTHD_CODE
, DEFAULT_COST_TYPE_ID DEFAULT_COST_TYPE_ID
, EXTRACT_HDR_ROWS_POSTED EXTRACT_HDR_ROWS_POSTED
, EXTRACT_LINE_ROWS_POSTED EXTRACT_LINE_ROWS_POSTED
, LEDGER_ID LEDGER_ID
, LEGAL_ENTITY_ID LEGAL_ENTITY_ID
, LEGAL_ENTITY_NAME LEGAL_ENTITY_NAME
, PERIOD_ID PERIOD_ID
, PROCESS_CATEGORY PROCESS_CATEGORY
, POST_CM_CADJ POST_CM_CADJ
, POST_CM_RVAL POST_CM_RVAL
, POST_GL_ALOC POST_GL_ALOC
, BATCH_ID_FROM BATCH_ID_FROM
, BATCH_ID_TO BATCH_ID_TO
, NUM_OF_PROCESS NUM_OF_PROCESS
, POST_TXN_CMPT_COST POST_TXN_CMPT_COST
FROM "GMF"."GL_SUBR_STA"