Skip to content

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

TABLE: OSM.AS_EVENT_DATA

Object Details
Object Name: AS_EVENT_DATA
Object Type: TABLE
Owner: OSM
FND Design Data: TableAS.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


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
AS_EVENT_DATA_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnEVENT_DATA_ID
AS_EVENT_DATA_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnEVENT_KEY
ColumnOBJECT_STATE
Columns
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
Query Text

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;

Dependencies

[top of page]

OSM.AS_EVENT_DATA does not reference any database object

OSM.AS_EVENT_DATA is referenced by following:

SchemaOSM
ViewAS_EVENT_DATA#