[Home] [Help] [Dependency Information]
Object Name: | AS_EVENT_DATA |
---|---|
Object Type: | TABLE |
Owner: | OSM |
FND Design Data: | AS.AS_EVENT_DATA |
Subobject Name: | |
Status: | VALID |
AS_EVENT_DATA is a table for temporarily storing old and new event data for use by event subscription functions to business events raised by Oracle Sales applications
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
AS_EVENT_DATA_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | EVENT_DATA_ID |
AS_EVENT_DATA_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
EVENT_KEY
OBJECT_STATE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
EVENT_DATA_ID | NUMBER | Yes | Event Data identifier | |
EVENT_KEY | VARCHAR2 | (240) | Yes | Key identifying the event |
OBJECT_STATE | VARCHAR2 | (3) | Yes | Identifies if the event data is OLD or NEW |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column - date when a user last updated this row. | |
CREATION_DATE | DATE | Yes | Standard who column. | |
LAST_UPDATED_BY | NUMBER | Yes | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | |
CREATED_BY | NUMBER | Yes | Standard who column. | |
LAST_UPDATE_LOGIN | NUMBER | Yes | Standard who column. | |
CHAR01 | VARCHAR2 | (520) | Generic field for storing data for columns of type string | |
CHAR02 | VARCHAR2 | (520) | Generic field for storing data for columns of type string | |
CHAR03 | VARCHAR2 | (520) | Generic field for storing data for columns of type string | |
CHAR04 | VARCHAR2 | (520) | Generic field for storing data for columns of type string | |
CHAR05 | VARCHAR2 | (520) | Generic field for storing data for columns of type string | |
CHAR06 | VARCHAR2 | (520) | Generic field for storing data for columns of type string | |
CHAR07 | VARCHAR2 | (520) | Generic field for storing data for columns of type string | |
CHAR08 | VARCHAR2 | (520) | Generic field for storing data for columns of type string | |
CHAR09 | VARCHAR2 | (520) | Generic field for storing data for columns of type string | |
CHAR10 | VARCHAR2 | (520) | Generic field for storing data for columns of type string | |
CHAR11 | VARCHAR2 | (520) | Generic field for storing data for columns of type string | |
CHAR12 | VARCHAR2 | (520) | Generic field for storing data for columns of type string | |
CHAR13 | VARCHAR2 | (520) | Generic field for storing data for columns of type string | |
CHAR14 | VARCHAR2 | (520) | Generic field for storing data for columns of type string | |
CHAR15 | VARCHAR2 | (520) | Generic field for storing data for columns of type string | |
CHAR16 | VARCHAR2 | (520) | Generic field for storing data for columns of type string | |
CHAR17 | VARCHAR2 | (520) | Generic field for storing data for columns of type string | |
CHAR18 | VARCHAR2 | (520) | Generic field for storing data for columns of type string | |
CHAR19 | VARCHAR2 | (520) | Generic field for storing data for columns of type string | |
CHAR20 | VARCHAR2 | (520) | Generic field for storing data for columns of type string | |
CHAR21 | VARCHAR2 | (520) | Generic field for storing data for columns of type string | |
CHAR22 | VARCHAR2 | (520) | Generic field for storing data for columns of type string | |
CHAR23 | VARCHAR2 | (520) | Generic field for storing data for columns of type string | |
CHAR24 | VARCHAR2 | (520) | Generic field for storing data for columns of type string | |
CHAR25 | VARCHAR2 | (520) | Generic field for storing data for columns of type string | |
CHAR26 | VARCHAR2 | (520) | Generic field for storing data for columns of type string | |
CHAR27 | VARCHAR2 | (520) | Generic field for storing data for columns of type string | |
CHAR28 | VARCHAR2 | (520) | Generic field for storing data for columns of type string | |
CHAR29 | VARCHAR2 | (520) | Generic field for storing data for columns of type string | |
CHAR30 | VARCHAR2 | (520) | Generic field for storing data for columns of type string | |
CHAR31 | VARCHAR2 | (520) | Generic field for storing data for columns of type string | |
CHAR32 | VARCHAR2 | (520) | Generic field for storing data for columns of type string | |
CHAR33 | VARCHAR2 | (520) | Generic field for storing data for columns of type string | |
CHAR34 | VARCHAR2 | (520) | Generic field for storing data for columns of type string | |
CHAR35 | VARCHAR2 | (520) | Generic field for storing data for columns of type string | |
CHAR36 | VARCHAR2 | (520) | Generic field for storing data for columns of type string | |
CHAR37 | VARCHAR2 | (520) | Generic field for storing data for columns of type string | |
CHAR38 | VARCHAR2 | (520) | Generic field for storing data for columns of type string | |
CHAR39 | VARCHAR2 | (520) | Generic field for storing data for columns of type string | |
CHAR40 | VARCHAR2 | (520) | Generic field for storing data for columns of type string | |
CHAR41 | VARCHAR2 | (520) | Generic field for storing data for columns of type string | |
CHAR42 | VARCHAR2 | (520) | Generic field for storing data for columns of type string | |
CHAR43 | VARCHAR2 | (520) | Generic field for storing data for columns of type string | |
CHAR44 | VARCHAR2 | (520) | Generic field for storing data for columns of type string | |
CHAR45 | VARCHAR2 | (520) | Generic field for storing data for columns of type string | |
CHAR46 | VARCHAR2 | (520) | Generic field for storing data for columns of type string | |
CHAR47 | VARCHAR2 | (520) | Generic field for storing data for columns of type string | |
CHAR48 | VARCHAR2 | (520) | Generic field for storing data for columns of type string | |
CHAR49 | VARCHAR2 | (520) | Generic field for storing data for columns of type string | |
CHAR50 | VARCHAR2 | (520) | Generic field for storing data for columns of type string | |
CHAR51 | VARCHAR2 | (520) | Generic field for storing data for columns of type string | |
CHAR52 | VARCHAR2 | (520) | Generic field for storing data for columns of type string | |
CHAR53 | VARCHAR2 | (520) | Generic field for storing data for columns of type string | |
CHAR54 | VARCHAR2 | (520) | Generic field for storing data for columns of type string | |
CHAR55 | VARCHAR2 | (520) | Generic field for storing data for columns of type string | |
CHAR56 | VARCHAR2 | (520) | Generic field for storing data for columns of type string | |
CHAR57 | VARCHAR2 | (520) | Generic field for storing data for columns of type string | |
CHAR58 | VARCHAR2 | (520) | Generic field for storing data for columns of type string | |
CHAR59 | VARCHAR2 | (520) | Generic field for storing data for columns of type string | |
CHAR60 | VARCHAR2 | (520) | Generic field for storing data for columns of type string | |
CHAR61 | VARCHAR2 | (520) | Generic field for storing data for columns of type string | |
CHAR62 | VARCHAR2 | (520) | Generic field for storing data for columns of type string | |
CHAR63 | VARCHAR2 | (520) | Generic field for storing data for columns of type string | |
CHAR64 | VARCHAR2 | (520) | Generic field for storing data for columns of type string | |
CHAR65 | VARCHAR2 | (520) | Generic field for storing data for columns of type string | |
CHAR66 | VARCHAR2 | (520) | Generic field for storing data for columns of type string | |
CHAR67 | VARCHAR2 | (520) | Generic field for storing data for columns of type string | |
CHAR68 | VARCHAR2 | (520) | Generic field for storing data for columns of type string | |
CHAR69 | VARCHAR2 | (520) | Generic field for storing data for columns of type string | |
CHAR70 | VARCHAR2 | (520) | Generic field for storing data for columns of type string | |
CHAR71 | VARCHAR2 | (520) | Generic field for storing data for columns of type string | |
CHAR72 | VARCHAR2 | (520) | Generic field for storing data for columns of type string | |
CHAR73 | VARCHAR2 | (520) | Generic field for storing data for columns of type string | |
CHAR74 | VARCHAR2 | (520) | Generic field for storing data for columns of type string | |
CHAR75 | VARCHAR2 | (520) | Generic field for storing data for columns of type string | |
CHAR76 | VARCHAR2 | (520) | Generic field for storing data for columns of type string | |
CHAR77 | VARCHAR2 | (520) | Generic field for storing data for columns of type string | |
CHAR78 | VARCHAR2 | (520) | Generic field for storing data for columns of type string | |
CHAR79 | VARCHAR2 | (520) | Generic field for storing data for columns of type string | |
CHAR80 | VARCHAR2 | (520) | Generic field for storing data for columns of type string | |
NUM01 | NUMBER | Generic field for storing data for columns of type number | ||
NUM02 | NUMBER | Generic field for storing data for columns of type number | ||
NUM03 | NUMBER | Generic field for storing data for columns of type number | ||
NUM04 | NUMBER | Generic field for storing data for columns of type number | ||
NUM05 | NUMBER | Generic field for storing data for columns of type number | ||
NUM06 | NUMBER | Generic field for storing data for columns of type number | ||
NUM07 | NUMBER | Generic field for storing data for columns of type number | ||
NUM08 | NUMBER | Generic field for storing data for columns of type number | ||
NUM09 | NUMBER | Generic field for storing data for columns of type number | ||
NUM10 | NUMBER | Generic field for storing data for columns of type number | ||
NUM11 | NUMBER | Generic field for storing data for columns of type number | ||
NUM12 | NUMBER | Generic field for storing data for columns of type number | ||
NUM13 | NUMBER | Generic field for storing data for columns of type number | ||
NUM14 | NUMBER | Generic field for storing data for columns of type number | ||
NUM15 | NUMBER | Generic field for storing data for columns of type number | ||
NUM16 | NUMBER | Generic field for storing data for columns of type number | ||
NUM17 | NUMBER | Generic field for storing data for columns of type number | ||
NUM18 | NUMBER | Generic field for storing data for columns of type number | ||
NUM19 | NUMBER | Generic field for storing data for columns of type number | ||
NUM20 | NUMBER | Generic field for storing data for columns of type number | ||
NUM21 | NUMBER | Generic field for storing data for columns of type number | ||
NUM22 | NUMBER | Generic field for storing data for columns of type number | ||
NUM23 | NUMBER | Generic field for storing data for columns of type number | ||
NUM24 | NUMBER | Generic field for storing data for columns of type number | ||
NUM25 | NUMBER | Generic field for storing data for columns of type number | ||
NUM26 | NUMBER | Generic field for storing data for columns of type number | ||
NUM27 | NUMBER | Generic field for storing data for columns of type number | ||
NUM28 | NUMBER | Generic field for storing data for columns of type number | ||
NUM29 | NUMBER | Generic field for storing data for columns of type number | ||
NUM30 | NUMBER | Generic field for storing data for columns of type number | ||
DATE01 | DATE | Generic field for storing data for columns of type date | ||
DATE02 | DATE | Generic field for storing data for columns of type date | ||
DATE03 | DATE | Generic field for storing data for columns of type date | ||
DATE04 | DATE | Generic field for storing data for columns of type date | ||
DATE05 | DATE | Generic field for storing data for columns of type date | ||
DATE06 | DATE | Generic field for storing data for columns of type date | ||
DATE07 | DATE | Generic field for storing data for columns of type date | ||
DATE08 | DATE | Generic field for storing data for columns of type date | ||
DATE09 | DATE | Generic field for storing data for columns of type date | ||
DATE10 | DATE | Generic field for storing data for columns of type date | ||
DATE11 | DATE | Generic field for storing data for columns of type date | ||
DATE12 | DATE | Generic field for storing data for columns of type date | ||
DATE13 | DATE | Generic field for storing data for columns of type date | ||
DATE14 | DATE | Generic field for storing data for columns of type date | ||
DATE15 | DATE | Generic field for storing data for columns of type date |
Cut, paste (and edit) the following text to query this object:
SELECT EVENT_DATA_ID
, EVENT_KEY
, OBJECT_STATE
, LAST_UPDATE_DATE
, CREATION_DATE
, LAST_UPDATED_BY
, CREATED_BY
, LAST_UPDATE_LOGIN
, CHAR01
, CHAR02
, CHAR03
, CHAR04
, CHAR05
, CHAR06
, CHAR07
, CHAR08
, CHAR09
, CHAR10
, CHAR11
, CHAR12
, CHAR13
, CHAR14
, CHAR15
, CHAR16
, CHAR17
, CHAR18
, CHAR19
, CHAR20
, CHAR21
, CHAR22
, CHAR23
, CHAR24
, CHAR25
, CHAR26
, CHAR27
, CHAR28
, CHAR29
, CHAR30
, CHAR31
, CHAR32
, CHAR33
, CHAR34
, CHAR35
, CHAR36
, CHAR37
, CHAR38
, CHAR39
, CHAR40
, CHAR41
, CHAR42
, CHAR43
, CHAR44
, CHAR45
, CHAR46
, CHAR47
, CHAR48
, CHAR49
, CHAR50
, CHAR51
, CHAR52
, CHAR53
, CHAR54
, CHAR55
, CHAR56
, CHAR57
, CHAR58
, CHAR59
, CHAR60
, CHAR61
, CHAR62
, CHAR63
, CHAR64
, CHAR65
, CHAR66
, CHAR67
, CHAR68
, CHAR69
, CHAR70
, CHAR71
, CHAR72
, CHAR73
, CHAR74
, CHAR75
, CHAR76
, CHAR77
, CHAR78
, CHAR79
, CHAR80
, NUM01
, NUM02
, NUM03
, NUM04
, NUM05
, NUM06
, NUM07
, NUM08
, NUM09
, NUM10
, NUM11
, NUM12
, NUM13
, NUM14
, NUM15
, NUM16
, NUM17
, NUM18
, NUM19
, NUM20
, NUM21
, NUM22
, NUM23
, NUM24
, NUM25
, NUM26
, NUM27
, NUM28
, NUM29
, NUM30
, DATE01
, DATE02
, DATE03
, DATE04
, DATE05
, DATE06
, DATE07
, DATE08
, DATE09
, DATE10
, DATE11
, DATE12
, DATE13
, DATE14
, DATE15
FROM OSM.AS_EVENT_DATA;
OSM.AS_EVENT_DATA does not reference any database object
OSM.AS_EVENT_DATA is referenced by following:
|
|
|