would you mind to post here what are the different things that you have tried ?
Here is some of the SQL I have done to try to get this to work.
SELECT e.EMPLOYEE_NAME, count(w.pallet_no) FROM pca_wms_fg w, kr_employee_v e
WHERE trunc (w.modified_date) >= TO_DATE('10/18/2009','mm/dd/yyyy')
AND trunc (w.modified_date) <= TO_DATE('10/21/2009','mm/dd/yyyy')
AND w.MODIFIED_BY = e.BADGENUM
GROUP BY e.employee_name
-----------------
SELECT e.EMPLOYEE_NAME, e.badgenum, count(w.pallet_no), sum(QTY)
FROM pca_wms_fg w, kr_employee_v e
WHERE trunc (w.modified_date) >= TO_DATE('10/18/2009','mm/dd/yyyy')
AND trunc (w.modified_date) <= TO_DATE('10/23/2009','mm/dd/yyyy')
AND w.MODIFIED_BY = e.BADGENUM
GROUP BY e.employee_name, e.badgenum
-------------
SELECT employee_name, NbrPallets, CartonQty, OrderQty FROM (
SELECT employee_name, count(pallet_no) NbrPallets, sum(QTY)CartonQty, sum(qty) OrderQty FROM (
SELECT EMPLOYEE_NAME, w.pallet_no, w.QTY, 0
FROM pca_wms_fg w, kr_employee_v e
WHERE trunc (w.modified_date) >= TO_DATE('10/18/2009','mm/dd/yyyy')
AND trunc (w.modified_date) <= TO_DATE('10/23/2009','mm/dd/yyyy')
AND w.MODIFIED_BY = e.BADGENUM
GROUP BY e.employee_name
UNION all
SELECT employee_name, '', 0, w.qty
FROM pca_wms_fg w JOIN kr_employee_v e
on w.modified_by = e.badgenum
WHERE w.location_to LIKE ('6%')
AND trunc (w.modified_date) >= TO_DATE('10/18/2009','mm/dd/yyyy')
AND trunc (w.modified_date) <= TO_DATE('10/23/2009','mm/dd/yyyy')
)
GROUP BY employee_name, w.pallet_no
)
------------
SELECT pallet_no, decode(Qty1,0,Qty2,Qty1) QTY FROM (
SELECT pallet_no, sum(QTY) Qty1, sum(LOCT_ONHAND)Qty2 FROM (
SELECT pallet_no, QTY, 0 LOCT_ONHAND FROM pca_wms_fg
UNION all
SELECT SUBLOT_NO pallet_no , 0, LOCT_ONHAND FROM XXPCA_INVENTORY_V@tLK
)
GROUP BY pallet_no
)
Thanks.
Unsolved 
