Lots per albarà

Relació de tots els lots d’un albarà

select L.DistNumber Lot,LLO1.ItemCode Article,LO1.DocLine Linia,LAL.Quantity QuantitatLinia,LLO1.Quantity QuantitatLot 
from OITL LO1
join ITL1 LLO1 on LLO1.LogEntry=LO1.LogEntry 
join OBTN L on L.SysNumber=LLO1.SysNumber and L.ItemCode=LLO1.ItemCode
join ODLN AL on AL.DocEntry=LO1.DocEntry 
join DLN1 LAL on LAL.DocEntry=LO1.DocEntry and LAL.LineNum=LO1.DocLine
where LO1.DocType=15 and LO1.DocEntry=404218
order by LO1.DocLine