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

TABLE: ENG.ENG_ENG_CHANGES_INTERFACE

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


ENG_ENG_CHANGES_INTERFACE is the base table for the Mass Change Order
block in the Mass Change Bills of Material window.
.
For a future release: ENG_ENG_CHANGES_INTERFACE temporarily stores information about
engineering change order headers. This table contains user friendly
columns which allow you to easily enter your data as well as their
corresponding foreign keys. Oracle Engineering will fill in
the column you do not enter after performing the proper validation.
For example, you enter the ORGANIZATION_CODE and Oracle Engineering
will fill in the corresponding ORGANIZATION_ID for you.
.


Storage Details
Tablespace: TablespaceAPPS_TS_INTERFACE
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
ENG_ENG_CHANGES_INTERFACE_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_INTERFACE ColumnORGANIZATION_ID
ColumnCHANGE_NOTICE
ColumnENG_CHANGES_IFCE_KEY
ENG_ENG_CHANGES_INTERFACE_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_INTERFACE ColumnENG_CHANGES_IFCE_KEY
ENG_ENG_CHANGES_INTERFACE_N3 NORMAL NONUNIQUE TablespaceAPPS_TS_INTERFACE ColumnTRANSACTION_ID
ENG_ENG_CHANGES_INTERFACE_N4 NORMAL NONUNIQUE TablespaceAPPS_TS_INTERFACE ColumnCHANGE_ORDER_TYPE_ID
ColumnENG_CHANGES_IFCE_KEY
Columns
Name Datatype Length Mandatory Comments
CHANGE_NOTICE VARCHAR2 (10)
Engineering change order number
ORGANIZATION_ID NUMBER

Organization identifier
LAST_UPDATE_DATE DATE

Standard Who column
LAST_UPDATED_BY NUMBER

Standard Who column
CREATION_DATE DATE

Standard Who column
CREATED_BY NUMBER

Standard Who column
LAST_UPDATE_LOGIN NUMBER

Standard Who column
DESCRIPTION VARCHAR2 (2000)
Description
STATUS_TYPE NUMBER

Engineering change order status
INITIATION_DATE DATE

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 list of approvers for the ECO
APPROVAL_LIST_NAME VARCHAR2 (10)
List of approvers for the ECO
CHANGE_ORDER_TYPE_ID NUMBER

Change order type id
CHANGE_ORDER_TYPE VARCHAR2 (80)
Type of change order
RESPONSIBLE_ORGANIZATION_ID NUMBER

ECO department identifier
SET_ID VARCHAR2 (10)
(not currently used)
APPROVAL_REQUEST_DATE DATE

Date the approval status is change to 'Approval requested'
DDF_CONTEXT VARCHAR2 (30)
(not currently used)
CO_CREATED NUMBER

(not currently used)
TRANSACTION_ID NUMBER

Row identifier
TRANSACTION_TYPE VARCHAR2 (10)
Type of action : CREATE, UPDATE or DELETE
PROCESS_FLAG NUMBER

Row status
ORGANIZATION_CODE VARCHAR2 (3)
Abbreviation of organization name
RESPONSIBLE_ORG_CODE VARCHAR2 (3)
Organization abbreviation for ECO department
ENG_CHANGES_IFCE_KEY VARCHAR2 (30)
User identifier to link rows pertaining to the same business object.
CHANGE_ID NUMBER

Change Id
STATUS_NAME VARCHAR2 (30)
Status name
REQUESTOR_USER_NAME VARCHAR2 (240)
Requestor name
APPROVAL_STATUS_NAME VARCHAR2 (80)
Approval status name
CHANGE_MGMT_TYPE_CODE VARCHAR2 (30)
Change management type code
ORIGINAL_SYSTEM_REFERENCE VARCHAR2 (50)
Original system reference
ORGANIZATION_HIERARCHY VARCHAR2 (240)
Organization hierarchy
ASSIGNEE_NAME VARCHAR2 (360)
Assignee name
SOURCE_TYPE_NAME VARCHAR2 (80)
Source type name
SOURCE_NAME VARCHAR2 (80)
Source name
NEED_BY_DATE DATE

Need by date
EFFORT NUMBER

Effort
CHANGE_NAME VARCHAR2 (240)
Change name
CHANGE_NOTICE_PREFIX VARCHAR2 (10)
Change notice prefix
CHANGE_NOTICE_NUMBER NUMBER

Change notice number
ECO_DEPARTMENT_NAME VARCHAR2 (60)
Engineering change order department name
INTERNAL_USE_ONLY VARCHAR2 (1)
For internal use
CHANGE_MGMT_TYPE_NAME VARCHAR2 (45)
Change management type name
PROJECT_NAME VARCHAR2 (30)
Name of the project
TASK_NUMBER VARCHAR2 (25)
Task number
PK1_NAME VARCHAR2 (240)
Primary key1 name
PK2_NAME VARCHAR2 (240)
Primary key2 name
PK3_NAME VARCHAR2 (240)
Primary key3 name
PLM_OR_ERP_CHANGE VARCHAR2 (3)
Change triggered from PLM pages to ERP forms
ASSIGNEE_ID NUMBER

Assignee id
CLASSIFICATION_ID NUMBER

Classification internal id
HIERARCHY_ID NUMBER

Hierarchy internal id
SOURCE_ID NUMBER

Source id
SOURCE_TYPE_CODE VARCHAR2 (30)
Source type code
EMPLOYEE_NUMBER VARCHAR2 (30)
Employee number
Query Text

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
,      APPROVAL_LIST_NAME
,      CHANGE_ORDER_TYPE_ID
,      CHANGE_ORDER_TYPE
,      RESPONSIBLE_ORGANIZATION_ID
,      SET_ID
,      APPROVAL_REQUEST_DATE
,      DDF_CONTEXT
,      CO_CREATED
,      TRANSACTION_ID
,      TRANSACTION_TYPE
,      PROCESS_FLAG
,      ORGANIZATION_CODE
,      RESPONSIBLE_ORG_CODE
,      ENG_CHANGES_IFCE_KEY
,      CHANGE_ID
,      STATUS_NAME
,      REQUESTOR_USER_NAME
,      APPROVAL_STATUS_NAME
,      CHANGE_MGMT_TYPE_CODE
,      ORIGINAL_SYSTEM_REFERENCE
,      ORGANIZATION_HIERARCHY
,      ASSIGNEE_NAME
,      SOURCE_TYPE_NAME
,      SOURCE_NAME
,      NEED_BY_DATE
,      EFFORT
,      CHANGE_NAME
,      CHANGE_NOTICE_PREFIX
,      CHANGE_NOTICE_NUMBER
,      ECO_DEPARTMENT_NAME
,      INTERNAL_USE_ONLY
,      CHANGE_MGMT_TYPE_NAME
,      PROJECT_NAME
,      TASK_NUMBER
,      PK1_NAME
,      PK2_NAME
,      PK3_NAME
,      PLM_OR_ERP_CHANGE
,      ASSIGNEE_ID
,      CLASSIFICATION_ID
,      HIERARCHY_ID
,      SOURCE_ID
,      SOURCE_TYPE_CODE
,      EMPLOYEE_NUMBER
FROM ENG.ENG_ENG_CHANGES_INTERFACE;

Dependencies

[top of page]

ENG.ENG_ENG_CHANGES_INTERFACE does not reference any database object

ENG.ENG_ENG_CHANGES_INTERFACE is referenced by following:

SchemaAPPS
SynonymENG_ENG_CHANGES_INTERFACE