select distinct serial_number,
to_char(first_fire_date,'mm-dd-yyyy') first_fire_date,
cis.installation_engineer,
cis.technology,
customer_name,
CCS.site_nm,
email_id
from CTSV_INSTALL_SCHEDULE    cis,
CTSV_RFR_RED_FLAG_REVIEW crrfr,
ctst_customer_site       ccs,
prty                     p
where CRRFR.UNIT_NUMBER =
DECODE(CIS.SERIAL_NUMBER,
'NON-US',
CIS.ALTERNATE_SERIAL_NUMBER,
CIS.SERIAL_NUMBER)
AND FIRST_FIRE_STATUS <> 'RELEASE'
and first_fire_date between sysdate and sysdate + 14
and ccs.unit_number_id = cis.unit_number
and DECODE(p.lst_nm, NULL, p.frst_nm, p.lst_nm || ', ' || p.frst_nm) =
cis.installation_engineer
order by serial_number;