[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | GL_SUBR_STA# |
|---|---|
| Object Type: | VIEW |
| Owner: | GMF |
| Subobject Name: | |
| Status: | VALID |
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| CLOSED_PER_IND | NUMBER | (2) | Yes | |
| GL_DATE | DATE | |||
| GL_FISCAL_YEAR | NUMBER | (5) | ||
| REFERENCE_NO | NUMBER | (10) | Yes | |
| GL_PERIOD | NUMBER | (5) | ||
| CO_CODE | VARCHAR2 | (4) | ||
| CURRENT_STATE | NUMBER | (5) | Yes | |
| START_TIME | DATE | |||
| END_TIME | DATE | |||
| COMPLETION_IND | NUMBER | (5) | Yes | |
| STARTED_BY | NUMBER | (15) | Yes | |
| STOP_IND | NUMBER | (5) | Yes | |
| FISCAL_YEAR | NUMBER | (5) | Yes | |
| PERIOD | NUMBER | (5) | Yes | |
| PERIOD_START_DATE | DATE | Yes | ||
| PERIOD_END_DATE | DATE | Yes | ||
| TEST_POSTING | NUMBER | (5) | Yes | |
| POST_IC | NUMBER | (5) | ||
| POST_OP | NUMBER | (5) | ||
| POST_PM | NUMBER | (5) | ||
| POST_PO | NUMBER | (5) | ||
| POST_CM | NUMBER | (5) | ||
| SCHEDULED_ON | VARCHAR2 | (32) | Yes | |
| ABORTED_BY | NUMBER | (15) | ||
| UPDATE_STAGE | NUMBER | (5) | ||
| ERRORS_FOUND | NUMBER | (10) | ||
| ERRORS_POSTED | NUMBER | (10) | ||
| ERRORS_LIMIT | NUMBER | (10) | ||
| ROWS_POSTED | NUMBER | (10) | ||
| ABORT_REASON | VARCHAR2 | (70) | ||
| CREATION_DATE | DATE | Yes | ||
| CREATED_BY | NUMBER | (15) | Yes | |
| LAST_UPDATE_DATE | DATE | Yes | ||
| LAST_UPDATED_BY | NUMBER | (15) | Yes | |
| LAST_UPDATE_LOGIN | NUMBER | (15) | ||
| DELETE_MARK | NUMBER | (5) | Yes | |
| IN_USE | NUMBER | (5) | ||
| PROGRAM_APPLICATION_ID | NUMBER | (15) | ||
| PROGRAM_ID | NUMBER | (15) | ||
| PROGRAM_UPDATE_DATE | DATE | |||
| REQUEST_ID | NUMBER | (15) | ||
| POST_OM | NUMBER | (5) | ||
| INCL_NO_COST | NUMBER | (5) | ||
| POST_PUR | NUMBER | (5) | ||
| DEFAULT_LANGUAGE | VARCHAR2 | (4) | ||
| CREV_CURR_CALENDAR | VARCHAR2 | (10) | ||
| CREV_CURR_MTHD | VARCHAR2 | (10) | ||
| CREV_CURR_PERIOD | VARCHAR2 | (10) | ||
| CREV_GL_TRANS_DATE | DATE | |||
| CREV_INV_PREV_CAL | VARCHAR2 | (10) | ||
| CREV_INV_PREV_PER | NUMBER | (15) | ||
| CREV_PREV_CALENDAR | VARCHAR2 | (10) | ||
| CREV_PREV_MTHD | VARCHAR2 | (10) | ||
| CREV_PREV_PERIOD | VARCHAR2 | (10) | ||
| BASE_CURRENCY | VARCHAR2 | (15) | ||
| COST_BASIS | NUMBER | |||
| COST_MTHD_CODE | VARCHAR2 | (10) | ||
| COST_TYPE | NUMBER | |||
| COST_TYPE_ID | NUMBER | |||
| CREV_CURR_COST_TYPE_ID | NUMBER | |||
| CREV_CURR_PERIOD_ID | NUMBER | |||
| CREV_PREV_COST_TYPE_ID | NUMBER | |||
| CREV_PREV_PERIOD_ID | NUMBER | |||
| DEFAULT_COST_MTHD_CODE | VARCHAR2 | (10) | ||
| DEFAULT_COST_TYPE_ID | NUMBER | |||
| EXTRACT_HDR_ROWS_POSTED | NUMBER | |||
| EXTRACT_LINE_ROWS_POSTED | NUMBER | |||
| LEDGER_ID | NUMBER | |||
| LEGAL_ENTITY_ID | NUMBER | |||
| LEGAL_ENTITY_NAME | VARCHAR2 | (240) | ||
| PERIOD_ID | NUMBER | (15) | ||
| PROCESS_CATEGORY | VARCHAR2 | (100) | ||
| POST_CM_CADJ | NUMBER | (5) | ||
| POST_CM_RVAL | NUMBER | (5) | ||
| POST_GL_ALOC | NUMBER | (5) | ||
| BATCH_ID_FROM | NUMBER | |||
| BATCH_ID_TO | NUMBER | |||
| NUM_OF_PROCESS | NUMBER | (5) | ||
| POST_TXN_CMPT_COST | NUMBER | (5) |
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#;
GMF
GL_SUBR_STA
APPS
GL_SUBR_STA
|
|
|
|