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: OZF.OZF_INVENTORY_SUMMARY_MV#

Source

View Text - Preformatted


select TIME_ID TIME_ID, PERIOD_TYPE_ID PERIOD_TYPE_ID, PARTY_ID PARTY_ID, INVENTORY_ITEM_ID INVENTORY_ITEM_ID, PRIMARY_UOM PRIMARY_UOM, COMMON_QUANTITY_IN COMMON_QUANTITY_IN, COMMON_QUANTITY_OUT COMMON_QUANTITY_OUT, COMMON_QUANTITY_MANUAL COMMON_QUANTITY_MANUAL, PRIMARY_QUANTITY PRIMARY_QUANTITY from "OZF"."OZF_INVENTORY_SUMMARY_MV"

View Text - HTML Formatted

SELECT TIME_ID TIME_ID
, PERIOD_TYPE_ID PERIOD_TYPE_ID
, PARTY_ID PARTY_ID
, INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, PRIMARY_UOM PRIMARY_UOM
, COMMON_QUANTITY_IN COMMON_QUANTITY_IN
, COMMON_QUANTITY_OUT COMMON_QUANTITY_OUT
, COMMON_QUANTITY_MANUAL COMMON_QUANTITY_MANUAL
, PRIMARY_QUANTITY PRIMARY_QUANTITY
FROM "OZF"."OZF_INVENTORY_SUMMARY_MV"