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

VIEW: APPS.MTH_OTHERS_EXT_VL

Object Details
Object Name: MTH_OTHERS_EXT_VL
Object Type: VIEW
Owner: APPS
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns
Name Datatype Length Mandatory Comments
EXTENSION_ID NUMBER
Yes System generated surrogate key for the table. This is generated using EGO sequence.
OTHER_PK_KEY NUMBER

Reference to "Others" 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 (150)
Column to store extensible attribute character data
C_EXT_ATTR2 VARCHAR2 (150)
Column to store extensible attribute character data
C_EXT_ATTR3 VARCHAR2 (150)
Column to store extensible attribute character data
C_EXT_ATTR4 VARCHAR2 (150)
Column to store extensible attribute character data
C_EXT_ATTR5 VARCHAR2 (150)
Column to store extensible attribute character data
C_EXT_ATTR6 VARCHAR2 (150)
Column to store extensible attribute character data
C_EXT_ATTR7 VARCHAR2 (150)
Column to store extensible attribute character data
C_EXT_ATTR8 VARCHAR2 (150)
Column to store extensible attribute character data
C_EXT_ATTR9 VARCHAR2 (150)
Column to store extensible attribute character data
C_EXT_ATTR10 VARCHAR2 (150)
Column to store extensible attribute character data
C_EXT_ATTR11 VARCHAR2 (150)
Column to store extensible attribute character data
C_EXT_ATTR12 VARCHAR2 (150)
Column to store extensible attribute character data
C_EXT_ATTR13 VARCHAR2 (150)
Column to store extensible attribute character data
C_EXT_ATTR14 VARCHAR2 (150)
Column to store extensible attribute character data
C_EXT_ATTR15 VARCHAR2 (150)
Column to store extensible attribute character data
C_EXT_ATTR16 VARCHAR2 (150)
Column to store extensible attribute character data
C_EXT_ATTR17 VARCHAR2 (150)
Column to store extensible attribute character data
C_EXT_ATTR18 VARCHAR2 (150)
Column to store extensible attribute character data
C_EXT_ATTR19 VARCHAR2 (150)
Column to store extensible attribute character data
C_EXT_ATTR20 VARCHAR2 (150)
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 (150)
Column to store extensible attribute character data
C_EXT_ATTR22 VARCHAR2 (150)
Column to store extensible attribute character data
C_EXT_ATTR23 VARCHAR2 (150)
Column to store extensible attribute character data
C_EXT_ATTR24 VARCHAR2 (150)
Column to store extensible attribute character data
C_EXT_ATTR25 VARCHAR2 (150)
Column to store extensible attribute character data
C_EXT_ATTR26 VARCHAR2 (150)
Column to store extensible attribute character data
C_EXT_ATTR27 VARCHAR2 (150)
Column to store extensible attribute character data
C_EXT_ATTR28 VARCHAR2 (150)
Column to store extensible attribute character data
C_EXT_ATTR29 VARCHAR2 (150)
Column to store extensible attribute character data
C_EXT_ATTR30 VARCHAR2 (150)
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 (150)
Column to store extensible attribute transalatable character data
TL_EXT_ATTR2 VARCHAR2 (150)
Column to store extensible attribute transalatable character data
TL_EXT_ATTR3 VARCHAR2 (150)
Column to store extensible attribute transalatable character data
TL_EXT_ATTR4 VARCHAR2 (150)
Column to store extensible attribute transalatable character data
TL_EXT_ATTR5 VARCHAR2 (150)
Column to store extensible attribute transalatable character data
TL_EXT_ATTR6 VARCHAR2 (150)
Column to store extensible attribute transalatable character data
TL_EXT_ATTR7 VARCHAR2 (150)
Column to store extensible attribute transalatable character data
TL_EXT_ATTR8 VARCHAR2 (150)
Column to store extensible attribute transalatable character data
TL_EXT_ATTR9 VARCHAR2 (150)
Column to store extensible attribute transalatable character data
TL_EXT_ATTR10 VARCHAR2 (150)
Column to store extensible attribute transalatable character data
TL_EXT_ATTR11 VARCHAR2 (150)
Column to store extensible attribute transalatable character data
TL_EXT_ATTR12 VARCHAR2 (150)
Column to store extensible attribute transalatable character data
TL_EXT_ATTR13 VARCHAR2 (150)
Column to store extensible attribute transalatable character data
TL_EXT_ATTR14 VARCHAR2 (150)
Column to store extensible attribute transalatable character data
TL_EXT_ATTR15 VARCHAR2 (150)
Column to store extensible attribute transalatable character data
TL_EXT_ATTR16 VARCHAR2 (150)
Column to store extensible attribute transalatable character data
TL_EXT_ATTR17 VARCHAR2 (150)
Column to store extensible attribute transalatable character data
TL_EXT_ATTR18 VARCHAR2 (150)
Column to store extensible attribute transalatable character data
TL_EXT_ATTR19 VARCHAR2 (150)
Column to store extensible attribute transalatable character data
TL_EXT_ATTR20 VARCHAR2 (150)
Column to store extensible attribute transalatable character data
TL_EXT_ATTR21 VARCHAR2 (150)
Column to store extensible attribute transalatable character data
TL_EXT_ATTR22 VARCHAR2 (150)
Column to store extensible attribute transalatable character data
TL_EXT_ATTR23 VARCHAR2 (150)
Column to store extensible attribute transalatable character data
TL_EXT_ATTR24 VARCHAR2 (150)
Column to store extensible attribute transalatable character data
TL_EXT_ATTR25 VARCHAR2 (150)
Column to store extensible attribute transalatable character data
TL_EXT_ATTR26 VARCHAR2 (150)
Column to store extensible attribute transalatable character data
TL_EXT_ATTR27 VARCHAR2 (150)
Column to store extensible attribute transalatable character data
TL_EXT_ATTR28 VARCHAR2 (150)
Column to store extensible attribute transalatable character data
TL_EXT_ATTR29 VARCHAR2 (150)
Column to store extensible attribute transalatable character data
TL_EXT_ATTR30 VARCHAR2 (150)
Column to store extensible attribute transalatable character data
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT EXTENSION_ID
,      OTHER_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
FROM APPS.MTH_OTHERS_EXT_VL;

Dependencies

[top of page]

APPS.MTH_OTHERS_EXT_VL references the following:

SchemaAPPS
SynonymMTH_OTHERS_EXT_B
SynonymMTH_OTHERS_EXT_TL

APPS.MTH_OTHERS_EXT_VL is not referenced by any database object