eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: ENG.ENG_CHANGE_LINES_INTERFACE

Object Details

Object Name:	ENG_CHANGE_LINES_INTERFACE
Object Type:	TABLE
Owner:	ENG
FND Design Data:	ENG.ENG_CHANGE_LINES_INTERFACE
Subobject Name:
Status:	VALID

Engineering Change Lines Import

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
ENG_CHANGE_LINES_INTERFACE_N1	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	ENG_CHANGES_IFCE_KEY ORGANIZATION_ID
ENG_CHANGE_LINES_INTERFACE_N2	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	ENG_CHANGES_IFCE_KEY PROCESS_FLAG
ENG_CHANGE_LINES_INTERFACE_N3	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	TRANSACTION_ID

Columns

Name	Datatype	Length	Comments
ECO_NAME	VARCHAR2	(10)	Eco Name
ORGANIZATION_CODE	VARCHAR2	(3)	Organization Code
CHANGE_TYPE_CODE	VARCHAR2	(80)	Change Type Code
NAME	VARCHAR2	(240)	Name
DESCRIPTION	VARCHAR2	(2000)	Description
SEQUENCE_NUMBER	NUMBER		Sequence Number
OBJECT_DISPLAY_NAME	VARCHAR2	(240)	Item Name
PK1_NAME	VARCHAR2	(240)	PK1 Name
PK2_NAME	VARCHAR2	(240)	PK2 Name
PK3_NAME	VARCHAR2	(240)	PK3 Name
PK4_NAME	VARCHAR2	(240)	PK4 Name
PK5_NAME	VARCHAR2	(240)	PK5 Name
RETURN_STATUS	VARCHAR2	(1)	Return Status
TRANSACTION_TYPE	VARCHAR2	(30)	Transaction Type
TRANSACTION_ID	NUMBER		Transaction Id
CHANGE_MGMT_TYPE_NAME	VARCHAR2	(45)	Change Mgmt Type Name
ORGANIZATION_ID	NUMBER		Organization Id
ENG_CHANGES_IFCE_KEY	VARCHAR2	(30)	Eng Changes Ifce Key
PROCESS_FLAG	NUMBER		Process flag
STATUS_NAME	VARCHAR2	(80)	Status Name
ASSIGNEE_NAME	VARCHAR2	(360)	Assignee Name
NEED_BY_DATE	DATE		Need By date
SCHEDULED_DATE	DATE		Scheduled Date
IMPLEMENTATION_DATE	DATE		Implementation date
CANCELATION_DATE	VARCHAR2	(240)	Cancelation date
ORIGINAL_SYSTEM_REFERENCE	VARCHAR2	(50)	Original System Reference
COMPLETE_BEFORE_STATUS_CODE	NUMBER		Complete before status code
START_AFTER_STATUS_CODE	NUMBER		Start after status code
TYPE_CLASSIFICATION	VARCHAR2	(30)	Classification type

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT ECO_NAME
,      ORGANIZATION_CODE
,      CHANGE_TYPE_CODE
,      NAME
,      DESCRIPTION
,      SEQUENCE_NUMBER
,      OBJECT_DISPLAY_NAME
,      PK1_NAME
,      PK2_NAME
,      PK3_NAME
,      PK4_NAME
,      PK5_NAME
,      RETURN_STATUS
,      TRANSACTION_TYPE
,      TRANSACTION_ID
,      CHANGE_MGMT_TYPE_NAME
,      ORGANIZATION_ID
,      ENG_CHANGES_IFCE_KEY
,      PROCESS_FLAG
,      STATUS_NAME
,      ASSIGNEE_NAME
,      NEED_BY_DATE
,      SCHEDULED_DATE
,      IMPLEMENTATION_DATE
,      CANCELATION_DATE
,      ORIGINAL_SYSTEM_REFERENCE
,      COMPLETE_BEFORE_STATUS_CODE
,      START_AFTER_STATUS_CODE
,      TYPE_CLASSIFICATION
FROM ENG.ENG_CHANGE_LINES_INTERFACE;

Dependencies

[top of page]

ENG.ENG_CHANGE_LINES_INTERFACE does not reference any database object

ENG.ENG_CHANGE_LINES_INTERFACE is referenced by following:

ENG: ENG_CHANGE_LINES_INTERFACE#