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

TABLE: MTH.MTH_EVENT_ACTION_SETUP

Object Details
Object Name: MTH_EVENT_ACTION_SETUP
Object Type: TABLE
Owner: MTH
FND Design Data: TableMTH.MTH_EVENT_ACTION_SETUP
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_ACTION_ID NUMBER
Yes Event Action identifier
EVENT_SETUP_ID NUMBER
Yes Event Setup identifier
ACTION_TYPE_CODE VARCHAR2 (30) Yes Action Type code - Code defined in FND table for Event action
PERSONNEL_FK_KEY NUMBER

Reference to personnel
ACTION_HANDLER_CODE VARCHAR2 (30)
API Lookup code from MTH_LOOKUPS_D
EMAIL_NOTIFICATION VARCHAR2 (1)
1- send email 0 - none
MOBILE_NOTIFICATION VARCHAR2 (1)
1- send text message0 - none
DOMAIN_NAME VARCHAR2 (120)
Domain Name
CREATION_DATE DATE

Standard who column
LAST_UPDATE_DATE DATE

Standard who column
CREATION_SYSTEM_ID NUMBER

Standard who column
LAST_UPDATE_SYSTEM_ID NUMBER

Standard who column
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_ACTION_ID
,      EVENT_SETUP_ID
,      ACTION_TYPE_CODE
,      PERSONNEL_FK_KEY
,      ACTION_HANDLER_CODE
,      EMAIL_NOTIFICATION
,      MOBILE_NOTIFICATION
,      DOMAIN_NAME
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      CREATION_SYSTEM_ID
,      LAST_UPDATE_SYSTEM_ID
,      CREATED_BY
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
FROM MTH.MTH_EVENT_ACTION_SETUP;

Dependencies

[top of page]

MTH.MTH_EVENT_ACTION_SETUP does not reference any database object

MTH.MTH_EVENT_ACTION_SETUP is referenced by following:

SchemaMTH
ViewMTH_EVENT_ACTION_SETUP#