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

TABLE: APPLSYS.AD_EVENT_TRANSITIONS

Object Details
Object Name: AD_EVENT_TRANSITIONS
Object Type: TABLE
Owner: APPLSYS
Subobject Name:
Status: VALID


Contains history information on various state changes that an event undergoes during its life cycle


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
AD_EVENT_TRANSITIONS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnTRANSITION_ID
AD_EVENT_TRANSITIONS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnVERSION
ColumnEVENT_ID
Columns
Name Datatype Length Mandatory Comments
TRANSITION_ID NUMBER
Yes Unique identifier for the event transition
EVENT_ID NUMBER
Yes Unique id of event
VERSION NUMBER

Version of the event
NEW_STATUS VARCHAR2 (30)
State value of the event after the transition
PRIOR_STATUS VARCHAR2 (30)
State value of the event before the transition
TRANSITION_TIME DATE

Timestamp of the transition
MODULE_NAME VARCHAR2 (30)
Name of the module that caused the transition
WORKER_ID NUMBER

Identifier for the worker that caused the transition
LAST_UPDATE_DATE DATE

Standard Who column - date when a user last updated this row.
CREATION_DATE DATE

Standard who column - date when this row was created.
CREATED_BY NUMBER

Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATED_BY NUMBER

Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
Query Text

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


SELECT TRANSITION_ID
,      EVENT_ID
,      VERSION
,      NEW_STATUS
,      PRIOR_STATUS
,      TRANSITION_TIME
,      MODULE_NAME
,      WORKER_ID
,      LAST_UPDATE_DATE
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATED_BY
FROM APPLSYS.AD_EVENT_TRANSITIONS;

Dependencies

[top of page]

APPLSYS.AD_EVENT_TRANSITIONS does not reference any database object

APPLSYS.AD_EVENT_TRANSITIONS is referenced by following:

SchemaAPPS
SynonymAD_EVENT_TRANSITIONS