SELECT (SELECT MIN(EVENT_TIMESTAMP) FROM EVENT_DETAIL WHERE EVENT_HEADER_ID=EH.EVENT_HEADER_ID) FIRST_SCAN, (SELECT MAX(EVENT_TIMESTAMP) FROM EVENT_DETAIL WHERE EVENT_HEADER_ID=EH.EVENT_HEADER_ID) LAST_SCAN, C.COMPANY_NO PICK_COM_ID, L.LOCATION_CODE PICK_LOC_ID, L.NAME LOCATION_DESCRIPTION, EVENT_HEADER_GT_04 PICKLIST_ID, PAR_C.COMPANY_NO PAR_COM_ID, PAR_L.LOCATION_CODE PAR_LOC_ID, (SELECT COUNT(1) FROM EVENT_DETAIL WHERE EVENT_HEADER_ID=EH.EVENT_HEADER_ID AND QUANTITY>0) LINE_ITEMS_PICKED, (SELECT SUM(QUANTITY) FROM EVENT_DETAIL WHERE EVENT_HEADER_ID=EH.EVENT_HEADER_ID AND QUANTITY IS NOT NULL) TOTAL_QTY_PICKED, USER_ID FROM EVENT_HEADER EH, LOCATION L, COMPANY C, LOCATION PAR_L, COMPANY PAR_C WHERE L.LOCATION_ID = (SELECT DISTINCT SOURCE_LOCATION_ID FROM EVENT_DETAIL WHERE EVENT_HEADER_ID = EH.EVENT_HEADER_ID) AND C.COMPANY_NO = L.COMPANY_NO AND PAR_L.LOCATION_ID = EH.EVENT_HEADER_GT_01 AND PAR_C.COMPANY_NO = PAR_L.COMPANY_NO AND EVENT_TYPE='PFP'