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_TRIGGERS_V

Product:	AMS - Marketing
Description:	This view returns all the Trigger details and the checks and Actions associated with it.
Implementation/DBA Data:	APPS.AMS_TRIGGERS_V

View Text

SELECT B.ROWID ROW_ID
, B.TRIGGER_ID
, C.TRIGGER_CHECK_ID
, NULL TRIGGER_ACTION_ID
, B.LAST_UPDATE_DATE
, B.LAST_UPDATED_BY
, B.CREATION_DATE
, B.CREATED_BY
, B.LAST_UPDATE_LOGIN
, B.OBJECT_VERSION_NUMBER
, B.PROCESS_ID
, B.TRIGGER_CREATED_FOR_ID
, B.ARC_TRIGGER_CREATED_FOR
, B.TIMEZONE_ID
, H.GLOBAL_TIMEZONE_NAME
, B.TRIGGERING_TYPE
, AMS_UTILITY_PVT.GET_LOOKUP_MEANING('AMS_TRIGGER_TYPE'
, B.TRIGGERING_TYPE) TRIGGERING_TYPE_NAME
, B.TRIGGER_NAME
, B.VIEW_APPLICATION_ID
, B.USER_START_DATE_TIME
, B.USER_LAST_RUN_DATE_TIME
, B.USER_NEXT_RUN_DATE_TIME
, B.USER_REPEAT_DAILY_START_TIME
, B.USER_REPEAT_DAILY_END_TIME
, B.REPEAT_FREQUENCY_TYPE
, B.REPEAT_EVERY_X_FREQUENCY
, B.USER_REPEAT_STOP_DATE_TIME
, B.METRICS_REFRESH_TYPE
, B.DESCRIPTION
, C.OBJECT_VERSION_NUMBER CHK_OBJ_VERSION_NUMBER
, C.CHK1_TYPE
, C.CHK1_ARC_SOURCE_CODE_FROM
, C.CHK1_ACT_OBJECT_ID
, C.CHK1_SOURCE_CODE
, C.CHK1_SOURCE_CODE_METRIC_ID
, C.CHK1_SOURCE_CODE_METRIC_TYPE
, C.CHK1_TO_CHK2_OPERATOR_TYPE
, C.CHK2_TYPE
, C.CHK2_VALUE
, C.CHK2_LOW_VALUE
, C.CHK2_HIGH_VALUE
, C.CHK2_SOURCE_CODE
, C.CHK2_ARC_SOURCE_CODE_FROM
, C.CHK2_ACT_OBJECT_ID
, C.CHK2_SOURCE_CODE_METRIC_ID
, C.CHK2_SOURCE_CODE_METRIC_TYPE
, C.CHK2_WORKBOOK_NAME
, C.CHK2_WORKBOOK_OWNER
, C.CHK2_UOM_CODE
, C.CHK2_CURRENCY_CODE
, C.CHK2_WORKSHEET_NAME
, NULL ACT_OBJ_VER_NUM
, NULL NOTIFY_FLAG
, NULL GENERATE_LIST_FLAG
, NULL ACTION_NEED_APPROVAL_FLAG
, NULL ACTION_APPROVER_USER_ID
, NULL APPROVER_NAME
, NULL EXECUTE_ACTION_TYPE
, NULL LIST_HEADER_ID
, NULL LIST_CONNECTED_TO_ID
, NULL ARC_LIST_CONNECTED_TO
, NULL DELIVERABLE_ID
, NULL ACTIVITY_OFFER_ID
, NULL DSCRIPT_NAME
, NULL COVER_LETTER_ID
, NULL MAIL_SUBJECT
, NULL MAIL_SENDER_NAME
, NULL FROM_FAX_NO
FROM AMS_TRIGGERS_VL B
, AMS_TRIGGER_CHECKS C
, HZ_TIMEZONES H
WHERE B.TRIGGER_ID = C.TRIGGER_ID(+)
AND H.TIMEZONE_ID = B.TIMEZONE_ID

Columns

Name
ROW_ID
TRIGGER_ID
TRIGGER_CHECK_ID
TRIGGER_ACTION_ID
LAST_UPDATE_DATE
LAST_UPDATED_BY
CREATION_DATE
CREATED_BY
LAST_UPDATE_LOGIN
OBJECT_VERSION_NUMBER
PROCESS_ID
TRIGGER_CREATED_FOR_ID
ARC_TRIGGER_CREATED_FOR
TIMEZONE_ID
TIMEZONE_NAME
TRIGGERING_TYPE
TRIGGERING_TYPE_NAME
TRIGGER_NAME
VIEW_APPLICATION_ID
USER_START_DATE_TIME
USER_LAST_RUN_DATE_TIME
USER_NEXT_RUN_DATE_TIME
USER_REPEAT_DAILY_START_TIME
USER_REPEAT_DAILY_END_TIME
REPEAT_FREQUENCY_TYPE
REPEAT_EVERY_X_FREQUENCY
USER_REPEAT_STOP_DATE_TIME
METRICS_REFRESH_TYPE
DESCRIPTION
CHK_OBJ_VERSION_NUMBER
CHK1_TYPE
CHK1_ARC_SOURCE_CODE_FROM
CHK1_ACT_OBJECT_ID
CHK1_SOURCE_CODE
CHK1_SOURCE_CODE_METRIC_ID
CHK1_SOURCE_CODE_METRIC_TYPE
CHK1_TO_CHK2_OPERATOR_TYPE
CHK2_TYPE
CHK2_VALUE
CHK2_LOW_VALUE
CHK2_HIGH_VALUE
CHK2_SOURCE_CODE
CHK2_ARC_SOURCE_CODE_FROM
CHK2_ACT_OBJECT_ID
CHK2_SOURCE_CODE_METRIC_ID
CHK2_SOURCE_CODE_METRIC_TYPE
CHK2_WORKBOOK_NAME
CHK2_WORKBOOK_OWNER
CHK2_UOM_CODE
CHK2_CURRENCY_CODE
CHK2_WORKSHEET_NAME
ACT_OBJ_VER_NUM
NOTIFY_FLAG
GENERATE_LIST_FLAG
ACTION_NEED_APPROVAL_FLAG
ACTION_APPROVER_USER_ID
APPROVER_NAME
EXECUTE_ACTION_TYPE
LIST_HEADER_ID
LIST_CONNECTED_TO_ID
ARC_LIST_CONNECTED_TO
DELIVERABLE_ID
ACTIVITY_OFFER_ID
DSCRIPT_NAME
COVER_LETTER_ID
MAIL_SUBJECT
MAIL_SENDER_NAME
FROM_FAX_NO