[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | AS_EVENT_DATA# |
|---|---|
| Object Type: | VIEW |
| Owner: | OSM |
| Subobject Name: | |
| Status: | VALID |
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| EVENT_DATA_ID | NUMBER | Yes | ||
| EVENT_KEY | VARCHAR2 | (240) | Yes | |
| OBJECT_STATE | VARCHAR2 | (3) | Yes | |
| LAST_UPDATE_DATE | DATE | Yes | ||
| CREATION_DATE | DATE | Yes | ||
| LAST_UPDATED_BY | NUMBER | Yes | ||
| CREATED_BY | NUMBER | Yes | ||
| LAST_UPDATE_LOGIN | NUMBER | Yes | ||
| CHAR01 | VARCHAR2 | (520) | ||
| CHAR02 | VARCHAR2 | (520) | ||
| CHAR03 | VARCHAR2 | (520) | ||
| CHAR04 | VARCHAR2 | (520) | ||
| CHAR05 | VARCHAR2 | (520) | ||
| CHAR06 | VARCHAR2 | (520) | ||
| CHAR07 | VARCHAR2 | (520) | ||
| CHAR08 | VARCHAR2 | (520) | ||
| CHAR09 | VARCHAR2 | (520) | ||
| CHAR10 | VARCHAR2 | (520) | ||
| CHAR11 | VARCHAR2 | (520) | ||
| CHAR12 | VARCHAR2 | (520) | ||
| CHAR13 | VARCHAR2 | (520) | ||
| CHAR14 | VARCHAR2 | (520) | ||
| CHAR15 | VARCHAR2 | (520) | ||
| CHAR16 | VARCHAR2 | (520) | ||
| CHAR17 | VARCHAR2 | (520) | ||
| CHAR18 | VARCHAR2 | (520) | ||
| CHAR19 | VARCHAR2 | (520) | ||
| CHAR20 | VARCHAR2 | (520) | ||
| CHAR21 | VARCHAR2 | (520) | ||
| CHAR22 | VARCHAR2 | (520) | ||
| CHAR23 | VARCHAR2 | (520) | ||
| CHAR24 | VARCHAR2 | (520) | ||
| CHAR25 | VARCHAR2 | (520) | ||
| CHAR26 | VARCHAR2 | (520) | ||
| CHAR27 | VARCHAR2 | (520) | ||
| CHAR28 | VARCHAR2 | (520) | ||
| CHAR29 | VARCHAR2 | (520) | ||
| CHAR30 | VARCHAR2 | (520) | ||
| CHAR31 | VARCHAR2 | (520) | ||
| CHAR32 | VARCHAR2 | (520) | ||
| CHAR33 | VARCHAR2 | (520) | ||
| CHAR34 | VARCHAR2 | (520) | ||
| CHAR35 | VARCHAR2 | (520) | ||
| CHAR36 | VARCHAR2 | (520) | ||
| CHAR37 | VARCHAR2 | (520) | ||
| CHAR38 | VARCHAR2 | (520) | ||
| CHAR39 | VARCHAR2 | (520) | ||
| CHAR40 | VARCHAR2 | (520) | ||
| CHAR41 | VARCHAR2 | (520) | ||
| CHAR42 | VARCHAR2 | (520) | ||
| CHAR43 | VARCHAR2 | (520) | ||
| CHAR44 | VARCHAR2 | (520) | ||
| CHAR45 | VARCHAR2 | (520) | ||
| CHAR46 | VARCHAR2 | (520) | ||
| CHAR47 | VARCHAR2 | (520) | ||
| CHAR48 | VARCHAR2 | (520) | ||
| CHAR49 | VARCHAR2 | (520) | ||
| CHAR50 | VARCHAR2 | (520) | ||
| CHAR51 | VARCHAR2 | (520) | ||
| CHAR52 | VARCHAR2 | (520) | ||
| CHAR53 | VARCHAR2 | (520) | ||
| CHAR54 | VARCHAR2 | (520) | ||
| CHAR55 | VARCHAR2 | (520) | ||
| CHAR56 | VARCHAR2 | (520) | ||
| CHAR57 | VARCHAR2 | (520) | ||
| CHAR58 | VARCHAR2 | (520) | ||
| CHAR59 | VARCHAR2 | (520) | ||
| CHAR60 | VARCHAR2 | (520) | ||
| CHAR61 | VARCHAR2 | (520) | ||
| CHAR62 | VARCHAR2 | (520) | ||
| CHAR63 | VARCHAR2 | (520) | ||
| CHAR64 | VARCHAR2 | (520) | ||
| CHAR65 | VARCHAR2 | (520) | ||
| CHAR66 | VARCHAR2 | (520) | ||
| CHAR67 | VARCHAR2 | (520) | ||
| CHAR68 | VARCHAR2 | (520) | ||
| CHAR69 | VARCHAR2 | (520) | ||
| CHAR70 | VARCHAR2 | (520) | ||
| CHAR71 | VARCHAR2 | (520) | ||
| CHAR72 | VARCHAR2 | (520) | ||
| CHAR73 | VARCHAR2 | (520) | ||
| CHAR74 | VARCHAR2 | (520) | ||
| CHAR75 | VARCHAR2 | (520) | ||
| CHAR76 | VARCHAR2 | (520) | ||
| CHAR77 | VARCHAR2 | (520) | ||
| CHAR78 | VARCHAR2 | (520) | ||
| CHAR79 | VARCHAR2 | (520) | ||
| CHAR80 | VARCHAR2 | (520) | ||
| NUM01 | NUMBER | |||
| NUM02 | NUMBER | |||
| NUM03 | NUMBER | |||
| NUM04 | NUMBER | |||
| NUM05 | NUMBER | |||
| NUM06 | NUMBER | |||
| NUM07 | NUMBER | |||
| NUM08 | NUMBER | |||
| NUM09 | NUMBER | |||
| NUM10 | NUMBER | |||
| NUM11 | NUMBER | |||
| NUM12 | NUMBER | |||
| NUM13 | NUMBER | |||
| NUM14 | NUMBER | |||
| NUM15 | NUMBER | |||
| NUM16 | NUMBER | |||
| NUM17 | NUMBER | |||
| NUM18 | NUMBER | |||
| NUM19 | NUMBER | |||
| NUM20 | NUMBER | |||
| NUM21 | NUMBER | |||
| NUM22 | NUMBER | |||
| NUM23 | NUMBER | |||
| NUM24 | NUMBER | |||
| NUM25 | NUMBER | |||
| NUM26 | NUMBER | |||
| NUM27 | NUMBER | |||
| NUM28 | NUMBER | |||
| NUM29 | NUMBER | |||
| NUM30 | NUMBER | |||
| DATE01 | DATE | |||
| DATE02 | DATE | |||
| DATE03 | DATE | |||
| DATE04 | DATE | |||
| DATE05 | DATE | |||
| DATE06 | DATE | |||
| DATE07 | DATE | |||
| DATE08 | DATE | |||
| DATE09 | DATE | |||
| DATE10 | DATE | |||
| DATE11 | DATE | |||
| DATE12 | DATE | |||
| DATE13 | DATE | |||
| DATE14 | DATE | |||
| DATE15 | 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
APPS
AS_EVENT_DATA
|
|
|
|