SELECT PART_NO, PROD_VERSION, TO_CHAR(ORIGINAL_START_DATE, 'MM-DD-YYYY HH:MI:SS AM'), DECODE(OWNER, 'PRODUCTION_1', 'PRODUCTION_2', 'PRODUCTION_3', 'PRODUCTION_4', 'PRODUCTION_5', 'PRODUCTION_6', OWNER) LOTTEST