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_INBOUND_MSG_EXT

Object Details

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

Table EGO_INBOUND_MSG_EXT stores the last message timestamp of messages received from other systems during import operations. Some of the information stored in this table includes the source system id, identifiers for supplier id and site from which the message was received, message timestamp, and information to identify the item for which the message applies such as inventory item id and organization.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
EGO_INBOUND_MSG_EXT_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	SOURCE_SYSTEM_ID DATA_LEVEL_ID INVENTORY_ITEM_ID ORGANIZATION_ID SUPPLIER_ID SUPPLIER_SITE_ID

Columns

Name	Datatype	Mandatory	Comments
SOURCE_SYSTEM_ID	NUMBER		Source System Identifier of the message
DATA_LEVEL_ID	NUMBER		Data level identifier of the item in message
INVENTORY_ITEM_ID	NUMBER		Inventory item identifier of the item in message
ORGANIZATION_ID	NUMBER		Organization identifier of the item in message
SUPPLIER_ID	NUMBER		Supplier identifier from which the message came
SUPPLIER_SITE_ID	NUMBER		Supplier Site identifier from which the message came
LAST_MESSAGE_TIMESTAMP	DATE		Date/Time of the last message received for this item
CREATION_DATE	DATE	Yes	Standard WHO column
CREATED_BY	NUMBER	Yes	Standard WHO column
LAST_UPDATE_DATE	DATE	Yes	Standard WHO column
LAST_UPDATED_BY	NUMBER	Yes	Standard WHO column
LAST_UPDATE_LOGIN	NUMBER		Standard WHO column

Query Text

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


SELECT SOURCE_SYSTEM_ID
,      DATA_LEVEL_ID
,      INVENTORY_ITEM_ID
,      ORGANIZATION_ID
,      SUPPLIER_ID
,      SUPPLIER_SITE_ID
,      LAST_MESSAGE_TIMESTAMP
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
FROM EGO.EGO_INBOUND_MSG_EXT;

Dependencies

[top of page]

EGO.EGO_INBOUND_MSG_EXT does not reference any database object

EGO.EGO_INBOUND_MSG_EXT is referenced by following:

EGO: EGO_INBOUND_MSG_EXT#