SELECT TRAYSET.TRAY_NO, ASSEMBLY.TS_NO, TRAY_LIST.TL_NO, TRAY_LIST.DESCR AS TL_DESCR, TRAYSET.CREAT_DT, ASSEMBLY.ASM_TIME AS ASSM_DT, TRAYSET.TOTAL, TRAYSET.STATUS, ASSEMBLY.ACTIVITY, ASSEMBLY.USER_ID, ASSEMBLY.ASM_LOC_NO, NVL(( SELECT COUNT(EX_NO) FROM TS_ITEM_EXCEPTION WHERE TS_ID = TRAYSET.TS_ID ), 0) AS NO_EXP FROM TRAYSET, ASSEMBLY, TRAY_LIST WHERE TRAYSET.TS_NO = ASSEMBLY.TS_NO AND TRAYSET.TL_ID = TRAY_LIST.TL_ID AND ASSEMBLY.ACTIVITY IN (6,11) AND ASSEMBLY.ASM_ID = ( SELECT MIN(A2.ASM_ID) FROM ASSEMBLY A2 WHERE A2.TS_NO = ASSEMBLY.TS_NO AND A2.ACTIVITY = ASSEMBLY.ACTIVITY )