DBA Data[Home] [Help]

VIEW: INV.MTL_QOH_ITEM_TMP#

Source

View Text - Preformatted

select ORGANIZATION_ID ORGANIZATION_ID, INVENTORY_ITEM_ID INVENTORY_ITEM_ID, TOTAL_QOH TOTAL_QOH, RESERVED_QOH RESERVED_QOH, AVAILABLE_QOH AVAILABLE_QOH, PRIMARY_UOM_CODE PRIMARY_UOM_CODE from "INV"."MTL_QOH_ITEM_TMP"
View Text - HTML Formatted

SELECT ORGANIZATION_ID ORGANIZATION_ID
, INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, TOTAL_QOH TOTAL_QOH
, RESERVED_QOH RESERVED_QOH
, AVAILABLE_QOH AVAILABLE_QOH
, PRIMARY_UOM_CODE PRIMARY_UOM_CODE
FROM "INV"."MTL_QOH_ITEM_TMP"