SELECT agreement_id, data_source_type_cd, EVENT.RC, event.CHANNEL, event.SUB_CHANNEL, event.EVENT_START_DTTM, event.EVENT_SUBTYPE_CD, event.EVENT_ACTIVITY_TYPE_CD, event.EVENT_DESC, event.EMPLOYEEID FROM agreement_event JOIN event ON EVENT.EVENT_ID = AGREEMENT_EVENT.EVENT_ID WHERE EVENT_ACTIVITY_TYPE_CD = 'UPDATE_ADDRESS_PHONE_NUMBER'