Delivery Order Bin Location Query

[kedalenechong]

Hi All

Please help to rectify my Query as there is duplicate row record?

SELECT T0."ItemCode",T3."TransNum",T0."Quantity",T3."OutQty",T3."InQty" ,T0."WhsCode", T2."BinCode"

FROM ODLN T4

INNER JOIN DLN1 T0 ON T4."DocEntry" = T0."DocEntry"

INNER JOIN OINM T3 ON T3."TransNum" = T0."DocEntry"

INNER JOIN OIBQ T1 ON T0."ItemCode" = T1."ItemCode" AND T0."WhsCode" = T1."WhsCode"

INNER JOIN OBIN T2 ON T2."AbsEntry" = T1."BinAbs"

INNER JOIN OBTL T5 ON T5."AbsEntry" = T1."AbsEntry"

WHERE T4."DocEntry" = '67213'

Kedalene Chong

[KennedyT21]

HI

Try this link

ODLN T0

INNER JOIN dbo.DLN1 T1 ON T1.DocEntry = T0.DocEntry

INNER JOIN dbo.OITM T2 ON T2.ItemCode = T1.ItemCode

INNER JOIN dbo.OCRD T3 ON T3.CardCode = T2.CardCode

LEFT JOIN [dbo].[B1_OinmWithBinTransfer] B1 ON B1.CreatedBy = T1.DocEntry AND B1.DocLineNum = T1.LineNum AND B1.TransType = T0.ObjType

LEFT JOIN [dbo].[OBTL] B2 ON B1.[InvPLMessageID] = B2.[MessageID]

LEFT JOIN [dbo].[OBIN] B3 ON B3.[AbsEntry] = B2.[BinAbs]

LEFT JOIN dbo.OBTN B4 ON B4.AbsEntry = B2.SnBMDAbs