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.

VIEW: OZF.OZF_QUOTA_ALERTS#

Source

View Text - Preformatted


select QUOTA_ALERT_ID QUOTA_ALERT_ID, REPORT_DATE REPORT_DATE, RESOURCE_ID RESOURCE_ID, ALERT_FOR ALERT_FOR, CUST_ACCOUNT_ID CUST_ACCOUNT_ID, SHIP_TO_SITE_USE_ID SHIP_TO_SITE_USE_ID, PRODUCT_ATTRIBUTE PRODUCT_ATTRIBUTE, PRODUCT_ATTR_VALUE PRODUCT_ATTR_VALUE, MTD_ALERT MTD_ALERT, QTD_ALERT QTD_ALERT, YTD_ALERT YTD_ALERT, BACK_ORDER_ALERT BACK_ORDER_ALERT, OUTSTAND_ORDER_ALERT OUTSTAND_ORDER_ALERT from "OZF"."OZF_QUOTA_ALERTS"

View Text - HTML Formatted

SELECT QUOTA_ALERT_ID QUOTA_ALERT_ID
, REPORT_DATE REPORT_DATE
, RESOURCE_ID RESOURCE_ID
, ALERT_FOR ALERT_FOR
, CUST_ACCOUNT_ID CUST_ACCOUNT_ID
, SHIP_TO_SITE_USE_ID SHIP_TO_SITE_USE_ID
, PRODUCT_ATTRIBUTE PRODUCT_ATTRIBUTE
, PRODUCT_ATTR_VALUE PRODUCT_ATTR_VALUE
, MTD_ALERT MTD_ALERT
, QTD_ALERT QTD_ALERT
, YTD_ALERT YTD_ALERT
, BACK_ORDER_ALERT BACK_ORDER_ALERT
, OUTSTAND_ORDER_ALERT OUTSTAND_ORDER_ALERT
FROM "OZF"."OZF_QUOTA_ALERTS"