SELECT PICKLIST.PICKLIST_NO, PICKLIST.USER_ID, USERS.FIRST_NAME, USERS.LAST_NAME, PICKLIST.CREAT_DT, PICK.CARTSET_ASSM_NO , PICK.PATIENT_ID, CASECART_ASSEMBLY.CASECART_NO, PICK.PICKTIME, CASECART_ITEMS.TS_NO AS ASID, DECODE(TRAYSET.TS_TYPE, 2, NULL, TRAYSET.TRAY_NO) AS TRAY_NO, TRAY_LIST.TL_NO, TRAY_LIST.DESCR AS TRAYLIST_NAME, LOCATION.LOCATION_CODE AS PICK_LOC_NO, LOCATION.LOCATION_ID AS PICK_LOCATION_ID, LOCATION.NAME AS PICK_LOCATION, COMPANY.DESCRIPTION AS FACILITY, COMPANY.COMPANY_NO AS FACILITY_NO, CASECART_ITEMS.ACT_DATE FROM PICKLIST, PICK, CASECART_ASSEMBLY, CASECART_ITEMS, LOCATION, COMPANY, TRAY_LIST, TRAYSET, USERS WHERE PICK.PICKLIST_NO = PICKLIST.PICKLIST_NO AND PICK.CARTSET_ASSM_NO = CASECART_ASSEMBLY.CARTSET_ASSM_NO AND PICK.CARTSET_ASSM_NO = CASECART_ITEMS.CARTSET_ASSM_NO AND PICK.PICK_LOC_NO = CASECART_ITEMS.ACTIVITY_LOC_NO AND PICK.PICK_LOC_NO = LOCATION.LOCATION_ID AND LOCATION.COMPANY_NO = COMPANY.COMPANY_NO AND TRAYSET.TS_NO = CASECART_ITEMS.TS_NO AND TRAY_LIST.TL_ID = TRAYSET.TL_ID AND USERS.USER_ID = PICKLIST.USER_ID AND TRAYSET.TS_NO = CASECART_ITEMS.TS_NO