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

TABLE: AMS.AMS_TRIGGER_ACTIONS

Object Details
Object Name: AMS_TRIGGER_ACTIONS
Object Type: TABLE
Owner: AMS
FND Design Data: TableAMS.AMS_TRIGGER_ACTIONS
Subobject Name:
Status: VALID


AMS_TRIGGER_ACTIONS contains the actions that should be performed when a certain trigger is fired at specific time when certain conditions are met.
Some examples for pure date driven actions:
- Repeat creation of a List once a month.
- Send Notification When ROI reaches more than certain value.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
AMS_TRIGGER_ACTIONS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnTRIGGER_ACTION_ID
AMS_TRIGGER_ACTIONS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnTRIGGER_ID
AMS_TRIGGER_ACTIONS_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnACTION_APPROVER_USER_ID
AMS_TRIGGER_ACTIONS_N3 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnLIST_HEADER_ID
Columns
Name Datatype Length Mandatory Comments
TRIGGER_ACTION_ID NUMBER
Yes Unique Identifier.
LAST_UPDATE_DATE DATE
Yes Standard WHO Column
LAST_UPDATED_BY NUMBER (15) Yes Standard WHO Column
CREATION_DATE DATE
Yes Standard WHO Column
CREATED_BY NUMBER (15) Yes Standard WHO Column
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO Column
OBJECT_VERSION_NUMBER NUMBER (9)
This column is used for locking purposes.
PROCESS_ID NUMBER

Item Key of last Workflow process ran for this Trigger
TRIGGER_ID NUMBER
Yes Indicates Trigger which these actions are connected to
ORDER_NUMBER NUMBER (15)
Order number of the Actions.
NOTIFY_FLAG VARCHAR2 (1) Yes Indicates whether Notifications has to be sent when the Trigger fires.
GENERATE_LIST_FLAG VARCHAR2 (1) Yes Indicates whether List has to be generated when the Trigger fires.
ACTION_NEED_APPROVAL_FLAG VARCHAR2 (1) Yes Indicates whether the generated List needs approval.
ACTION_APPROVER_USER_ID NUMBER

Indicates the approver of the List, usually Campaign Owner.
EXECUTE_ACTION_TYPE VARCHAR2 (30)
Actions Performed when the Trigger was fired, Used by workflow process.
LIST_HEADER_ID NUMBER

Indicates the List to be generated.
LIST_CONNECTED_TO_ID NUMBER

Indicates the id of the Activity the List is connected to.
ARC_LIST_CONNECTED_TO VARCHAR2 (30)
Indicates whether the List is connected to Schedule.
DELIVERABLE_ID NUMBER

Indicates the Collateral to be fulfilled.
ACTIVITY_OFFER_ID NUMBER

Indicates the Activity Offer to be attached to the Schedule.
DSCRIPT_NAME VARCHAR2 (256)
Indicates deployed Script name.
PROGRAM_TO_CALL VARCHAR2 (30)
Indicates the Program to call on the execution of the Trigger.
SECURITY_GROUP_ID NUMBER

Used in hosted environments
COVER_LETTER_ID NUMBER

Indentifier of the cover letter being sent
MAIL_SUBJECT VARCHAR2 (240)
Subject of the mail
MAIL_SENDER_NAME VARCHAR2 (120)
Name of the mail sender
FROM_FAX_NO VARCHAR2 (25)
The incoming fax number
ACTION_FOR_ID NUMBER

Indicates the notifier id.
Query Text

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


SELECT TRIGGER_ACTION_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      OBJECT_VERSION_NUMBER
,      PROCESS_ID
,      TRIGGER_ID
,      ORDER_NUMBER
,      NOTIFY_FLAG
,      GENERATE_LIST_FLAG
,      ACTION_NEED_APPROVAL_FLAG
,      ACTION_APPROVER_USER_ID
,      EXECUTE_ACTION_TYPE
,      LIST_HEADER_ID
,      LIST_CONNECTED_TO_ID
,      ARC_LIST_CONNECTED_TO
,      DELIVERABLE_ID
,      ACTIVITY_OFFER_ID
,      DSCRIPT_NAME
,      PROGRAM_TO_CALL
,      SECURITY_GROUP_ID
,      COVER_LETTER_ID
,      MAIL_SUBJECT
,      MAIL_SENDER_NAME
,      FROM_FAX_NO
,      ACTION_FOR_ID
FROM AMS.AMS_TRIGGER_ACTIONS;

Dependencies

[top of page]

AMS.AMS_TRIGGER_ACTIONS does not reference any database object

AMS.AMS_TRIGGER_ACTIONS is referenced by following:

SchemaAMS
ViewAMS_TRIGGER_ACTIONS#