SELECT EJS_PERSON_PKG.GET_PERSON_SUMMARY(MN.PER_PERSON_ID,MN.MN_ID,'N','N') || ' (Arrestee)' AS DISPLAY, MN.PER_PERSON_ID AS VAL_1, MN.MN_ID AS VAL_2, NULL AS VAL_3, NULL AS VAL_4, NULL AS VAL_5, A.ARREST_ID AS KEY_VAL_1, NULL AS KEY_VAL_2, NULL AS KEY_VAL_3, NULL AS KEY_VAL_4, NULL AS KEY_VAL_5 FROM ARRESTS A INNER JOIN PEOPLE P ON A.PERSON_ID = P.PERSON_ID INNER JOIN MASTER_NAMES MN ON P.PERSON_ID = MN.PER_PERSON_ID WHERE MN.NAME_TYPE_CODE = 'P' UNION SELECT EJS_PERSON_PKG.GET_PERSON_SUMMARY(MN.PER_PERSON_ID,MN.MN_ID,'N','N') || ' (Victim)' AS DISPLAY, MN.PER_PERSON_ID AS VAL_1, MN.MN_ID AS VAL_2, NULL AS VAL_3, NULL AS VAL_4, NULL AS VAL_5, A.ARREST_ID AS KEY_VAL_1, NULL AS KEY_VAL_2, NULL AS KEY_VAL_3, NULL AS KEY_VAL_4, NULL AS KEY_VAL_5 FROM ARRESTS A INNER JOIN DOMESTIC_VIOLENCE_VICTIMS DVV ON A.ARREST_ID = DVV.ARREST_ID INNER JOIN PEOPLE P ON DVV.PERSON_ID = P.PERSON_ID INNER JOIN MASTER_NAMES MN ON P.PERSON_ID = MN.PER_PERSON_ID WHERE MN.NAME_TYPE_CODE = 'P' UNION SELECT EJS_PERSON_PKG.GET_PERSON_SUMMARY(MN.PER_PERSON_ID,MN.MN_ID,'N','N') || ' (Other)' AS DISPLAY, MN.PER_PERSON_ID AS VAL_1, MN.MN_ID AS VAL_2, NULL AS VAL_3, NULL AS VAL_4, NULL AS VAL_5, A.ARREST_ID AS KEY_VAL_1, NULL AS KEY_VAL_2, NULL AS KEY_VAL_3, NULL AS KEY_VAL_4, NULL AS KEY_VAL_5 FROM ARRESTS A INNER JOIN ARREST_PEOPLE AP ON A.ARREST_ID = AP.ARREST_ID INNER JOIN PEOPLE P ON AP.PERSON_ID = P.PERSON_ID INNER JOIN MASTER_NAMES MN ON P.PERSON_ID = MN.PER_PERSON_ID WHERE MN.NAME_TYPE_CODE = 'P' UNION SELECT EJS_PERSON_PKG.GET_PERSON_SUMMARY(MN3.PER_PERSON_ID,MN3.MN_ID,'N','N') || ' (Relation)' AS DISPLAY, MN3.PER_PERSON_ID AS VAL_1, MN3.MN_ID AS VAL_2, NULL AS VAL_3, NULL AS VAL_4, NULL AS VAL_5, A.ARREST_ID AS KEY_VAL_1, NULL AS KEY_VAL_2, NULL AS KEY_VAL_3, NULL AS KEY_VAL_4, NULL AS KEY_VAL_5 FROM ARRESTS A INNER JOIN PEOPLE P ON A.PERSON_ID = P.PERSON_ID INNER JOIN MASTER_PEOPLE MP ON P.MASTER_PERSON_ID = MP.MASTER_PERSON_ID INNER JOIN PEOPLE P2 ON MP.MASTER_PERSON_ID = P2.MASTER_PERSON_ID INNER JOIN PEOPLE_RELATIONS PR ON P2.PERSON_ID = PR.PRIMARY_PERSON_ID INNER JOIN PEOPLE P3 ON PR.RELATED_PERSON_ID = P3.PERSON_ID INNER JOIN MASTER_NAMES MN3 ON P3.PERSON_ID = MN3.PER_PERSON_ID WHERE MN3.NAME_TYPE_CODE = 'P'