[Home] [Help]
View: MTL_ADJUSTMENT_LOTSERIAL_V
View Text
SELECT MMT.TRANSACTION_ID
, MTLN.LOT_NUMBER
, MTLN.TRANSACTION_QUANTITY LOT_QUANTITY
, MUT.SERIAL_NUMBER
FROM MTL_MATERIAL_TRANSACTIONS MMT
, MTL_TRANSACTION_LOT_NUMBERS MTLN
, MTL_UNIT_TRANSACTIONS MUT
WHERE MMT.TRANSACTION_ID = MTLN.TRANSACTION_ID (+)
AND MMT.TRANSACTION_ID = MUT.TRANSACTION_ID (+)
AND MTLN.SERIAL_TRANSACTION_ID IS NULL UNION SELECT MMT.TRANSACTION_ID
, MTLN.LOT_NUMBER
, MTLN.TRANSACTION_QUANTITY LOT_QUANTITY
, MUT.SERIAL_NUMBER
FROM MTL_MATERIAL_TRANSACTIONS MMT
, MTL_TRANSACTION_LOT_NUMBERS MTLN
, MTL_UNIT_TRANSACTIONS MUT
WHERE MMT.TRANSACTION_ID = MTLN.TRANSACTION_ID (+)
AND MTLN.SERIAL_TRANSACTION_ID IS NOT NULL
AND MTLN.SERIAL_TRANSACTION_ID = MUT.TRANSACTION_ID (+)
Columns
Name |
TRANSACTION_ID |
LOT |
LOT_QUANTITY |
SERIAL |