eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

VIEW: AMS.AMS_TRIGGER_ACTIONS#

Source

View Text - Preformatted


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

View Text - HTML Formatted

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