[Home] [Help] [Dependency Information]
Object Name: | ENG_ENGINEERING_CHANGES |
---|---|
Object Type: | TABLE |
Owner: | ENG |
FND Design Data: | ENG.ENG_ENGINEERING_CHANGES |
Subobject Name: | |
Status: | VALID |
ENG_ENGINEERING_CHANGES stores information about engineering change
order headers. Each row includes the unique identifier of the ECO, the
description, the change order type, the reason and priority codes, the
status, the requestor, the approval list and approval status, the
implementation costs, and any cancellation information.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 20 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
ENG_ENGINEERING_CHANGES_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
ORGANIZATION_ID
CHANGE_NOTICE |
ENG_ENGINEERING_CHANGES_U2 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
CHANGE_MGMT_TYPE_CODE
ORGANIZATION_ID CHANGE_NOTICE |
ENG_ENGINEERING_CHANGES_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | CHANGE_ID |
ENG_ENGINEERING_CHANGES_N10 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
STATUS_TYPE
CHANGE_MGMT_TYPE_CODE ORGANIZATION_ID |
ENG_ENGINEERING_CHANGES_N11 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
ORGANIZATION_ID
CHANGE_MGMT_TYPE_CODE |
ENG_ENGINEERING_CHANGES_N12 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
ASSIGNEE_ID
STATUS_CODE CHANGE_MGMT_TYPE_CODE ORGANIZATION_ID |
ENG_ENGINEERING_CHANGES_N13 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
DESCRIPTION
CHANGE_MGMT_TYPE_CODE ORGANIZATION_ID |
ENG_ENGINEERING_CHANGES_N14 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
REASON_CODE
CHANGE_MGMT_TYPE_CODE ORGANIZATION_ID |
ENG_ENGINEERING_CHANGES_N15 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
PROJECT_ID
CHANGE_MGMT_TYPE_CODE ORGANIZATION_ID |
ENG_ENGINEERING_CHANGES_N16 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
TASK_ID
CHANGE_MGMT_TYPE_CODE ORGANIZATION_ID |
ENG_ENGINEERING_CHANGES_N17 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | APPROVAL_LIST_ID |
ENG_ENGINEERING_CHANGES_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
REQUESTOR_ID
STATUS_CODE CHANGE_MGMT_TYPE_CODE ORGANIZATION_ID |
ENG_ENGINEERING_CHANGES_N3 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
ASSIGNEE_ID
CHANGE_MGMT_TYPE_CODE ORGANIZATION_ID |
ENG_ENGINEERING_CHANGES_N4 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
CREATED_BY
CHANGE_MGMT_TYPE_CODE ORGANIZATION_ID |
ENG_ENGINEERING_CHANGES_N5 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
STATUS_CODE
CHANGE_MGMT_TYPE_CODE ORGANIZATION_ID |
ENG_ENGINEERING_CHANGES_N6 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
PRIORITY_CODE
CHANGE_MGMT_TYPE_CODE ORGANIZATION_ID |
ENG_ENGINEERING_CHANGES_N7 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
CHANGE_NAME
CHANGE_MGMT_TYPE_CODE ORGANIZATION_ID |
ENG_ENGINEERING_CHANGES_N8 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
CHANGE_ORDER_TYPE_ID
CHANGE_MGMT_TYPE_CODE ORGANIZATION_ID |
ENG_ENGINEERING_CHANGES_N9 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | CLASSIFICATION_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CHANGE_NOTICE | VARCHAR2 | (10) | Yes | Engineering change order number |
ORGANIZATION_ID | NUMBER | Yes | Organization identifier | |
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 | ||
DESCRIPTION | VARCHAR2 | (2000) | Description | |
STATUS_TYPE | NUMBER | Yes | Engineering change order status | |
INITIATION_DATE | DATE | Yes | Creation date of the ECO | |
IMPLEMENTATION_DATE | DATE | Implementation date of the entire ECO | ||
CANCELLATION_DATE | DATE | Cancellation date of the entire ECO | ||
CANCELLATION_COMMENTS | VARCHAR2 | (240) | Cancellation comments | |
PRIORITY_CODE | VARCHAR2 | (10) | Priority code | |
REASON_CODE | VARCHAR2 | (10) | Reason code | |
ESTIMATED_ENG_COST | NUMBER | Estimated engineering implementation cost | ||
ESTIMATED_MFG_COST | NUMBER | Estimated manufacturing implementation cost | ||
REQUESTOR_ID | NUMBER | Identifier of the employee who requested this ECO | ||
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 | ||
APPROVAL_STATUS_TYPE | NUMBER | Approval status type code | ||
APPROVAL_DATE | DATE | Date the ECO was approved | ||
APPROVAL_LIST_ID | NUMBER | Identifier of the list of approvers for the ECO | ||
CHANGE_ORDER_TYPE_ID | NUMBER | Yes | Change order type id | |
RESPONSIBLE_ORGANIZATION_ID | NUMBER | ECO department identifier | ||
APPROVAL_REQUEST_DATE | DATE | Date the approval status is changed to 'Approval requested' | ||
DDF_CONTEXT | VARCHAR2 | (30) | Developer descriptive flexfield structure defining column | |
PROJECT_ID | NUMBER | Project Id for Project Manufacturing | ||
ORIGINAL_SYSTEM_REFERENCE | VARCHAR2 | (50) | Original system that data for the current record has come from | |
TASK_ID | NUMBER | Task Id for Project Manufacturing | ||
HIERARCHY_FLAG | NUMBER | Hierarchy Flag | ||
ORGANIZATION_HIERARCHY | VARCHAR2 | (30) | Hierarchy Name | |
CHANGE_MGMT_TYPE_CODE | VARCHAR2 | (30) | Yes | Change Mgmt Type Code |
ASSIGNEE_ID | NUMBER | Assignee Id | ||
NEED_BY_DATE | DATE | Need By Date | ||
INTERNAL_USE_ONLY | VARCHAR2 | (1) | Internal Use Only | |
SOURCE_TYPE_CODE | VARCHAR2 | (30) | Source Type Code | |
SOURCE_ID | NUMBER | Source Id | ||
SOURCE_NAME | VARCHAR2 | (80) | Source Name | |
EFFORT | NUMBER | Effort | ||
CHANGE_NAME | VARCHAR2 | (240) | Change Name | |
CHANGE_ID | NUMBER | Yes | Change Id | |
ROUTE_ID | NUMBER | Route Id | ||
HIERARCHY_ID | NUMBER | Hierarchy Id | ||
CHANGE_NOTICE_PREFIX | VARCHAR2 | (10) | Change Notice Prefix | |
CHANGE_NOTICE_NUMBER | NUMBER | Change Notice Number | ||
OLD_REQUESTOR_ID | NUMBER | Old Requestor Id | ||
STATUS_CODE | NUMBER | Status code | ||
RESOLUTION | VARCHAR2 | (2000) | Resolution | |
CLASSIFICATION_ID | NUMBER | Change classification internal id | ||
PLM_OR_ERP_CHANGE | VARCHAR2 | (3) | Indicates if the engineering change order has come from PLM pages or ERP forms | |
EXPIRATION_DATE | DATE | Expiration date | ||
PROMOTE_STATUS_CODE | NUMBER | Promote status code | ||
IMPLEMENTATION_REQ_ID | NUMBER | Implementation request id | ||
COMPLETION_DATE | DATE |
Cut, paste (and edit) the following text to query this object:
SELECT CHANGE_NOTICE
, ORGANIZATION_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, DESCRIPTION
, STATUS_TYPE
, INITIATION_DATE
, IMPLEMENTATION_DATE
, CANCELLATION_DATE
, CANCELLATION_COMMENTS
, PRIORITY_CODE
, REASON_CODE
, ESTIMATED_ENG_COST
, ESTIMATED_MFG_COST
, REQUESTOR_ID
, 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
, APPROVAL_STATUS_TYPE
, APPROVAL_DATE
, APPROVAL_LIST_ID
, CHANGE_ORDER_TYPE_ID
, RESPONSIBLE_ORGANIZATION_ID
, APPROVAL_REQUEST_DATE
, DDF_CONTEXT
, PROJECT_ID
, ORIGINAL_SYSTEM_REFERENCE
, TASK_ID
, HIERARCHY_FLAG
, ORGANIZATION_HIERARCHY
, CHANGE_MGMT_TYPE_CODE
, ASSIGNEE_ID
, NEED_BY_DATE
, INTERNAL_USE_ONLY
, SOURCE_TYPE_CODE
, SOURCE_ID
, SOURCE_NAME
, EFFORT
, CHANGE_NAME
, CHANGE_ID
, ROUTE_ID
, HIERARCHY_ID
, CHANGE_NOTICE_PREFIX
, CHANGE_NOTICE_NUMBER
, OLD_REQUESTOR_ID
, STATUS_CODE
, RESOLUTION
, CLASSIFICATION_ID
, PLM_OR_ERP_CHANGE
, EXPIRATION_DATE
, PROMOTE_STATUS_CODE
, IMPLEMENTATION_REQ_ID
, COMPLETION_DATE
FROM ENG.ENG_ENGINEERING_CHANGES;
ENG.ENG_ENGINEERING_CHANGES does not reference any database object
ENG.ENG_ENGINEERING_CHANGES is referenced by following:
|
|
|