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.

VIEW: EGO.EGO_UCCNET_EVENTS#

Source

View Text - Preformatted


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

View Text - HTML Formatted

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