SELECT LOAD_STER.LOAD_ID, LOAD_STER.CREATED_DATE, LOAD_STER.END_DATE, LOAD_STER.CYCLE_NO, LOAD_STER.STERILIZER_EQ_NO, STERILIZER_EQUIPMENT.STER_NO, TRAYSET.ASSM_LOC_NO AS STER_LOCATION, STER_LOCATION.LOCATION_CODE AS STER_LOCATION_CODE, STER_LOCATION.NAME AS STER_LOCATION_NAME, STER_COMPANY.DESCRIPTION AS FACILITY_NAME, STER_COMPANY.COMPANY_NO AS FACILITY_NO, STERILIZATION_TYPE.NAME AS TYPE_NAME, LOAD_STER.COMMENTS, LOAD_CONTENT.ASID AS LOAD_ASID, TRAYSET.TRAY_NO, TRAY_LIST.DESCR, USERS.NAME AS USER_NAME, USERS.USER_ID, PROCESS.NAME AS PROCESS_NAME, STERILIZER_EQUIPMENT.NAME AS STER_NAME, TRAY_LIST.SOURCE_LOCATION_NO AS TRAY_LOCATION_NO, LOCATION.NAME TRAY_LOCATION_NAME, COMPANY.DESCRIPTION AS TRAY_FACILITY_NAME, COMPANY.COMPANY_NO AS TRAY_FACILITY_NO, ( SELECT DISTINCT 'Yes' FROM ASSEMBLY WHERE ASSEMBLY.TS_NO = TRAYSET.TS_NO AND ASSEMBLY.ACTIVITY IN (12,11,3) AND ASSEMBLY.ASM_TIME > LOAD_CONTENT.ADDED_DATE ) AS "IS_TRAY_USED_AGAIN", ( SELECT MIN(ASSEMBLY.ASM_TIME) FROM ASSEMBLY WHERE ASSEMBLY.TS_NO=TRAYSET.TS_NO AND ASSEMBLY.ACTIVITY IN (12,11,3) AND ASSEMBLY.ASM_TIME>LOAD_CONTENT.ADDED_DATE ) AS USED_AGAIN_TIME, ( SELECT DISTINCT 'Yes' FROM LOAD_CONTENT LC2 WHERE LC2.ASID = LOAD_CONTENT.ASID AND LC2.DB_ID > LOAD_CONTENT.DB_ID )AS "IS_TRAY_STER_AGAIN", ( SELECT MIN(LC2.ADDED_DATE) FROM LOAD_CONTENT LC2 WHERE LC2.ASID = LOAD_CONTENT.ASID AND LC2.DB_ID > LOAD_CONTENT.DB_ID ) AS "STER_AGAIN_DATE" FROM LOAD_STER, USERS, PROCESS, STERILIZER_EQUIPMENT, LOAD_CONTENT, LOCATION, COMPANY, STERILIZATION_TYPE, TRAYSET, TRAY_LIST, LOCATION STER_LOCATION, COMPANY STER_COMPANY WHERE LOAD_STER.CREATED_BY = USERS.USER_ID AND LOAD_STER.PROC_NO = PROCESS.PROCESS_NO AND LOAD_STER.STERILIZER_EQ_NO = STERILIZER_EQUIPMENT.STERILIZER_EQ_NO AND LOAD_CONTENT.LOAD_ID = LOAD_STER.LOAD_ID AND LOCATION.LOCATION_ID = TRAY_LIST.SOURCE_LOCATION_NO AND COMPANY.COMPANY_NO = LOCATION.COMPANY_NO AND STERILIZATION_TYPE.STER_NO = STERILIZER_EQUIPMENT.STER_NO AND TRAYSET.TS_NO = LOAD_CONTENT.ASID AND TRAYSET.TL_ID = TRAY_LIST.TL_ID AND STER_LOCATION.LOCATION_ID = TRAYSET.ASSM_LOC_NO AND STER_COMPANY.COMPANY_NO = STER_LOCATION.COMPANY_NO