[Home] [Help]
View: MTL_TRANSACTION_LOTS_VIEW
View Text
SELECT (SUM(MTLN.PRIMARY_QUANTITY) * -1) TOTAL_LOT_QUANTITY
, MTLN.INVENTORY_ITEM_ID
, MSI.DESCRIPTION
, MSI.PRIMARY_UOM_CODE
, MTLN.TRANSACTION_SOURCE_ID
, MTLN.TRANSACTION_SOURCE_TYPE_ID
, MTLN.ORGANIZATION_ID
, MTLN.LOT_NUMBER
FROM MTL_TRANSACTION_LOT_NUMBERS MTLN
, MTL_SYSTEM_ITEMS MSI
WHERE MTLN.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID
AND MTLN.ORGANIZATION_ID = MSI.ORGANIZATION_ID GROUP BY MTLN.ORGANIZATION_ID
, MTLN.TRANSACTION_SOURCE_TYPE_ID
, MTLN.TRANSACTION_SOURCE_ID
, MTLN.INVENTORY_ITEM_ID
, MTLN.LOT_NUMBER
, MSI.DESCRIPTION
, MSI.PRIMARY_UOM_CODE
Columns
Name |
TOTAL_LOT_QUANTITY |
INVENTORY_ITEM_ID |
DESCRIPTION |
PRIMARY_UOM_CODE |
DISPOSITION |
DISPOSITION_TYPE |
ORGANIZATION_ID |
TRANSACTION_LOT_NUMBER |