SELECT
        T3.[ItemCode],
        T3.[ItemName],
        T2.[WhsCode],
        T2.[WhsName],
        T0.[SL1Code],
        T0.[Descr],
        T1.[OnHandQty],
        T3.[SalUnitMsr]
    FROM
        OBIN T0
    INNER JOIN
        OIBQ T1 ON T0.[AbsEntry] = T1.[BinAbs] AND T0.[WhsCode] = T1.[WhsCode]
    INNER JOIN
        OWHS T2 ON T1.[WhsCode] = T2.[WhsCode]
    INNER JOIN
        OITM T3 ON T1.[ItemCode] = T3.[ItemCode]
    WHERE
        T1.[OnHandQty] > 0
        AND T0.[SL1Code] = :SL1Code
    ORDER BY
        T3.[ItemCode] ASC