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

TABLE: APPLSYS.AD_EVENTS

Object Details
Object Name: AD_EVENTS
Object Type: TABLE
Owner: APPLSYS
FND Design Data: TableAD.AD_EVENTS
Subobject Name:
Status: VALID


Contains information on events. An event is something that can be tracked and is typically associated with a task whose execution status needs to be tracked. An event is associated with one or more state values and undergoes state changes during its life cycle.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
AD_EVENTS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnEVENT_CONTEXT
ColumnEVENT_NAME
ColumnOWNER
Columns
Name Datatype Length Mandatory Comments
EVENT_ID NUMBER
Yes Unique id of event
OWNER VARCHAR2 (30) Yes Owner of event
EVENT_NAME VARCHAR2 (50) Yes Name of event
EVENT_CONTEXT VARCHAR2 (30) Yes Context of event
EVENT_TYPE VARCHAR2 (30) Yes Type of event
LAST_VERSION NUMBER
Yes Latest version of event
CREATION_DATE DATE

Standard who column - date when this row was created.
LAST_UPDATE_DATE DATE

Standard Who column - date when a user last updated this row.
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 EVENT_ID
,      OWNER
,      EVENT_NAME
,      EVENT_CONTEXT
,      EVENT_TYPE
,      LAST_VERSION
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      CREATED_BY
,      LAST_UPDATED_BY
FROM APPLSYS.AD_EVENTS;

Dependencies

[top of page]

APPLSYS.AD_EVENTS does not reference any database object

APPLSYS.AD_EVENTS is referenced by following:

SchemaAPPLSYS
ViewAD_EVENTS#