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

TABLE: ENG.ENG_CHANGE_ORDER_TYPES_TL

Object Details
Object Name: ENG_CHANGE_ORDER_TYPES_TL
Object Type: TABLE
Owner: ENG
FND Design Data: TableENG.ENG_CHANGE_ORDER_TYPES_TL
Subobject Name:
Status: VALID


This is MLS table which stores information about Engineering Change order types. You can use change order types to group ECOs and to allow access to engineering items and engineering bills of material.It references ENG_CHANGE_ORDER_TYPES table with column change_order_type_id.


Storage Details
Tablespace: TablespaceAPPS_TS_SEED
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
ENG_CHANGE_ORDER_TYPES_TL_U1 NORMAL UNIQUE TablespaceAPPS_TS_SEED ColumnCHANGE_ORDER_TYPE_ID
ColumnLANGUAGE
ColumnZD_EDITION_NAME
ENG_CHANGE_ORDER_TYPES_TL_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_SEED ColumnTYPE_NAME
ColumnLANGUAGE
Columns
Name Datatype Length Mandatory Comments
CHANGE_ORDER_TYPE_ID NUMBER
Yes Change order type internal id
TYPE_NAME VARCHAR2 (80) Yes Type name
DESCRIPTION VARCHAR2 (240)
Type description
TAB_TEXT VARCHAR2 (80)
Tab text
LANGUAGE VARCHAR2 (4) Yes Language
SOURCE_LANG VARCHAR2 (4) Yes Base language
CREATION_DATE DATE
Yes Standard WHO column
CREATED_BY NUMBER
Yes Standard WHO column
LAST_UPDATE_DATE DATE
Yes Standard WHO column
LAST_UPDATED_BY NUMBER
Yes Standard WHO column
LAST_UPDATE_LOGIN NUMBER

Standard WHO column
ZD_EDITION_NAME VARCHAR2 (30) Yes
Query Text

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


SELECT CHANGE_ORDER_TYPE_ID
,      TYPE_NAME
,      DESCRIPTION
,      TAB_TEXT
,      LANGUAGE
,      SOURCE_LANG
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      ZD_EDITION_NAME
FROM ENG.ENG_CHANGE_ORDER_TYPES_TL;

Dependencies

[top of page]

ENG.ENG_CHANGE_ORDER_TYPES_TL does not reference any database object

ENG.ENG_CHANGE_ORDER_TYPES_TL is referenced by following:

SchemaENG
ViewENG_CHANGE_ORDER_TYPES_TL#