[Home] [Help]
View: INVBV_ONHAND_BALANCES
View Text
SELECT MOQ.INVENTORY_ITEM_ID
, MOQ.ORGANIZATION_ID
, MOQ.DATE_RECEIVED
, MOQ.TRANSACTION_QUANTITY
, MOQ.SUBINVENTORY_CODE
, MOQ.REVISION
, MOQ.LOCATOR_ID
, MOQ.CREATE_TRANSACTION_ID
, MOQ.UPDATE_TRANSACTION_ID
, MOQ.LOT_NUMBER
, CREATED_BY
, MOQ.CREATION_DATE
, MOQ.LAST_UPDATED_BY
, MOQ.LAST_UPDATE_DATE
FROM MTL_ONHAND_QUANTITIES MOQ
WHERE '_SEC:MOQ.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY
Columns
Name |
INVENTORY_ITEM_ID |
ORGANIZATION_ID |
DATE_RECEIVED |
ONHAND_QUANTITY |
SUBINVENTORY_NAME |
REVISION |
INVENTORY_LOCATOR_ID |
CREATE_TRANSACTION_ID |
UPDATE_TRANSACTION_ID |
LOT_NUMBER |
CREATED_BY |
CREATION_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_DATE |