select * from
(
SELECT 'IMPORTS','FULL',DECODE (a.packagetypecode, 'CNT12', '20', 'CNT6', '40'), nvl(B.Cnt,0),
DECODE (a.packagetypecode, 'CNT6', nvl(B.Cnt,0) *2, 'CNT12', nvl(B.Cnt,0)) T 
FROM (
    SELECT DISTINCT packagetypecode
    FROM suppackagetypes
    where packagetypecode in ('CNT12','CNT6')
) A
LEFT JOIN (
    SELECT mi.packagetypecode, COUNT(mi.PACKAGETYPECODE) AS Cnt
    FROM contdba.manifestitems mi, contdba.manifestsequences ms
    WHERE mi.booknumber in (SELECT booknumber
  FROM books b
 WHERE BOOKTYPE = 'M' 
 AND b.arrivalnumber IN (
          SELECT va.arrivalnumber
            FROM supvessels sv, vesselarrivals va
           WHERE sv.vesselnumber = va.vesselnumber
             AND sv.shippingline =
                    DECODE (:p_shippingline,
                            'ALL', sv.shippingline,
                            :p_shippingline
                           )))

and mi.empty = 'N'
      and mi.BOOKNUMBER = ms.booknumber
      and ms.TRANSHIPMENT = 'N' 
    GROUP BY mi.packagetypecode
) B
ON A.packagetypecode = B.packagetypecode
UNION
SELECT 'IMPORTS','EMPTY',DECODE (a.packagetypecode, 'CNT12', '20', 'CNT6', '40'), nvl(B.Cnt,0),
DECODE (a.packagetypecode, 'CNT6', nvl(B.Cnt,0) *2, 'CNT12', nvl(B.Cnt,0)) T 
FROM (
    SELECT DISTINCT packagetypecode
    FROM suppackagetypes
    where packagetypecode in ('CNT12','CNT6')
) A
LEFT JOIN (
    SELECT mi.packagetypecode, COUNT(mi.PACKAGETYPECODE) AS Cnt
    FROM contdba.manifestitems mi, contdba.manifestsequences ms
    WHERE mi.booknumber in (SELECT booknumber
  FROM books b
 WHERE BOOKTYPE = 'M' 
 AND b.arrivalnumber IN (
          SELECT va.arrivalnumber
            FROM supvessels sv, vesselarrivals va
           WHERE sv.vesselnumber = va.vesselnumber
             AND sv.shippingline =
                    DECODE (:p_shippingline,
                            'ALL', sv.shippingline,
                            :p_shippingline
                           )))

and mi.empty = 'Y'
      and mi.BOOKNUMBER = ms.booknumber
      and ms.TRANSHIPMENT = 'N' 
    GROUP BY mi.packagetypecode
) B
ON A.packagetypecode = B.packagetypecode
)