[Home] [Help]
View: MTL_NEGATIVE_VIEW
Product: | INV - Inventory |
Description: | View of onhand negative inventory |
Implementation/DBA Data: |
APPS.MTL_NEGATIVE_VIEW
|
View Text
SELECT ORGANIZATION_ID
, INVENTORY_ITEM_ID
, REVISION
, SUBINVENTORY_CODE
, LOCATOR_ID
, LOT_NUMBER
, SUM(PRIMARY_TRANSACTION_QUANTITY) QUANTITY
FROM MTL_ONHAND_QUANTITIES_DETAIL GROUP BY ORGANIZATION_ID
, INVENTORY_ITEM_ID
, REVISION
, SUBINVENTORY_CODE
, LOCATOR_ID
, LOT_NUMBER HAVING SUM(PRIMARY_TRANSACTION_QUANTITY) < 0
Columns
Name |
ORGANIZATION_ID |
INVENTORY_ITEM_ID |
REVISION |
SUBINVENTORY_CODE |
LOCATOR_ID |
LOT_NUMBER |
QUANTITY |