[Home] [Help]
View: MTL_ITEM_LOT_QUANTITIES_VIEW
View Text
SELECT Q.ORGANIZATION_ID
, Q.INVENTORY_ITEM_ID
, Q.SUBINVENTORY_CODE
, Q.LOCATOR_ID
, Q.REVISION
, L.EXPIRATION_DATE
, Q.LOT_NUMBER
, SUM(PRIMARY_TRANSACTION_QUANTITY) QUANTITY
FROM MTL_ONHAND_QUANTITIES_DETAIL Q
, MTL_LOT_NUMBERS L
WHERE Q.ORGANIZATION_ID = L.ORGANIZATION_ID
AND Q.INVENTORY_ITEM_ID = L.INVENTORY_ITEM_ID
AND Q.LOT_NUMBER = L.LOT_NUMBER GROUP BY Q.ORGANIZATION_ID
, Q.INVENTORY_ITEM_ID
, Q.SUBINVENTORY_CODE
, Q.REVISION
, Q.LOCATOR_ID
, Q.LOT_NUMBER
, L.EXPIRATION_DATE
Columns
Name |
ORGANIZATION_ID |
INVENTORY_ITEM_ID |
SUBINVENTORY_CODE |
LOCATOR_ID |
REVISION |
EXPIRATION_DATE |
LOT_NUMBER |
QUANTITY |