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: EGO.EGO_INTERFACE_TL

Object Details

Object Name:	EGO_INTERFACE_TL
Object Type:	TABLE
Owner:	EGO
FND Design Data:	EGO.EGO_INTERFACE_TL
Subobject Name:
Status:	VALID

Table EGO_INTERFACE_TL is used to store unimported translatable entries. Each row of this table stores the transaction id in case of MSI records or he row id in case of UDA records, the table name and UDA internal names for the translatable entry as well as information to identify the batch and bundle for which the unimported translatable entries apply.

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
EGO_INTERFACE_TL_N1	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	BUNDLE_ID
EGO_INTERFACE_TL_N2	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	SET_PROCESS_ID
EGO_INTERFACE_TL_N3	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	TABLE_NAME UNIQUE_ID

Columns

Name	Datatype	Length	Mandatory	Comments
SET_PROCESS_ID	NUMBER			Batch Id.
UNIQUE_ID	NUMBER		Yes	This column will store the transaction id in case of MSI records and the row id in case of UDA records.
TABLE_NAME	VARCHAR2	(255)		Base Table name.
LANGUAGE	VARCHAR2	(10)		Language.
COLUMN_NAME	VARCHAR2	(30)		This will store the UDA attributes internal name.
COLUMN_VALUE	VARCHAR2	(4000)		Attribute Value.
CREATED_BY	NUMBER		Yes	One of the five standard "WHO" columns
CREATION_DATE	DATE		Yes	One of the five standard "WHO" columns
LAST_UPDATED_BY	NUMBER		Yes	One of the five standard "WHO" columns
LAST_UPDATE_DATE	DATE		Yes	One of the five standard "WHO" columns
LAST_UPDATE_LOGIN	NUMBER			One of the five standard "WHO" columns
PROCESS_STATUS	NUMBER			Process Status of Import.
BUNDLE_ID	NUMBER			Bundle Id.

Query Text

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


SELECT SET_PROCESS_ID
,      UNIQUE_ID
,      TABLE_NAME
,      LANGUAGE
,      COLUMN_NAME
,      COLUMN_VALUE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      PROCESS_STATUS
,      BUNDLE_ID
FROM EGO.EGO_INTERFACE_TL;

Dependencies

[top of page]

EGO.EGO_INTERFACE_TL does not reference any database object

EGO.EGO_INTERFACE_TL is referenced by following:

APPS: EGO_INTERFACE_TL