Inventory Valuation between Ledger Types (ITM/MCU)

--WITH  COSTING TAG TABLE--

SELECT T1.LIITM,
       T2.IBLITM,
       T2.IBAITM,
       T1.LIMCU,
       SUM(T1.LIPQOH) / 1000 "ON HAND QTY",
       T4.COUNCS / 10000 "FY STD COST",
       (SUM(T1.LIPQOH) / 1000) * (T4.COUNCS / 10000) "FY INV VALUE",
       T5.COUNCS / 10000 "07 STD COST",
       (SUM(T1.LIPQOH) / 1000) * (T5.COUNCS / 10000) "07 INV VALUE",
       ((SUM(T1.LIPQOH) / 1000) * (T4.COUNCS / 10000)) -
       ((SUM(T1.LIPQOH) / 1000) * (T5.COUNCS / 10000)) "DIFF IN VALUATION"
  FROM PRODDTA.F41021  T1,
       PRODDTA.F4101   T3,
       PRODDTA.F4102   T2,
       PRODDTA.F4105   T5,
       PRODDTA.F550011 T6,
       PRODDTA.F4105   T4
 WHERE T1.LIPQOH <> 0
   AND T3.IMITM = T1.LIITM
   AND T2.IBITM = T1.LIITM
   AND T2.IBMCU = T1.LIMCU
   AND T4.COITM(+) = T1.LIITM
   AND T4.COMCU(+) = T1.LIMCU
   AND T4.COLEDG(+) = 'FY'
   AND T5.COITM = T1.LIITM
   AND T5.COMCU = T1.LIMCU
   AND T5.COLEDG = '07'
   AND T6.CTITM = T1.LIITM
   AND T6.CTMCU = T1.LIMCU
   AND T6.CTFCFLAG = '7'
 GROUP BY T1.LIITM,
          T2.IBLITM,
          T2.IBAITM,
          T1.LIMCU,
          T4.COUNCS,
          T5.COUNCS
 ORDER BY T1.LIITM, T1.LIMCU