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

VIEW: AMS.AMS_TRIGGER_ACTIONS#

Object Details
Object Name: AMS_TRIGGER_ACTIONS#
Object Type: VIEW
Owner: AMS
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
TRIGGER_ACTION_ID NUMBER
Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER (15) Yes
CREATION_DATE DATE
Yes
CREATED_BY NUMBER (15) Yes
LAST_UPDATE_LOGIN NUMBER (15)
OBJECT_VERSION_NUMBER NUMBER (9)
PROCESS_ID NUMBER

TRIGGER_ID NUMBER
Yes
ORDER_NUMBER NUMBER (15)
NOTIFY_FLAG VARCHAR2 (1) Yes
GENERATE_LIST_FLAG VARCHAR2 (1) Yes
ACTION_NEED_APPROVAL_FLAG VARCHAR2 (1) Yes
ACTION_APPROVER_USER_ID NUMBER

EXECUTE_ACTION_TYPE VARCHAR2 (30)
LIST_HEADER_ID NUMBER

LIST_CONNECTED_TO_ID NUMBER

ARC_LIST_CONNECTED_TO VARCHAR2 (30)
DELIVERABLE_ID NUMBER

ACTIVITY_OFFER_ID NUMBER

DSCRIPT_NAME VARCHAR2 (256)
PROGRAM_TO_CALL VARCHAR2 (30)
SECURITY_GROUP_ID NUMBER

COVER_LETTER_ID NUMBER

MAIL_SUBJECT VARCHAR2 (240)
MAIL_SENDER_NAME VARCHAR2 (120)
FROM_FAX_NO VARCHAR2 (25)
ACTION_FOR_ID NUMBER

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

SchemaAMS
TableAMS_TRIGGER_ACTIONS
AMS.AMS_TRIGGER_ACTIONS# is referenced by following:

SchemaAPPS
SynonymAMS_TRIGGER_ACTIONS