[Home] [Help] [Dependency Information]
Object Name: | GL_AUTO_ALLOC_BAT_HIST_DET |
---|---|
Object Type: | TABLE |
Owner: | GL |
FND Design Data: | SQLGL.GL_AUTO_ALLOC_BAT_HIST_DET |
Subobject Name: | |
Status: | VALID |
GL_AUTO_ALLOC_BAT_HIST_DET stores one row for each concurrent program submitted for a batch in the allocation set. The View Allocation Step Status form is based on this table.
RUN_MODE is 'N' if the program is executed for a normal allocation set run or 'R' if the program is executed as part of the rollback process for the allocation set. STATUS_CODE is 'C', 'R','P', or 'F' for Completed, Running, Pending, or Failed, respectively. PROGRAM_NAME_CODE represents the concurrent program executable name.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
GL_AUTO_ALLOC_BAT_HIST_DET_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
PARENT_REQUEST_ID
STEP_NUMBER |
GL_AUTO_ALLOC_BAT_HIST_DET_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | REQUEST_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
REQUEST_ID | NUMBER | Yes | Defining column for submitted concurrent request | |
PROGRAM_NAME_CODE | VARCHAR2 | (150) | Yes | Concurrent program name code |
PARENT_REQUEST_ID | NUMBER | (15) | Yes | Auto allocate concurrent request id |
STEP_NUMBER | NUMBER | (15) | Yes | Sequence in which steps are generated |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who column |
LAST_UPDATE_LOGIN | NUMBER | (15) | Yes | Standard Who column |
CREATION_DATE | DATE | Yes | Standard Who column | |
CREATED_BY | NUMBER | (15) | Yes | Standard Who column |
RUN_MODE | VARCHAR2 | (1) | Normal or Rollback mode | |
STATUS_CODE | VARCHAR2 | (150) | Status of concurrent program |
Cut, paste (and edit) the following text to query this object:
SELECT REQUEST_ID
, PROGRAM_NAME_CODE
, PARENT_REQUEST_ID
, STEP_NUMBER
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATION_DATE
, CREATED_BY
, RUN_MODE
, STATUS_CODE
FROM GL.GL_AUTO_ALLOC_BAT_HIST_DET;
GL.GL_AUTO_ALLOC_BAT_HIST_DET does not reference any database object
GL.GL_AUTO_ALLOC_BAT_HIST_DET is referenced by following:
|
|
|