SELECT 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", ewar.mn_per_person_id person_id, ewar.mn_mn_id, TRIM (mn.lname || ', ' || mn.fname || ' ' || mn.mname) "PERSON_NAME_LFM", TRIM(mn.fname || ' ' || DECODE (mn.mname, NULL, mn.lname, mn.mname || ' ' || mn.lname)) "PERSON_NAME_FML", mn.dob, mn.ssn, 'CHARGES', wc.cha_code, cc.cha_desc, wc.creator_date FROM e_warrants ewar, master_names mn, agency_codes ac, agency_codes ac_iss, warrant_charges wc, charge_codes cc WHERE ewar.mn_mn_id = mn.mn_id AND ewar.mn_per_person_id = mn.per_person_id AND ac_iss.agency_code = ewar.issuing_agency AND ac.agency_code = ewar.agency_code AND ewar.warrant_id = wc.ewar_warrant_id AND wc.cha_code = cc.cha_desc UNION SELECT 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", ewar.mn_per_person_id person_id, ewar.mn_mn_id, TRIM (mn.lname || ', ' || mn.fname || ' ' || mn.mname) "PERSON_NAME_LFM", TRIM(mn.fname || ' ' || DECODE (mn.mname, NULL, mn.lname, mn.mname || ' ' || mn.lname)) "PERSON_NAME_FML", mn.dob, mn.ssn, 'FREETEXT_CHARGES', TO_CHAR (wfc.freetext_charge_id), wfc.warrant_charge, wfc.creator_date FROM e_warrants ewar, master_names mn, agency_codes ac, agency_codes ac_iss, warrant_freetext_charges wfc WHERE ewar.mn_mn_id = mn.mn_id AND ewar.mn_per_person_id = mn.per_person_id AND ac_iss.agency_code = ewar.issuing_agency AND ac.agency_code = ewar.agency_code AND ewar.warrant_id = wfc.warrant_id UNION SELECT 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", ewar.mn_per_person_id person_id, ewar.mn_mn_id, TRIM (mn.lname || ', ' || mn.fname || ' ' || mn.mname) "PERSON_NAME_LFM", TRIM(mn.fname || ' ' || DECODE (mn.mname, NULL, mn.lname, mn.mname || ' ' || mn.lname)) "PERSON_NAME_FML", mn.dob, mn.ssn, 'ARREST_CHARGES', wac.arrest_charge_code, ar_cc.arrest_cha_desc, ar_cc.creator_date FROM e_warrants ewar, master_names mn, agency_codes ac, agency_codes ac_iss, warrant_arrest_charges wac, arrest_charge_codes ar_cc WHERE ewar.mn_mn_id = mn.mn_id AND ewar.mn_per_person_id = mn.per_person_id AND ac_iss.agency_code = ewar.issuing_agency AND ac.agency_code = ewar.agency_code AND ewar.warrant_id = wac.warrant_id AND wac.arrest_charge_code = ar_cc.arrest_charge_code