SELECT CASECART.CASECART_NO, CASECART_ASSEMBLY_LOG.ASSM_DATE, CASECART_ASSEMBLY_LOG.ACTIVITY, COMPANY.COMPANY_NO, COMPANY.DESCRIPTION, LOCATION.LOCATION_ID, LOCATION.LOCATION_CODE, LOCATION.NAME, USERS.LAST_NAME, USERS.FIRST_NAME, DECODE(CASECART_ASSEMBLY_LOG.ACTIVITY , -1, 'NEW', 0, 'STARTDECONTAM', 1, 'SCANADDCASECART', 2, 'SCANADDTRAY', 3, 'SCANREMOVETRAY', 4, 'SCANCLEARCASECART', 5, 'ENDDECONTAM', 6, 'STARTPICKING', 7, 'ENDPICKING', 8, 'TRANSFER', NULL) CASECART_ASSEMBLY_ACTIVITY, ( SELECT MIN(PICKLIST_NO) FROM PICK WHERE PICK.CARTSET_ASSM_NO = CASECART_ASSEMBLY.CARTSET_ASSM_NO) PICK_LIST_NO FROM CASECART, CASECART_ASSEMBLY, CASECART_ASSEMBLY_LOG, USERS, LOCATION, COMPANY WHERE CASECART.CASECART_NO = CASECART_ASSEMBLY.CASECART_NO AND CASECART_ASSEMBLY.CARTSET_ASSM_NO = CASECART_ASSEMBLY_LOG.CARTSET_ASSM_NO AND CASECART_ASSEMBLY_LOG.ACTIVITY IN (0,6,8) AND CASECART_ASSEMBLY_LOG.USER_ID = USERS.USER_ID AND CASECART_ASSEMBLY_LOG.LOC_NO = LOCATION.LOCATION_ID AND LOCATION.COMPANY_NO = COMPANY.COMPANY_NO