[Home] [Help] [Dependency Information]
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
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
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 |
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. |
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;
EGO.EGO_UCCNET_EVENTS does not reference any database object
EGO.EGO_UCCNET_EVENTS is referenced by following:
|
|
|