[Home] [Help] [Dependency Information]

VIEW: GMF.GL_SUBR_STA#

Object Details

[View Source]

Columns

Query Text

Cut, paste (and edit) the following text to query this object:

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

Dependencies

[top of page]

GMF

GL_SUBR_STA

APPS

GL_SUBR_STA