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_CHECKS#

Source

View Text - Preformatted


select TRIGGER_CHECK_ID TRIGGER_CHECK_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, TRIGGER_ID TRIGGER_ID, ORDER_NUMBER ORDER_NUMBER, CHK1_TYPE CHK1_TYPE, CHK1_ARC_SOURCE_CODE_FROM CHK1_ARC_SOURCE_CODE_FROM, CHK1_SOURCE_CODE CHK1_SOURCE_CODE, CHK1_SOURCE_CODE_METRIC_ID CHK1_SOURCE_CODE_METRIC_ID, CHK1_SOURCE_CODE_METRIC_TYPE CHK1_SOURCE_CODE_METRIC_TYPE, CHK1_TO_CHK2_OPERATOR_TYPE CHK1_TO_CHK2_OPERATOR_TYPE, CHK2_TYPE CHK2_TYPE, CHK2_VALUE CHK2_VALUE, CHK2_LOW_VALUE CHK2_LOW_VALUE, CHK2_HIGH_VALUE CHK2_HIGH_VALUE, CHK2_UOM_CODE CHK2_UOM_CODE, CHK2_CURRENCY_CODE CHK2_CURRENCY_CODE, CHK2_SOURCE_CODE CHK2_SOURCE_CODE, CHK2_ARC_SOURCE_CODE_FROM CHK2_ARC_SOURCE_CODE_FROM, CHK2_SOURCE_CODE_METRIC_ID CHK2_SOURCE_CODE_METRIC_ID, CHK2_SOURCE_CODE_METRIC_TYPE CHK2_SOURCE_CODE_METRIC_TYPE, CHK2_WORKBOOK_NAME CHK2_WORKBOOK_NAME, CHK2_WORKBOOK_OWNER CHK2_WORKBOOK_OWNER, CHK2_WORKSHEET_NAME CHK2_WORKSHEET_NAME, SECURITY_GROUP_ID SECURITY_GROUP_ID, CHK1_ACT_OBJECT_ID CHK1_ACT_OBJECT_ID, CHK2_ACT_OBJECT_ID CHK2_ACT_OBJECT_ID from "AMS"."AMS_TRIGGER_CHECKS"

View Text - HTML Formatted

SELECT TRIGGER_CHECK_ID TRIGGER_CHECK_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
, TRIGGER_ID TRIGGER_ID
, ORDER_NUMBER ORDER_NUMBER
, CHK1_TYPE CHK1_TYPE
, CHK1_ARC_SOURCE_CODE_FROM CHK1_ARC_SOURCE_CODE_FROM
, CHK1_SOURCE_CODE CHK1_SOURCE_CODE
, CHK1_SOURCE_CODE_METRIC_ID CHK1_SOURCE_CODE_METRIC_ID
, CHK1_SOURCE_CODE_METRIC_TYPE CHK1_SOURCE_CODE_METRIC_TYPE
, CHK1_TO_CHK2_OPERATOR_TYPE CHK1_TO_CHK2_OPERATOR_TYPE
, CHK2_TYPE CHK2_TYPE
, CHK2_VALUE CHK2_VALUE
, CHK2_LOW_VALUE CHK2_LOW_VALUE
, CHK2_HIGH_VALUE CHK2_HIGH_VALUE
, CHK2_UOM_CODE CHK2_UOM_CODE
, CHK2_CURRENCY_CODE CHK2_CURRENCY_CODE
, CHK2_SOURCE_CODE CHK2_SOURCE_CODE
, CHK2_ARC_SOURCE_CODE_FROM CHK2_ARC_SOURCE_CODE_FROM
, CHK2_SOURCE_CODE_METRIC_ID CHK2_SOURCE_CODE_METRIC_ID
, CHK2_SOURCE_CODE_METRIC_TYPE CHK2_SOURCE_CODE_METRIC_TYPE
, CHK2_WORKBOOK_NAME CHK2_WORKBOOK_NAME
, CHK2_WORKBOOK_OWNER CHK2_WORKBOOK_OWNER
, CHK2_WORKSHEET_NAME CHK2_WORKSHEET_NAME
, SECURITY_GROUP_ID SECURITY_GROUP_ID
, CHK1_ACT_OBJECT_ID CHK1_ACT_OBJECT_ID
, CHK2_ACT_OBJECT_ID CHK2_ACT_OBJECT_ID
FROM "AMS"."AMS_TRIGGER_CHECKS"