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_UCCNET_EVENTS

Object Details

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

This table stores the events which are triggered by users to send messages to UCCnet

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
EGO_UCCNET_EVENTS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	EVENT_ROW_ID
EGO_UCCNET_EVENTS_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	INVENTORY_ITEM_ID ORGANIZATION_ID ADDRESS_ID PARENT_GTIN EVENT_TYPE EVENT_ACTION DISPOSITION_CODE EVENT_ROW_ID
EGO_UCCNET_EVENTS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	BATCH_ID TOP_ITEM_ID ORGANIZATION_ID ADDRESS_ID INVENTORY_ITEM_ID
EGO_UCCNET_EVENTS_N10	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	IMPORT_BATCH_ID

Columns

Name	Datatype	Length	Mandatory	Comments
EVENT_ROW_ID	NUMBER		Yes	Sequence-generated unique row identifier
EVENT_TYPE	VARCHAR2	(30)	Yes	Type of event (e.g., Registration or Publication). Foreign key to FND_LOOKUP_VALUES.LOOKUP_TYPE (where type is EGO_UCCNET_MESSAGE_TYPE)
EVENT_ACTION	VARCHAR2	(30)	Yes	Action to be performed on this event: depends upon the Event Type. Foreign key to FND_LOOKUP_VALUES.LOOKUP_TYPE (where type is EGO_UCCNET_CIN_ACTION or EGO_UCCNET_RCIR_ACTION)
BATCH_ID	NUMBER		Yes	Sequence-generated unique identifier of the batch in which this event is processed
GTIN	VARCHAR2	(14)	Yes	Global Trade Item Number: a globally unique identifier for this item, generated according to EAN/UCC standards
SUPPLIER_GLN	VARCHAR2	(13)	Yes	Global Location Number (a globally unique identifier, generated according to EAN/UCC standards) for the supplier
TARGET_MARKET	VARCHAR2	(3)	Yes	Geographic region in which this item is traded
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
SUBBATCH_ID	NUMBER			Sequence-generated unique identifier of sub-batch within the batch
DISPOSITION_CODE	VARCHAR2	(30)		Code indicating status of this event. Foreign key to FND_LOOKUP_VALUES.LOOKUP_TYPE (where type is EGO_UCCNET_DISPOSITION)
DISPOSITION_DATE	DATE			Date when disposition code was last updated
CLN_ID	NUMBER			Collaboration ID: foreign key to CLN_COLL_HIST_HDR.COLLABORATION_ID
TP_GLN	VARCHAR2	(13)		Global Location Number of trading partner to which this event was sent
PARENT_GTIN	VARCHAR2	(14)		Parent GTIN of current GTIN in hierarchy
TOP_GTIN	VARCHAR2	(14)		Top GTIN in the current hierarchy
QUANTITY	NUMBER			Quantity of GTINs in next level of hierarchy
TOTAL_QUANTITY	NUMBER			Total quantity of GTINs in hierarchy
NUMBER_OF_CHILDREN	NUMBER			Number of children of current GTIN in hierarchy
PLAN_LEVEL	NUMBER			Level of current GTIN in hierarchy
INDUSTRY	VARCHAR2	(30)		Code indicating the industry to which this item belongs; used in generation of industry-specific XML messages
INVENTORY_ITEM_ID	NUMBER			Inventory item identifier.Foreign key to MTL_SYSTEM_ITEMS_B
ORGANIZATION_ID	NUMBER			Organization identifier.Foreign key to MTL_SYSTEM_ITEMS_B
PARTY_SITE_ID	NUMBER			Foreign key to HZ_PARTY_SITES
ADDRESS_ID	NUMBER			Foreign key to HZ_CUST_ACCT_SITES
ASSEMBLY_ITEM_ID	NUMBER			Foreign key to BOM_STRUCTURES_B
TOP_ITEM_ID	NUMBER			Inventory item ID of Top GTIN
EXT_COMPLEX_ITEM_REFERENCE	VARCHAR2	(255)		External referene for incoming item.
IMPORT_BATCH_ID	NUMBER			Batch Id.
MESSAGE_ID	VARCHAR2	(80)		Message Id of incoming message.
SOURCE_SYSTEM_ID	NUMBER			Source System Id for incoming item.
SOURCE_SYSTEM_REFERENCE	VARCHAR2	(255)		Source System Reference for incoming item.

Query Text

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


SELECT EVENT_ROW_ID
,      EVENT_TYPE
,      EVENT_ACTION
,      BATCH_ID
,      GTIN
,      SUPPLIER_GLN
,      TARGET_MARKET
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      SUBBATCH_ID
,      DISPOSITION_CODE
,      DISPOSITION_DATE
,      CLN_ID
,      TP_GLN
,      PARENT_GTIN
,      TOP_GTIN
,      QUANTITY
,      TOTAL_QUANTITY
,      NUMBER_OF_CHILDREN
,      PLAN_LEVEL
,      INDUSTRY
,      INVENTORY_ITEM_ID
,      ORGANIZATION_ID
,      PARTY_SITE_ID
,      ADDRESS_ID
,      ASSEMBLY_ITEM_ID
,      TOP_ITEM_ID
,      EXT_COMPLEX_ITEM_REFERENCE
,      IMPORT_BATCH_ID
,      MESSAGE_ID
,      SOURCE_SYSTEM_ID
,      SOURCE_SYSTEM_REFERENCE
FROM EGO.EGO_UCCNET_EVENTS;

Dependencies

[top of page]

EGO.EGO_UCCNET_EVENTS does not reference any database object

EGO.EGO_UCCNET_EVENTS is referenced by following:

EGO: EGO_UCCNET_EVENTS#