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

TABLE: MTH.MTH_EVENT_ACTIONS

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


This table stores the event actions history. It holds information like Event Type, Event action and details of Event action taken.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
EVENT_ID NUMBER
Yes Event identifier
ACTION_TYPE_CODE VARCHAR2 (30) Yes Action Type code - Code defined in FND table for Event action
LINE_NUM NUMBER
Yes Sequence number to identify different actions
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
NOTIFICATION_ID VARCHAR2 (100)
Email address or Mobile phone
NOTIFICATION_CONTENT VARCHAR2 (4000)
Notification Content
ACTION_REFERENCE_ID NUMBER

Action Returned ID, i.e. Work Request ID
ACTION_STATUS VARCHAR2 (1024)
Action Returned Status from call-out API
ACTION_HANDLER_API VARCHAR2 (1024)
Call-out API
CREATED_BY NUMBER

Standard who column
LAST_UPDATED_BY NUMBER

Standard who column
LAST_UPDATE_LOGIN NUMBER

Standard who column
Query Text

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


SELECT EVENT_ID
,      ACTION_TYPE_CODE
,      LINE_NUM
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      CREATION_SYSTEM_ID
,      LAST_UPDATE_SYSTEM_ID
,      NOTIFICATION_ID
,      NOTIFICATION_CONTENT
,      ACTION_REFERENCE_ID
,      ACTION_STATUS
,      ACTION_HANDLER_API
,      CREATED_BY
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
FROM MTH.MTH_EVENT_ACTIONS;

Dependencies

[top of page]

MTH.MTH_EVENT_ACTIONS does not reference any database object

MTH.MTH_EVENT_ACTIONS is referenced by following:

SchemaMTH
ViewMTH_EVENT_ACTIONS#