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]

VIEW: EGO.EGO_UCCNET_EVENTS#

Object Details

Object Name:	EGO_UCCNET_EVENTS#
Object Type:	VIEW
Owner:	EGO
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Mandatory
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)

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# references the following:

EGO: EGO_UCCNET_EVENTS

EGO.EGO_UCCNET_EVENTS# is referenced by following:

APPS: EGO_UCCNET_EVENTS