select DISTINCT 'AT' HEADER, null ACTION, null LABEL, arr.updator_date UPDATE_DATE, to_char(arr.updator_date, 'HH24MI') UPDATE_TIME, ac.ori_number AGENCY, ac.ori_number ARRESTING_AGENCY_ORI, ac.agency_desc ARRESTING_AGENCY_NAME, null CASE_NUMBER, null CASE_AGENCY_ORI, arr.arrest_id ARREST_NUMBER, null FILLER, at.arrest_type_code ARREST_TYPE, to_char(at.arrest_date, 'MM/DD/YYYY HH24MI') ARREST_DATE_TIME, arr.arr_comment ARREST_DESCRIPTION, iadd.inc_addr_comment ARREST_LOCATION, addr.longitude GPS_LONGITUDE, addr.latitude GPS_LATITUDE, ac2.ori_number INCIDENT_AGENCY_ORI, ac2.agency_desc INCIDENT_AGENCY_NAME, inc.inc_report_number INCIDENT_NUMBER, arr.arrest_id ARREST_SYSTEM_NUMBER, inc.incident_id INCIDENT_SYSTEM_NUMBER, null CASE_AGENCY_NAME, null CASE_AGENCY_STATE, ac.agency_state ARRESTING_AGENCY_STATE, substrb(ejs_addresses.full_street_summary(addr.address_id),1,50) ARREST_ADDRESS, addr.city ARREST_ADDRESS_CITY, addr.state_cd_state_code ARREST_ADDRESS_STATE, substrb(addr.zip5 || '-' || addr.zip4,1,12) ARREST_ADDRESS_ZIP from arrests arr, arrest_officers ao, officers off, agency_codes ac, arrest_types at, incident_arrests iarr, incident_addresses iadd, addresses addr, incidents inc, agency_codes ac2, incident_supplements isup where ao.arrest_id = arr.arrest_id and ao.role_code = 'X' and off.officer_id = ao.officer_id and ac.agency_code = off.agncy_cd_agency_code and at.arrest_id = arr.arrest_id and iarr.arr_arrest_id = arr.arrest_id and iadd.incident_id = iarr.incsup_inc_incident_id and addr.address_id = iadd.address_id and isup.inc_incident_id = iarr.incsup_inc_incident_id and isup.supp_seq = iarr.incsup_supp_seq and inc.incident_id=isup.inc_incident_id and isup.isc_status_code='A' and ac2.agency_code = inc.agncy_cd_agency_code