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

Source

View Text - Preformatted


select TIME_ID TIME_ID, PERIOD_TYPE_ID PERIOD_TYPE_ID, SOLD_TO_CUST_ACCOUNT_ID SOLD_TO_CUST_ACCOUNT_ID, SHIP_TO_SITE_USE_ID SHIP_TO_SITE_USE_ID, BILL_TO_SITE_USE_ID BILL_TO_SITE_USE_ID, INVENTORY_ITEM_ID INVENTORY_ITEM_ID, SALES_QTY SALES_QTY, SALES_AMT SALES_AMT from "OZF"."OZF_ORDER_SALES_SUMRY_MV"

View Text - HTML Formatted

SELECT TIME_ID TIME_ID
, PERIOD_TYPE_ID PERIOD_TYPE_ID
, SOLD_TO_CUST_ACCOUNT_ID SOLD_TO_CUST_ACCOUNT_ID
, SHIP_TO_SITE_USE_ID SHIP_TO_SITE_USE_ID
, BILL_TO_SITE_USE_ID BILL_TO_SITE_USE_ID
, INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, SALES_QTY SALES_QTY
, SALES_AMT SALES_AMT
FROM "OZF"."OZF_ORDER_SALES_SUMRY_MV"