SELECT DISTINCT PICK_LOC.COMPANY_NO AS PICK_COMPANY_NO, PICK.PICKLIST_NO, LOAD_CONTENT.LOAD_ID, LOAD_STER.CYCLE_NO AS LOAD_CYCLE_NO, LOAD_STER.CREATED_DATE AS LOAD_CREAT_DT FROM CASECART_ITEMS, ASSEMBLY, LOAD_CONTENT, LOCATION PICK_LOC, PICK, LOAD_STER WHERE CASECART_ITEMS.ASM_ID = ASSEMBLY.ASM_ID AND ASSEMBLY.TS_NO = LOAD_CONTENT.ASID AND ASSEMBLY.ASM_LOC_NO = PICK_LOC.LOCATION_ID AND ASSEMBLY.ASM_LOC_NO = PICK.PICK_LOC_NO AND PICK.CARTSET_ASSM_NO = CASECART_ITEMS.CARTSET_ASSM_NO AND LOAD_CONTENT.LOAD_ID = LOAD_STER.LOAD_ID AND ASSEMBLY.ACTIVITY = 12