DBA Data[Home] [Help] [Dependency Information]

TABLE: GL.GL_UPDATE_RECOVERY_H

Object Details
Object Name: GL_UPDATE_RECOVERY_H
Object Type: TABLE
Owner: GL
FND Design Data: TableSQLGL.GL_UPDATE_RECOVERY_H
Subobject Name:
Status: VALID


The GL_UPDATE_RECOVERY_H table stores the original values of the columns whose contents have been changed by the update. Each row in the table includes the name of the updated table, the name of the updated column, the value that was in the updated column before the update, and the name of the script that did the update.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
GL_UPDATE_RECOVERY_H_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnOBJECT_NAME
ColumnCOLUMN_NAME
ColumnUPDATE_SCRIPT_NAME
ColumnPRIMARY_KEY_VALUE
Columns
Name Datatype Length Mandatory Comments
OBJECT_NAME VARCHAR2 (30) Yes Object name
COLUMN_NAME VARCHAR2 (30) Yes Column name
PREUPDATE_COLUMN_VALUE VARCHAR2 (255) Yes Column value before the update
PRIMARY_KEY_VALUE VARCHAR2 (2000) Yes Primary key value of the object
UPDATE_SCRIPT_NAME VARCHAR2 (30) Yes Name of the script that updated the object
LAST_UPDATE_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER
Yes Standard Who column
CREATION_DATE DATE
Yes Standard Who column
CREATED_BY NUMBER
Yes Standard Who column
LAST_UPDATE_LOGIN NUMBER

Standard Who column
Query Text

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


SELECT OBJECT_NAME
,      COLUMN_NAME
,      PREUPDATE_COLUMN_VALUE
,      PRIMARY_KEY_VALUE
,      UPDATE_SCRIPT_NAME
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
FROM GL.GL_UPDATE_RECOVERY_H;

Dependencies

[top of page]

GL.GL_UPDATE_RECOVERY_H does not reference any database object

GL.GL_UPDATE_RECOVERY_H is referenced by following:

SchemaGL
ViewGL_UPDATE_RECOVERY_H#