Costed Inventory

SELECT
    trim(T2.LIMCU),
    TRIM(T1.IMLITM),
    TRIM(T1.IMAITM),
   TRIM( T1.IMDSC1),
    T3.COLEDG,
    T2.LIGLPT,
    T3.COUNCS/10000 AS COST,
    SUM(T2.LIPQOH)/1000 AS TTL_QTY
FROM
    PRODDTA.F4101 T1,
    PRODDTA.F41021 T2
LEFT OUTER JOIN
    (
        SELECT
            *
        FROM
            PRODDTA.F4105
        WHERE
            COLEDG = '07'
    )
    T3
ON
    T2.LIITM = T3.COITM
AND T2.LIMCU = T3.COMCU
WHERE
    T1.IMITM = T2. LIITM
AND T2.LIPQOH <>0
GROUP BY
    T2.LIMCU,
    T1.IMLITM,
    T1.IMAITM,
    T1.IMDSC1,
    T3.COLEDG,
    T2.LIGLPT,
    T3.COUNCS
HAVING
    SUM(T2.LIPQOH)<>0
ORDER BY
    T2.LIMCU,
    T1.IMLITM