[Home] [Help] [Dependency Information]
Object Name: | AD_TIMESTAMPS |
---|---|
Object Type: | TABLE |
Owner: | APPLSYS |
FND Design Data: | AD.AD_TIMESTAMPS |
Subobject Name: | |
Status: | VALID |
In some cases this table is used for incremental functionality: a given feature only processes objects that have changed since the last time indicated by the timestamp for the relevant row in this table. In other cases this table is just used to track that a given operation has taken place, and the timestamp is not important.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
AD_TIMESTAMPS_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
TYPE
ATTRIBUTE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TYPE | VARCHAR2 | (50) | Yes | The general category for this row |
ATTRIBUTE | VARCHAR2 | (50) | Yes | The sub-category for this row |
TIMESTAMP | DATE | Yes | When was this row inserted or last updated | |
ATTRIBUTE1 | VARCHAR2 | (255) | Descriptive flexfield segment | |
ATTRIBUTE2 | VARCHAR2 | (255) | Descriptive flexfield segment | |
ATTRIBUTE3 | VARCHAR2 | (255) | Descriptive flexfield segment | |
ATTRIBUTE4 | VARCHAR2 | (255) | Descriptive flexfield segment | |
ATTRIBUTE5 | VARCHAR2 | (255) | Descriptive flexfield segment | |
ATTRIBUTE6 | VARCHAR2 | (255) | Descriptive flexfield segment | |
ATTRIBUTE7 | VARCHAR2 | (255) | Descriptive flexfield segment | |
ATTRIBUTE8 | VARCHAR2 | (255) | Descriptive flexfield segment | |
ATTRIBUTE9 | VARCHAR2 | (255) | Descriptive flexfield segment | |
ATTRIBUTE10 | VARCHAR2 | (255) | Descriptive flexfield segment |
Cut, paste (and edit) the following text to query this object:
SELECT TYPE
, ATTRIBUTE
, TIMESTAMP
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
FROM APPLSYS.AD_TIMESTAMPS;
APPLSYS.AD_TIMESTAMPS does not reference any database object
APPLSYS.AD_TIMESTAMPS is referenced by following:
|
|
|