[Home] [Help] [Dependency Information]
Object Name: | ENG_CHANGE_TYPE_CLASS_CODES |
---|---|
Object Type: | TABLE |
Owner: | ENG |
FND Design Data: | ENG.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
Tablespace: | APPS_TS_SEED |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
ENG_CHANGE_TYPE_CLASS_CODES_N1 | NORMAL | NONUNIQUE | APPS_TS_SEED | CLASSIFICATION_ID |
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 |
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
FROM ENG.ENG_CHANGE_TYPE_CLASS_CODES;
ENG.ENG_CHANGE_TYPE_CLASS_CODES does not reference any database object
ENG.ENG_CHANGE_TYPE_CLASS_CODES is referenced by following:
|
|
|