Missing records in F5541052

SELECT ib.ibitm, ib.iblitm, ib.ibaitm, ib.ibmcu, ib.ibstkt, c2.*
  FROM proddta.f4102 ib, proddta.f554105 c2
 WHERE ib.ibitm = c2.c2itm
   AND ib.ibmcu = c2.c2mcu
   AND NOT EXISTS (
          SELECT *
            FROM proddta.f5541052 mi
           WHERE c2.c2itm = mi.miitm
             AND c2.c2mcu = mi.mimmcu
             AND c2.c2ctry = mi.mictry
             AND c2.c2fy = mi.mify
             AND c2.c2pn = mi.mipn
             AND c2.c2ledg = mi.miledg)



/* Formatted on 2012/03/15 15:13 (Formatter Plus v4.8.8) */
SELECT ib.ibitm, ib.iblitm, ib.ibaitm, ib.ibmcu, ib.ibstkt, c2.c2ctry,
       c2.c2fy, c2.c2pn, c2.c2ledg, c2.c2uncs / 10000, c2.c2pid, c2.c2user,
       c2.c2upmj, c2.c2tday, mi.misoqs / 1000, mi.miuncs / 10000,
       mi.mi$55tmls / 10000, mi.mi$55tlwc / 10000, mi.mi$55tmwc / 10000,
       mi.mi$55tlbw / 10000, mi.mi$55tmbw / 10000, mi.micmqt / 1000,
       mi.miarec / 100, mi.mistdc / 10000
  FROM proddta.f4102 ib, proddta.f554105 c2, proddta.f5541052 mi
 WHERE ib.ibitm = c2.c2itm
   AND ib.ibmcu = c2.c2mcu
   AND c2.c2itm = mi.miitm(+)
   AND c2.c2mcu = mi.mimmcu(+)
   AND c2.c2ctry = mi.mictry(+)
   AND c2.c2fy = mi.mify(+)
   AND c2.c2pn = mi.mipn(+)
   AND c2.c2ledg = mi.miledg(+)
   AND c2.c2ledg = '02'
   AND EXISTS (
          SELECT *
            FROM proddta.f4111 il
           WHERE il.ildct = 'IC' AND ib.ibitm = il.ilitm
                 AND ib.ibmcu = il.ilmcu)