VIEW: APPS.MTL_ADJUSTMENT_LOTSERIAL_V

Source

View Text - Preformatted

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 (+)

View Text - HTML Formatted

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 (+)