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

TABLE: ENG.ENG_CHANGE_TYPE_CLASS_CODES

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


Classifications provide a mechanism for companies to automate the categorization of change orders, and to also indicate to users exactly how the change order will impact their production. This table stores association between classfication code and change order type using columns classification_id and chage_type_id.Classification_id refers to classification_id column in ENG_CHANGE_CLASSIFICATIONS_B and CHANGE_TYPE_ID column references CHANGE_ORDER_TYPE_ID from table ENG_CHANGE_ORDER_TYPES


Storage Details
Tablespace: TablespaceAPPS_TS_SEED
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
ENG_CHANGE_TYPE_CLASS_CODES_U1 NORMAL UNIQUE TablespaceAPPS_TS_SEED ColumnCHANGE_TYPE_ID
ColumnCLASSIFICATION_ID
ColumnZD_EDITION_NAME
ENG_CHANGE_TYPE_CLASS_CODES_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_SEED ColumnCLASSIFICATION_ID
Columns
Name Datatype Length Mandatory Comments
CHANGE_TYPE_ID NUMBER
Yes Change type internal id
CLASSIFICATION_ID NUMBER
Yes Classification internal id
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_TYPE_ID
,      CLASSIFICATION_ID
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      ZD_EDITION_NAME
FROM ENG.ENG_CHANGE_TYPE_CLASS_CODES;

Dependencies

[top of page]

ENG.ENG_CHANGE_TYPE_CLASS_CODES does not reference any database object

ENG.ENG_CHANGE_TYPE_CLASS_CODES is referenced by following:

SchemaENG
ViewENG_CHANGE_TYPE_CLASS_CODES#