[Home] [Help] [Dependency Information]
Object Name: | EGO_UCCNET_EVENTS# |
---|---|
Object Type: | VIEW |
Owner: | EGO |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
EVENT_ROW_ID | NUMBER | Yes | ||
EVENT_TYPE | VARCHAR2 | (30) | Yes | |
EVENT_ACTION | VARCHAR2 | (30) | Yes | |
BATCH_ID | NUMBER | Yes | ||
GTIN | VARCHAR2 | (14) | Yes | |
SUPPLIER_GLN | VARCHAR2 | (13) | Yes | |
TARGET_MARKET | VARCHAR2 | (3) | Yes | |
CREATED_BY | NUMBER | Yes | ||
CREATION_DATE | DATE | Yes | ||
LAST_UPDATED_BY | NUMBER | Yes | ||
LAST_UPDATE_DATE | DATE | Yes | ||
LAST_UPDATE_LOGIN | NUMBER | |||
SUBBATCH_ID | NUMBER | |||
DISPOSITION_CODE | VARCHAR2 | (30) | ||
DISPOSITION_DATE | DATE | |||
CLN_ID | NUMBER | |||
TP_GLN | VARCHAR2 | (13) | ||
PARENT_GTIN | VARCHAR2 | (14) | ||
TOP_GTIN | VARCHAR2 | (14) | ||
QUANTITY | NUMBER | |||
TOTAL_QUANTITY | NUMBER | |||
NUMBER_OF_CHILDREN | NUMBER | |||
PLAN_LEVEL | NUMBER | |||
INDUSTRY | VARCHAR2 | (30) | ||
INVENTORY_ITEM_ID | NUMBER | |||
ORGANIZATION_ID | NUMBER | |||
PARTY_SITE_ID | NUMBER | |||
ADDRESS_ID | NUMBER | |||
ASSEMBLY_ITEM_ID | NUMBER | |||
TOP_ITEM_ID | NUMBER | |||
EXT_COMPLEX_ITEM_REFERENCE | VARCHAR2 | (255) | ||
IMPORT_BATCH_ID | NUMBER | |||
MESSAGE_ID | VARCHAR2 | (80) | ||
SOURCE_SYSTEM_ID | NUMBER | |||
SOURCE_SYSTEM_REFERENCE | VARCHAR2 | (255) |
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#;
|
|
|