[Home] [Help] [Dependency Information]
Object Name: | MTH_PRODUCTION_SEGMENTS_EXT_VL |
---|---|
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
EXTENSION_ID | NUMBER | Yes | System generated surrogate key for the table. This is generated using EGO sequence. | |
SEGMENT_PK_KEY | NUMBER | Reference to Workorder Segment identifier | ||
ATTR_GROUP_ID | NUMBER | Attribute group identifier | ||
CREATED_BY | NUMBER | (15) | Yes | Standard who column |
CREATION_DATE | DATE | Yes | Standard who column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard who column |
LAST_UPDATE_DATE | DATE | Yes | Standard who column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column | |
SOURCE_LANG | VARCHAR2 | (30) | Source language of the data stored in the columns | |
LANGUAGE | VARCHAR2 | (30) | Language of the data stored in the columns | |
C_EXT_ATTR1 | VARCHAR2 | (255) | Column to store extensible attribute character data | |
C_EXT_ATTR2 | VARCHAR2 | (255) | Column to store extensible attribute character data | |
C_EXT_ATTR3 | VARCHAR2 | (255) | Column to store extensible attribute character data | |
C_EXT_ATTR4 | VARCHAR2 | (255) | Column to store extensible attribute character data | |
C_EXT_ATTR5 | VARCHAR2 | (255) | Column to store extensible attribute character data | |
C_EXT_ATTR6 | VARCHAR2 | (255) | Column to store extensible attribute character data | |
C_EXT_ATTR7 | VARCHAR2 | (255) | Column to store extensible attribute character data | |
C_EXT_ATTR8 | VARCHAR2 | (255) | Column to store extensible attribute character data | |
C_EXT_ATTR9 | VARCHAR2 | (255) | Column to store extensible attribute character data | |
C_EXT_ATTR10 | VARCHAR2 | (255) | Column to store extensible attribute character data | |
C_EXT_ATTR11 | VARCHAR2 | (255) | Column to store extensible attribute character data | |
C_EXT_ATTR12 | VARCHAR2 | (255) | Column to store extensible attribute character data | |
C_EXT_ATTR13 | VARCHAR2 | (255) | Column to store extensible attribute character data | |
C_EXT_ATTR14 | VARCHAR2 | (255) | Column to store extensible attribute character data | |
C_EXT_ATTR15 | VARCHAR2 | (255) | Column to store extensible attribute character data | |
C_EXT_ATTR16 | VARCHAR2 | (255) | Column to store extensible attribute character data | |
C_EXT_ATTR17 | VARCHAR2 | (255) | Column to store extensible attribute character data | |
C_EXT_ATTR18 | VARCHAR2 | (255) | Column to store extensible attribute character data | |
C_EXT_ATTR19 | VARCHAR2 | (255) | Column to store extensible attribute character data | |
C_EXT_ATTR20 | VARCHAR2 | (255) | Column to store extensible attribute character data | |
N_EXT_ATTR1 | NUMBER | Column to store extensible attribute number data | ||
N_EXT_ATTR2 | NUMBER | Column to store extensible attribute number data | ||
N_EXT_ATTR3 | NUMBER | Column to store extensible attribute number data | ||
N_EXT_ATTR4 | NUMBER | Column to store extensible attribute number data | ||
N_EXT_ATTR5 | NUMBER | Column to store extensible attribute number data | ||
N_EXT_ATTR6 | NUMBER | Column to store extensible attribute number data | ||
N_EXT_ATTR7 | NUMBER | Column to store extensible attribute number data | ||
N_EXT_ATTR8 | NUMBER | Column to store extensible attribute number data | ||
N_EXT_ATTR9 | NUMBER | Column to store extensible attribute number data | ||
N_EXT_ATTR10 | NUMBER | Column to store extensible attribute number data | ||
D_EXT_ATTR1 | DATE | Column to store extensible attribute date | ||
D_EXT_ATTR2 | DATE | Column to store extensible attribute date | ||
D_EXT_ATTR3 | DATE | Column to store extensible attribute date | ||
D_EXT_ATTR4 | DATE | Column to store extensible attribute date | ||
D_EXT_ATTR5 | DATE | Column to store extensible attribute date | ||
C_EXT_ATTR21 | VARCHAR2 | (255) | Column to store extensible attribute character data | |
C_EXT_ATTR22 | VARCHAR2 | (255) | Column to store extensible attribute character data | |
C_EXT_ATTR23 | VARCHAR2 | (255) | Column to store extensible attribute character data | |
C_EXT_ATTR24 | VARCHAR2 | (255) | Column to store extensible attribute character data | |
C_EXT_ATTR25 | VARCHAR2 | (255) | Column to store extensible attribute character data | |
C_EXT_ATTR26 | VARCHAR2 | (255) | Column to store extensible attribute character data | |
C_EXT_ATTR27 | VARCHAR2 | (255) | Column to store extensible attribute character data | |
C_EXT_ATTR28 | VARCHAR2 | (255) | Column to store extensible attribute character data | |
C_EXT_ATTR29 | VARCHAR2 | (255) | Column to store extensible attribute character data | |
C_EXT_ATTR30 | VARCHAR2 | (255) | Column to store extensible attribute character data | |
N_EXT_ATTR11 | NUMBER | Column to store extensible attribute number data | ||
N_EXT_ATTR12 | NUMBER | Column to store extensible attribute number data | ||
N_EXT_ATTR13 | NUMBER | Column to store extensible attribute number data | ||
N_EXT_ATTR14 | NUMBER | Column to store extensible attribute number data | ||
N_EXT_ATTR15 | NUMBER | Column to store extensible attribute number data | ||
N_EXT_ATTR16 | NUMBER | Column to store extensible attribute number data | ||
N_EXT_ATTR17 | NUMBER | Column to store extensible attribute number data | ||
N_EXT_ATTR18 | NUMBER | Column to store extensible attribute number data | ||
N_EXT_ATTR19 | NUMBER | Column to store extensible attribute number data | ||
N_EXT_ATTR20 | NUMBER | Column to store extensible attribute number data | ||
D_EXT_ATTR6 | DATE | Column to store extensible attribute date | ||
D_EXT_ATTR7 | DATE | Column to store extensible attribute date | ||
D_EXT_ATTR8 | DATE | Column to store extensible attribute date | ||
D_EXT_ATTR9 | DATE | Column to store extensible attribute date | ||
D_EXT_ATTR10 | DATE | Column to store extensible attribute date | ||
D_EXT_ATTR11 | DATE | Column to store extensible attribute date | ||
D_EXT_ATTR13 | DATE | Column to store extensible attribute date | ||
D_EXT_ATTR14 | DATE | Column to store extensible attribute date | ||
D_EXT_ATTR15 | DATE | Column to store extensible attribute date | ||
D_EXT_ATTR12 | DATE | Column to store extensible attribute date | ||
D_EXT_ATTR16 | DATE | Column to store extensible attribute date | ||
D_EXT_ATTR17 | DATE | Column to store extensible attribute date | ||
D_EXT_ATTR18 | DATE | Column to store extensible attribute date | ||
D_EXT_ATTR19 | DATE | Column to store extensible attribute date | ||
D_EXT_ATTR20 | DATE | Column to store extensible attribute date | ||
TL_EXT_ATTR1 | VARCHAR2 | (255) | Column to store extensible attribute transalatable character data | |
TL_EXT_ATTR2 | VARCHAR2 | (255) | Column to store extensible attribute transalatable character data | |
TL_EXT_ATTR3 | VARCHAR2 | (255) | Column to store extensible attribute transalatable character data | |
TL_EXT_ATTR4 | VARCHAR2 | (255) | Column to store extensible attribute transalatable character data | |
TL_EXT_ATTR5 | VARCHAR2 | (255) | Column to store extensible attribute transalatable character data | |
TL_EXT_ATTR6 | VARCHAR2 | (255) | Column to store extensible attribute transalatable character data | |
TL_EXT_ATTR7 | VARCHAR2 | (255) | Column to store extensible attribute transalatable character data | |
TL_EXT_ATTR8 | VARCHAR2 | (255) | Column to store extensible attribute transalatable character data | |
TL_EXT_ATTR9 | VARCHAR2 | (255) | Column to store extensible attribute transalatable character data | |
TL_EXT_ATTR10 | VARCHAR2 | (255) | Column to store extensible attribute transalatable character data | |
TL_EXT_ATTR11 | VARCHAR2 | (255) | Column to store extensible attribute transalatable character data | |
TL_EXT_ATTR12 | VARCHAR2 | (255) | Column to store extensible attribute transalatable character data | |
TL_EXT_ATTR13 | VARCHAR2 | (255) | Column to store extensible attribute transalatable character data | |
TL_EXT_ATTR14 | VARCHAR2 | (255) | Column to store extensible attribute transalatable character data | |
TL_EXT_ATTR15 | VARCHAR2 | (255) | Column to store extensible attribute transalatable character data | |
TL_EXT_ATTR16 | VARCHAR2 | (255) | Column to store extensible attribute transalatable character data | |
TL_EXT_ATTR17 | VARCHAR2 | (255) | Column to store extensible attribute transalatable character data | |
TL_EXT_ATTR18 | VARCHAR2 | (255) | Column to store extensible attribute transalatable character data | |
TL_EXT_ATTR19 | VARCHAR2 | (255) | Column to store extensible attribute transalatable character data | |
TL_EXT_ATTR20 | VARCHAR2 | (255) | Column to store extensible attribute transalatable character data | |
TL_EXT_ATTR21 | VARCHAR2 | (255) | Column to store extensible attribute transalatable character data | |
TL_EXT_ATTR22 | VARCHAR2 | (255) | Column to store extensible attribute transalatable character data | |
TL_EXT_ATTR23 | VARCHAR2 | (255) | Column to store extensible attribute transalatable character data | |
TL_EXT_ATTR24 | VARCHAR2 | (255) | Column to store extensible attribute transalatable character data | |
TL_EXT_ATTR25 | VARCHAR2 | (255) | Column to store extensible attribute transalatable character data | |
TL_EXT_ATTR26 | VARCHAR2 | (255) | Column to store extensible attribute transalatable character data | |
TL_EXT_ATTR27 | VARCHAR2 | (255) | Column to store extensible attribute transalatable character data | |
TL_EXT_ATTR28 | VARCHAR2 | (255) | Column to store extensible attribute transalatable character data | |
TL_EXT_ATTR29 | VARCHAR2 | (255) | Column to store extensible attribute transalatable character data | |
TL_EXT_ATTR30 | VARCHAR2 | (255) | Column to store extensible attribute transalatable character data | |
WORKORDER_FK_KEY | NUMBER | Reference to Work Order identifier | ||
ITEM_FK_KEY | NUMBER | Reference to Item identifier | ||
TRANSIENT | VARCHAR2 | (2) | Internal column for future use | |
READ_TIME | DATE | Reading time |
Cut, paste (and edit) the following text to query this object:
SELECT EXTENSION_ID
, SEGMENT_PK_KEY
, ATTR_GROUP_ID
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, SOURCE_LANG
, LANGUAGE
, 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
, 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
, D_EXT_ATTR1
, D_EXT_ATTR2
, D_EXT_ATTR3
, D_EXT_ATTR4
, D_EXT_ATTR5
, 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_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_ATTR6
, D_EXT_ATTR7
, D_EXT_ATTR8
, D_EXT_ATTR9
, D_EXT_ATTR10
, D_EXT_ATTR11
, D_EXT_ATTR13
, D_EXT_ATTR14
, D_EXT_ATTR15
, D_EXT_ATTR12
, D_EXT_ATTR16
, D_EXT_ATTR17
, D_EXT_ATTR18
, D_EXT_ATTR19
, D_EXT_ATTR20
, TL_EXT_ATTR1
, TL_EXT_ATTR2
, TL_EXT_ATTR3
, TL_EXT_ATTR4
, TL_EXT_ATTR5
, TL_EXT_ATTR6
, TL_EXT_ATTR7
, TL_EXT_ATTR8
, TL_EXT_ATTR9
, TL_EXT_ATTR10
, TL_EXT_ATTR11
, TL_EXT_ATTR12
, TL_EXT_ATTR13
, TL_EXT_ATTR14
, TL_EXT_ATTR15
, TL_EXT_ATTR16
, TL_EXT_ATTR17
, TL_EXT_ATTR18
, TL_EXT_ATTR19
, TL_EXT_ATTR20
, TL_EXT_ATTR21
, TL_EXT_ATTR22
, TL_EXT_ATTR23
, TL_EXT_ATTR24
, TL_EXT_ATTR25
, TL_EXT_ATTR26
, TL_EXT_ATTR27
, TL_EXT_ATTR28
, TL_EXT_ATTR29
, TL_EXT_ATTR30
, WORKORDER_FK_KEY
, ITEM_FK_KEY
, TRANSIENT
, READ_TIME
FROM APPS.MTH_PRODUCTION_SEGMENTS_EXT_VL;
APPS.MTH_PRODUCTION_SEGMENTS_EXT_VL is not referenced by any database object
|
|
|