Revaluation based on weighted avg cost vs actual cost

SELECT il.ilukid, il.ilitm "ITEM", il.illitm "GBL_ITM", il.ilaitm "REG_ITM",
       il.ilmcu "B/P", il.illocn "LOCN", il.illotn "LOTN", il.ildoc "DOC",
       il.ildct "DOC_TYP", il.ildgl "GL_DATE", il.ilglpt "GL_CLASS",
       il.ildoco "ORD_NO", il.ildcto "ORD_TYP", il.iltrqt / 1000 "QTY",
       il.ilpaid / 100 "EXT_AMT", c2.c2uncs / 10000 "WT_AVG_CST",
       ROUND ((il.iltrqt / 1000) * (c2.c2uncs / 10000), 2) "EXT_AMT_WT_AVG",
       ROUND (((il.iltrqt / 1000) * (c2.c2uncs / 10000)) - (il.ilpaid / 100),2) "ADJ_WT_AVG",
       (mi.miuncs + mi.mistdc) / 10000 "AC_AVG_CST",
       ROUND ((il.iltrqt / 1000) * ((mi.miuncs + mi.mistdc) / 10000),2) "EXT_AMT_AC_AVG",
       ROUND (  ((il.iltrqt / 1000) * ((mi.miuncs + mi.mistdc) / 10000))- (il.ilpaid / 100),2) "ADJ_AC_AVG"
  FROM proddta.f4111 il, proddta.f554105 c2, proddta.f5541052 mi
 WHERE il.ilmcu = c2.c2mcu
   AND il.ilitm = c2.c2itm
   AND c2.c2mcu = mi.mimmcu(+)
   AND c2.c2itm = mi.miitm(+)
   AND c2.c2fy = mi.mify(+)
   AND c2.c2pn = mi.mipn(+)
   AND c2.c2ledg = mi.miledg(+)
   AND c2.c2ctry = mi.mictry(+)
   AND c2.c2fy = 12                                             -- Fiscal Year
   AND c2.c2pn = 1                                                   -- Period
   AND c2.c2ledg = '02'
   AND c2.c2ctry = 20
   AND il.ildct IN ('IM', 'IC')
   AND il.ildgl >= 112001
   AND il.ildgl <= 112031
   AND il.iltrqt <> 0
--ORDER BY il.ilitm, il.ilmcu

-- To Check the Adj Amount created in the Cardex -- select * from proddta.F554113 where raukid =  "ILUKID""