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_BUSINESS_EVENTS_TRACKING

Object Details

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

This table is used to queue up the Item, Catalog and Structure related business events and their payload. This is currently used for sunc

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
EGO_BUS_EVTS_TRKG_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	SEQUENCE_ID
SYS_IL0000455376C00009$$	LOB	UNIQUE	APPS_TS_TX_DATA
SYS_IL0000455376C00012$$	LOB	UNIQUE	APPS_TS_TX_DATA

Columns

Name	Datatype	Length	Mandatory	Comments
SEQUENCE_ID	NUMBER		Yes	Sequence Id
INVOKE_DATE	DATE		Yes	Invocation Date
BUSINESS_EVENT_NAME	VARCHAR2	(4000)	Yes	Business Event Name
EVENT_PAYLOAD	WF_EVENT_T	(1)	Yes	Event Payload
INVENTORY_ITEM_ID	NUMBER			Inventory Item Id
ORGANIZATION_ID	NUMBER			Organization Id
CATALOG_ID	NUMBER			Catalog Id
CATEGORY_ID	NUMBER			Category Id

Query Text

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


SELECT SEQUENCE_ID
,      INVOKE_DATE
,      BUSINESS_EVENT_NAME
,      EVENT_PAYLOAD
,      INVENTORY_ITEM_ID
,      ORGANIZATION_ID
,      CATALOG_ID
,      CATEGORY_ID
FROM EGO.EGO_BUSINESS_EVENTS_TRACKING;

Dependencies

[top of page]

EGO.EGO_BUSINESS_EVENTS_TRACKING references the following:

APPS: WF_EVENT_T; WF_PARAMETER_LIST_T; WF_PARAMETER_T
SYS: STANDARD - show dependent code

EGO.EGO_BUSINESS_EVENTS_TRACKING is referenced by following:

APPS: EGO_BUSINESS_EVENTS_TRACKING