oracle8.1.6 select type_id, interval_id, acs_object.name(notification_requests.object_id) as object_name from notification_requests where request_id = :request_id