DBA Data[Home] [Help] [Dependency Information]

TABLE: MTH.MTH_EVENTS

Object Details
Object Name: MTH_EVENTS
Object Type: TABLE
Owner: MTH
FND Design Data: TableMTH.MTH_EVENTS
Subobject Name:
Status: VALID


This table stores information on Event Action setup for handling Events. It holds information like Event Type, Event action and Event notification setup.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
EVENT_ID NUMBER
Yes Event identifier
EVENT_TYPE VARCHAR2 (120) Yes Event type
CREATION_DATE DATE
Yes Standard who column
LAST_UPDATE_DATE DATE
Yes Standard who column
CREATION_SYSTEM_ID NUMBER
Yes Standard who column
LAST_UPDATE_SYSTEM_ID NUMBER
Yes Standard who column
EVENT_DESCRIPTION VARCHAR2 (240)
Rule condition of Event
REASON_CODE VARCHAR2 (30)
Reason code
TAG_READING_TIME DATE

Time of Tag Reading
EQUIPMENT_FK_KEY NUMBER

Reference to equipment
SHIFT_WORKDAY_FK_KEY NUMBER

Reference to Shift Workday
WORKORDER_FK_KEY NUMBER

Reference to Workorder
EQUIP_STATUS NUMBER

Equipment Status
CREATED_BY NUMBER (15)
Standard who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column
LAST_UPDATED_BY NUMBER (15)
Standard who column
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT EVENT_ID
,      EVENT_TYPE
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      CREATION_SYSTEM_ID
,      LAST_UPDATE_SYSTEM_ID
,      EVENT_DESCRIPTION
,      REASON_CODE
,      TAG_READING_TIME
,      EQUIPMENT_FK_KEY
,      SHIFT_WORKDAY_FK_KEY
,      WORKORDER_FK_KEY
,      EQUIP_STATUS
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      LAST_UPDATED_BY
FROM MTH.MTH_EVENTS;

Dependencies

[top of page]

MTH.MTH_EVENTS does not reference any database object

MTH.MTH_EVENTS is referenced by following:

SchemaAPPS
Materialized ViewMTH_SHIFT_REFERENCE_MV
SchemaMTH
ViewMTH_EVENTS#