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: TableEGO.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: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
EGO_UCCNET_EVENTS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnEVENT_ROW_ID
EGO_UCCNET_EVENTS_U2 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnINVENTORY_ITEM_ID
ColumnORGANIZATION_ID
ColumnADDRESS_ID
ColumnPARENT_GTIN
ColumnEVENT_TYPE
ColumnEVENT_ACTION
ColumnDISPOSITION_CODE
ColumnEVENT_ROW_ID
EGO_UCCNET_EVENTS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnBATCH_ID
ColumnTOP_ITEM_ID
ColumnORGANIZATION_ID
ColumnADDRESS_ID
ColumnINVENTORY_ITEM_ID
EGO_UCCNET_EVENTS_N10 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnIMPORT_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:

SchemaAPPS
SynonymEGO_UCCNET_EVENTS