Items with Cost Differences & Inventory between Branch plants

SELECT TRIM(A.COLITM) AS GLOBAL_ITEM#,
       TRIM(A.COAITM) AS LEGACY_ITEM#,
       TRIM(A.COLEDG) AS LEDG,
        A.COMCU "SOURCE BP",
       (A.COUNCS / 10000) "SOURCE COST",
        A1.IBSTKT,
        B.COMCU "COMPARED BP",
        (B.COUNCS / 10000) "COMPARED COST",
        B1.IBSTKT
         FROM PRODDTA.F4105 A, PRODDTA.F4102 A1, PRODDTA.F4105 B, PRODDTA.F4102 B1
        WHERE A.COITM = B.COITM
   AND A.COLEDG = B.COLEDG
   AND A.COITM = A1.IBITM
   AND A.COMCU = A1.IBMCU
   AND B.COITM = B1.IBITM
   AND B.COMCU = B1.IBMCU
   AND A.COLEDG = 'FY'
   AND A.COUNCS <>  B.COUNCS
   AND A.COMCU = '     3100011'
   AND B.COMCU like  '     310%'
   AND A.COUNCS <>  B.COUNCS
   AND EXISTS (SELECT *
          FROM PRODDTA.F41021
         WHERE B.COITM = LIITM
           AND B.COMCU = LIMCU
           AND LIPQOH <> 0)