SELECT DISTINCT ewar.warrant_id, ewar.wsc_code, ewar.plaintiff, ewar.date_issued, ewar.bond_amount, ewar.bnd_typ_cd_bond_type "BOND_TYPE", ewar.sys_id, ewar.issuing_agency, ac_iss.agency_desc "ISSUING_AGENCY_DESC", ewar.judge, ewar.agency_code, ac.agency_desc, ewar.state_cd_state_code "STATE_CODE", JOIN ( CURSOR ( SELECT DISTINCT REPLACE (wr.reference_type, '_', ' ') || ': ' || wr.reference_id FROM warrant_references wr WHERE WR.WARRANT_ID = EWAR.WARRANT_ID), ', '), ewar.mn_per_person_id person_id, ewar.mn_mn_id, Initcap(TRIM (mn.lname || ', ' || mn.fname || ' ' || mn.mname)) "PERSON_NAME_LFM", Initcap(TRIM ( mn.fname || ' ' || DECODE (mn.mname, NULL, mn.lname, mn.mname || ' ' || mn.lname))) "PERSON_NAME_FML", mn.dob, mn.ssn, mp.race_code, mp.sex_code, ejs_get_latest_person_phys (ewar.mn_per_person_id, ewar.date_issued) "PERSON_PHYS_ID", ejs_get_latest_person_dl (ewar.mn_per_person_id, ewar.state_cd_state_code) "PERSON_DL", JOIN (CURSOR (SELECT vw.offense_code || ' - ' || vw.offense_desc FROM warrant_offense_charge_vw vw WHERE vw.warrant_id = EWAR.WARRANT_ID), ', '), '1', 'JS Placeholder', 'JS Placeholder' AS CASE_NUMBER, '1' AS CASE_ORDER, to_char(mn.dob,'mm/dd/yyyy') as dob_txt, TRIM (mn.lname || ', ' || mn.fname || ' ' || mn.mname)||' DOB: '||to_char(mn.dob,'mm/dd/yyyy')||' SEX: '||mp.sex_code||' RACE: '||mp.race_code as PERSON_SUMMARY, WSO.SERVED_DATE FROM e_warrants ewar, master_names mn, people p, master_people mp, agency_codes ac, agency_codes ac_iss, warrant_serving_officers wso WHERE ewar.mn_mn_id = mn.mn_id AND ewar.mn_per_person_id = mn.per_person_id AND ewar.mn_per_person_id = p.person_id AND p.master_person_id = mp.master_person_id AND ac_iss.agency_code = ewar.issuing_agency AND ac.agency_code = ewar.agency_code AND ewar.warrant_id = wso.warrant_id (+)