[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | ENG_CHANGE_ORDER_TYPES |
|---|---|
| Object Type: | TABLE |
| Owner: | ENG |
| FND Design Data: |  ENG.ENG_CHANGE_ORDER_TYPES
|
| Subobject Name: | |
| Status: | VALID |
ENG_CHANGE_ORDER_TYPES 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.
| Tablespace: |  APPS_TS_SEED |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| ENG_CHANGE_ORDER_TYPES_U1 | NORMAL | UNIQUE |
APPS_TS_SEED
|
 CHANGE_ORDER_TYPE_ID
|
| ENG_CHANGE_ORDER_TYPES_U2 | NORMAL | UNIQUE |
APPS_TS_SEED
|
CHANGE_MGMT_TYPE_CODE
CHANGE_ORDER_TYPE_ID
|
| ENG_CHANGE_ORDER_TYPES_N1 | NORMAL | NONUNIQUE |
APPS_TS_SEED
|
CHANGE_MGMT_TYPE_CODE
TYPE_CLASSIFICATION
|
| ENG_CHANGE_ORDER_TYPES_N2 | NORMAL | NONUNIQUE |
APPS_TS_SEED
|
BASE_CHANGE_MGMT_TYPE_CODE
TYPE_CLASSIFICATION
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| CHANGE_ORDER_TYPE_ID | NUMBER | Yes | Unique identifier of a change order type | |
| CHANGE_ORDER_TYPE | VARCHAR2 | (80) | Change order type name | |
| LAST_UPDATE_DATE | DATE | Yes | Standard who column | |
| LAST_UPDATED_BY | NUMBER | Yes | Standard who column | |
| CREATION_DATE | DATE | Yes | Standard who column | |
| CREATED_BY | NUMBER | Yes | Standard who column | |
| LAST_UPDATE_LOGIN | NUMBER | Standard who column | ||
| CHANGE_ORDER_ORGANIZATION_ID | NUMBER | ECO department identifier (not currently used) | ||
| DESCRIPTION | VARCHAR2 | (240) | Description | |
| ASSEMBLY_TYPE | NUMBER | Item access (manufacturing or engineering) | ||
| DISABLE_DATE | DATE | Disable date | ||
| ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive flexfield structure defining column | |
| ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| REQUEST_ID | NUMBER | Concurrent Who column | ||
| PROGRAM_APPLICATION_ID | NUMBER | Concurrent Who column | ||
| PROGRAM_ID | NUMBER | Concurrent Who column | ||
| PROGRAM_UPDATE_DATE | DATE | Concurrent Who column | ||
| CHANGE_MGMT_TYPE_CODE | VARCHAR2 | (30) | Change Mgmt Type Code | |
| START_DATE | DATE | Start Date | ||
| DEFAULT_ASSIGNEE_FROM_ROLE_ID | NUMBER | Default assignee from role id | ||
| DEFAULT_ASSIGNEE_ID | NUMBER | Default Assignee Id | ||
| OBJECT_ID | NUMBER | Object internal id | ||
| SUBJECT_ID | NUMBER | Subject ID | ||
| AUTO_NUMBERING_METHOD | VARCHAR2 | (30) | Auto Numbering Method | |
| DEFAULT_ASSIGNEE_TYPE | VARCHAR2 | (30) | Default Assignee Type | |
| TYPE_CLASSIFICATION | VARCHAR2 | (30) | Type Classification | |
| CLASS_CODE_DERIVED_FLAG | VARCHAR2 | (1) | Class Code Derived Flag | |
| SEQUENCE_NUMBER | NUMBER | Sequence Number | ||
| BASE_CHANGE_MGMT_TYPE_CODE | VARCHAR2 | (30) | Base Change Mgmt Type Code | |
| SEEDED_FLAG | VARCHAR2 | (1) | Flag to indicate if the change order type is seeded or not | |
| ENABLE_ITEM_IN_LOCAL_ORG | VARCHAR2 | (1) | Flag to indicate if the item is enabled in the local organization | |
| CREATE_BOM_IN_LOCAL_ORG | VARCHAR2 | (1) | Indicates if Bill of Material could be created in local organizations | |
| SUBJECT_UPDATABLE_FLAG | VARCHAR2 | (1) | Flag to indicate if the subject can be updated | |
| XML_DATA_SOURCE_CODE | VARCHAR2 | (80) | XML data source code |
Cut, paste (and edit) the following text to query this object:
SELECT CHANGE_ORDER_TYPE_ID
, CHANGE_ORDER_TYPE
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, CHANGE_ORDER_ORGANIZATION_ID
, DESCRIPTION
, ASSEMBLY_TYPE
, DISABLE_DATE
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, CHANGE_MGMT_TYPE_CODE
, START_DATE
, DEFAULT_ASSIGNEE_FROM_ROLE_ID
, DEFAULT_ASSIGNEE_ID
, OBJECT_ID
, SUBJECT_ID
, AUTO_NUMBERING_METHOD
, DEFAULT_ASSIGNEE_TYPE
, TYPE_CLASSIFICATION
, CLASS_CODE_DERIVED_FLAG
, SEQUENCE_NUMBER
, BASE_CHANGE_MGMT_TYPE_CODE
, SEEDED_FLAG
, ENABLE_ITEM_IN_LOCAL_ORG
, CREATE_BOM_IN_LOCAL_ORG
, SUBJECT_UPDATABLE_FLAG
, XML_DATA_SOURCE_CODE
FROM ENG.ENG_CHANGE_ORDER_TYPES;
ENG.ENG_CHANGE_ORDER_TYPES does not reference any database object
ENG.ENG_CHANGE_ORDER_TYPES is referenced by following:
APPS
ENG_CHANGE_ORDER_TYPES
|
|
|
|