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_CHG_USR_ATR_INTERFACE

Object Details

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

Engineering Change User Defined Attributes Import

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
ENG_CHG_USR_ATR_INTERFACE_U1	NORMAL	UNIQUE	APPS_TS_INTERFACE	TRANSACTION_ID
ENG_CHG_USR_ATR_INTERFACE_N1	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	DATA_SET_ID PROCESS_STATUS
ENG_CHG_USR_ATR_INTERFACE_N2	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	PROCESS_STATUS
ENG_CHG_USR_ATR_INTERFACE_N3	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	ORGANIZATION_ID CHANGE_ID

Columns

Name	Datatype	Length	Mandatory	Comments
TRANSACTION_ID	NUMBER	(15)	Yes	Transaction identifier
PROCESS_STATUS	NUMBER	(9)	Yes	Row status
DATA_SET_ID	NUMBER	(15)	Yes	Data Set Identifier
ORGANIZATION_CODE	VARCHAR2	(3)	Yes	Organization Code
CHANGE_NUMBER	VARCHAR2	(10)	Yes	Engineering change number
CHANGE_MGMT_TYPE_CODE	VARCHAR2	(30)	Yes	Internal Category Name of the Engineering Change
CHANGE_LINE_NAME	VARCHAR2	(240)		Engineering change line name
ROW_IDENTIFIER	NUMBER	(38)	Yes	Row Identifier
ATTR_GROUP_INT_NAME	VARCHAR2	(30)	Yes	User Attribute Group Internal Name
ATTR_INT_NAME	VARCHAR2	(30)	Yes	User Attribute Internal Name
ATTR_VALUE_STR	VARCHAR2	(150)		String Value of the Attribute
ATTR_VALUE_NUM	NUMBER	(38)		Integer Value of the Attribute
ATTR_VALUE_DATE	DATE			Date Value of the Attribute
ATTR_DISP_VALUE	VARCHAR2	(150)		Display Value of the Attribute
TRANSACTION_TYPE	VARCHAR2	(10)	Yes	Type of action : CREATE, UPDATE or DELETE
ORGANIZATION_ID	NUMBER	(15)		Organization Identifier
CHANGE_ID	NUMBER	(15)		Change Identifier
CHANGE_TYPE_ID	NUMBER	(15)		Change Type Identifier
ATTR_GROUP_ID	NUMBER	(15)		Attribute Group Identifier
REQUEST_ID	NUMBER	(15)		Concurrent Who column
PROGRAM_APPLICATION_ID	NUMBER	(15)		Concurrent Who column
PROGRAM_ID	NUMBER	(15)		Concurrent Who column
PROGRAM_UPDATE_DATE	DATE			Concurrent Who column
CREATED_BY	NUMBER	(15)	Yes	Standard Who columns
CREATION_DATE	DATE		Yes	Standard Who columns
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who columns
LAST_UPDATE_DATE	DATE		Yes	Standard Who columns
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who columns
CHANGE_LINE_ID	NUMBER			Change Line Identifier
CHANGE_LINE_SEQUENCE_NUMBER	NUMBER			Change Line Sequence Number

Query Text

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


SELECT TRANSACTION_ID
,      PROCESS_STATUS
,      DATA_SET_ID
,      ORGANIZATION_CODE
,      CHANGE_NUMBER
,      CHANGE_MGMT_TYPE_CODE
,      CHANGE_LINE_NAME
,      ROW_IDENTIFIER
,      ATTR_GROUP_INT_NAME
,      ATTR_INT_NAME
,      ATTR_VALUE_STR
,      ATTR_VALUE_NUM
,      ATTR_VALUE_DATE
,      ATTR_DISP_VALUE
,      TRANSACTION_TYPE
,      ORGANIZATION_ID
,      CHANGE_ID
,      CHANGE_TYPE_ID
,      ATTR_GROUP_ID
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      CHANGE_LINE_ID
,      CHANGE_LINE_SEQUENCE_NUMBER
FROM ENG.ENG_CHG_USR_ATR_INTERFACE;

Dependencies

[top of page]

ENG.ENG_CHG_USR_ATR_INTERFACE does not reference any database object

ENG.ENG_CHG_USR_ATR_INTERFACE is referenced by following:

APPS: ENG_CHG_USR_ATR_INTERFACE