oracle8.1.6 select request_id, type_id, (select pretty_name from notification_types where notification_types.type_id = notification_requests.type_id) as type, acs_object.name(notification_requests.object_id) as object_name, (select name from notification_intervals where notification_intervals.interval_id = notification_requests.interval_id) as interval, object_id from notification_requests where user_id = :user_id