[Home] [Help] [Dependency Information]
Object Name: | MTH_PRODUCTION_SEGMENTS_EXT_B# |
---|---|
Object Type: | VIEW |
Owner: | MTH |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
EXTENSION_ID | NUMBER | Yes | ||
CREATION_DATE | DATE | Yes | ||
LAST_UPDATE_DATE | DATE | Yes | ||
CREATED_BY | NUMBER | (15) | Yes | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | |
ATTR_GROUP_ID | NUMBER | |||
SEGMENT_PK_KEY | NUMBER | |||
C_EXT_ATTR1 | VARCHAR2 | (255) | ||
C_EXT_ATTR2 | VARCHAR2 | (255) | ||
C_EXT_ATTR3 | VARCHAR2 | (255) | ||
C_EXT_ATTR4 | VARCHAR2 | (255) | ||
C_EXT_ATTR5 | VARCHAR2 | (255) | ||
C_EXT_ATTR6 | VARCHAR2 | (255) | ||
C_EXT_ATTR7 | VARCHAR2 | (255) | ||
C_EXT_ATTR8 | VARCHAR2 | (255) | ||
C_EXT_ATTR9 | VARCHAR2 | (255) | ||
C_EXT_ATTR10 | VARCHAR2 | (255) | ||
C_EXT_ATTR11 | VARCHAR2 | (255) | ||
C_EXT_ATTR12 | VARCHAR2 | (255) | ||
C_EXT_ATTR13 | VARCHAR2 | (255) | ||
C_EXT_ATTR14 | VARCHAR2 | (255) | ||
C_EXT_ATTR15 | VARCHAR2 | (255) | ||
C_EXT_ATTR16 | VARCHAR2 | (255) | ||
C_EXT_ATTR17 | VARCHAR2 | (255) | ||
C_EXT_ATTR18 | VARCHAR2 | (255) | ||
C_EXT_ATTR19 | VARCHAR2 | (255) | ||
C_EXT_ATTR20 | VARCHAR2 | (255) | ||
C_EXT_ATTR21 | VARCHAR2 | (255) | ||
C_EXT_ATTR22 | VARCHAR2 | (255) | ||
C_EXT_ATTR23 | VARCHAR2 | (255) | ||
C_EXT_ATTR24 | VARCHAR2 | (255) | ||
C_EXT_ATTR25 | VARCHAR2 | (255) | ||
C_EXT_ATTR26 | VARCHAR2 | (255) | ||
C_EXT_ATTR27 | VARCHAR2 | (255) | ||
C_EXT_ATTR28 | VARCHAR2 | (255) | ||
C_EXT_ATTR29 | VARCHAR2 | (255) | ||
C_EXT_ATTR30 | VARCHAR2 | (255) | ||
N_EXT_ATTR1 | NUMBER | |||
N_EXT_ATTR2 | NUMBER | |||
N_EXT_ATTR3 | NUMBER | |||
N_EXT_ATTR4 | NUMBER | |||
N_EXT_ATTR5 | NUMBER | |||
N_EXT_ATTR6 | NUMBER | |||
N_EXT_ATTR7 | NUMBER | |||
N_EXT_ATTR8 | NUMBER | |||
N_EXT_ATTR9 | NUMBER | |||
N_EXT_ATTR10 | NUMBER | |||
N_EXT_ATTR11 | NUMBER | |||
N_EXT_ATTR12 | NUMBER | |||
N_EXT_ATTR13 | NUMBER | |||
N_EXT_ATTR14 | NUMBER | |||
N_EXT_ATTR15 | NUMBER | |||
N_EXT_ATTR16 | NUMBER | |||
N_EXT_ATTR17 | NUMBER | |||
N_EXT_ATTR18 | NUMBER | |||
N_EXT_ATTR19 | NUMBER | |||
N_EXT_ATTR20 | NUMBER | |||
D_EXT_ATTR1 | DATE | |||
D_EXT_ATTR2 | DATE | |||
D_EXT_ATTR3 | DATE | |||
D_EXT_ATTR4 | DATE | |||
D_EXT_ATTR5 | DATE | |||
D_EXT_ATTR6 | DATE | |||
D_EXT_ATTR7 | DATE | |||
D_EXT_ATTR8 | DATE | |||
D_EXT_ATTR9 | DATE | |||
D_EXT_ATTR10 | DATE | |||
D_EXT_ATTR11 | DATE | |||
D_EXT_ATTR12 | DATE | |||
D_EXT_ATTR13 | DATE | |||
D_EXT_ATTR14 | DATE | |||
D_EXT_ATTR15 | DATE | |||
D_EXT_ATTR16 | DATE | |||
D_EXT_ATTR17 | DATE | |||
D_EXT_ATTR18 | DATE | |||
D_EXT_ATTR19 | DATE | |||
D_EXT_ATTR20 | DATE | |||
WORKORDER_FK_KEY | NUMBER | |||
ITEM_FK_KEY | NUMBER | |||
TRANSIENT | VARCHAR2 | (2) | ||
READ_TIME | DATE | |||
LAST_UPDATE_LOGIN | NUMBER | (15) |
Cut, paste (and edit) the following text to query this object:
SELECT EXTENSION_ID
, CREATION_DATE
, LAST_UPDATE_DATE
, CREATED_BY
, LAST_UPDATED_BY
, ATTR_GROUP_ID
, SEGMENT_PK_KEY
, C_EXT_ATTR1
, C_EXT_ATTR2
, C_EXT_ATTR3
, C_EXT_ATTR4
, C_EXT_ATTR5
, C_EXT_ATTR6
, C_EXT_ATTR7
, C_EXT_ATTR8
, C_EXT_ATTR9
, C_EXT_ATTR10
, C_EXT_ATTR11
, C_EXT_ATTR12
, C_EXT_ATTR13
, C_EXT_ATTR14
, C_EXT_ATTR15
, C_EXT_ATTR16
, C_EXT_ATTR17
, C_EXT_ATTR18
, C_EXT_ATTR19
, C_EXT_ATTR20
, C_EXT_ATTR21
, C_EXT_ATTR22
, C_EXT_ATTR23
, C_EXT_ATTR24
, C_EXT_ATTR25
, C_EXT_ATTR26
, C_EXT_ATTR27
, C_EXT_ATTR28
, C_EXT_ATTR29
, C_EXT_ATTR30
, N_EXT_ATTR1
, N_EXT_ATTR2
, N_EXT_ATTR3
, N_EXT_ATTR4
, N_EXT_ATTR5
, N_EXT_ATTR6
, N_EXT_ATTR7
, N_EXT_ATTR8
, N_EXT_ATTR9
, N_EXT_ATTR10
, N_EXT_ATTR11
, N_EXT_ATTR12
, N_EXT_ATTR13
, N_EXT_ATTR14
, N_EXT_ATTR15
, N_EXT_ATTR16
, N_EXT_ATTR17
, N_EXT_ATTR18
, N_EXT_ATTR19
, N_EXT_ATTR20
, D_EXT_ATTR1
, D_EXT_ATTR2
, D_EXT_ATTR3
, D_EXT_ATTR4
, D_EXT_ATTR5
, D_EXT_ATTR6
, D_EXT_ATTR7
, D_EXT_ATTR8
, D_EXT_ATTR9
, D_EXT_ATTR10
, D_EXT_ATTR11
, D_EXT_ATTR12
, D_EXT_ATTR13
, D_EXT_ATTR14
, D_EXT_ATTR15
, D_EXT_ATTR16
, D_EXT_ATTR17
, D_EXT_ATTR18
, D_EXT_ATTR19
, D_EXT_ATTR20
, WORKORDER_FK_KEY
, ITEM_FK_KEY
, TRANSIENT
, READ_TIME
, LAST_UPDATE_LOGIN
FROM MTH.MTH_PRODUCTION_SEGMENTS_EXT_B#;
|
|
|