SELECT TL.DESCR AS TL_DESCR, TS.TRAY_NO, TL.SOURCE_LOCATION_NO, LOCATION.NAME AS SOURCE_LOCATION_NAME, COMPANY.COMPANY_NO AS SOURCE_COMPANY_NO, COMPANY.DESCRIPTION AS SOURCE_COMPANY_NAME, TS.COMMENTS, TS.TS_ID, TS.MOD_DT AS ON_HOLD_DT, USERS.FIRST_NAME, USERS.LAST_NAME, NVL((SELECT SUM(TS_EXP.QTY) FROM TS_ITEM_EXCEPTION TS_EXP WHERE TS_EXP.EX_NO IN ( '1002','1003','1004') AND TS_EXP.TS_ID = TS.TS_ID), 0) AS QTY_DAMAGED, NVL(( SELECT SUM(TS_EXP.QTY) FROM TS_ITEM_EXCEPTION TS_EXP WHERE TS_EXP.EX_NO IN ('1005','1006','1007') AND TS_EXP.TS_ID = TS.TS_ID ), 0) AS QTY_MISSING FROM TRAYSET_CURRENT_VW TS, TRAY_LIST TL, USERS, LOCATION, COMPANY WHERE TS.TL_ID = TL.TL_ID AND TS.USER_ID = USERS.USER_ID AND TL.SOURCE_LOCATION_NO = LOCATION.LOCATION_ID AND COMPANY.COMPANY_NO = LOCATION.COMPANY_NO AND TS.HOLD_IND = 'Y'