[Home] [Help] [Dependency Information]
Object Name: | GL_SEGVAL_INHERIT_HISTORY |
---|---|
Object Type: | TABLE |
Owner: | GL |
FND Design Data: | SQLGL.GL_SEGVAL_INHERIT_HISTORY |
Subobject Name: | |
Status: | VALID |
GL_SEGVAL_INHERIT_HISTORY keeps track of the segment value attribute maintenance records for each chart of accounts. For each chart of accounts for which the Segment Value Inheritance program has been run, there exists a row in this table. That row indicates the date and time on which the Segment Value Inheritance program was last run for this chart of accounts.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
GL_SEGVAL_INHERIT_HISTORY_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | CHART_OF_ACCOUNTS_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CHART_OF_ACCOUNTS_ID | NUMBER | (15) | Yes | Key flexfield structure defining column |
LAST_RUN_DATE | DATE | Yes | Date and time on which the Segment Value Inheritance program was last run for this chart of accounts | |
CREATION_DATE | DATE | Yes | Standard Who column | |
CREATED_BY | NUMBER | (15) | Yes | Standard Who column |
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 |
REQUEST_ID | NUMBER | (15) | Enhanced Who column | |
PROGRAM_APPLICATION_ID | NUMBER | (15) | Enhanced Who column | |
PROGRAM_ID | NUMBER | (15) | Enhanced Who column | |
PROGRAM_UPDATE_DATE | DATE | Enhanced Who column |
Cut, paste (and edit) the following text to query this object:
SELECT CHART_OF_ACCOUNTS_ID
, LAST_RUN_DATE
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
FROM GL.GL_SEGVAL_INHERIT_HISTORY;
GL.GL_SEGVAL_INHERIT_HISTORY does not reference any database object
GL.GL_SEGVAL_INHERIT_HISTORY is referenced by following:
|
|
|