oracle8.1.6 select name, description, nvl(acs_object.name(default_assignee), 'N/A') as assignee_name from ttracker_categories where category_id = :category_id select ttracker_option.option_name(:package_id, 'severity', tt.severity) as pretty_severity, ttracker_option.option_name(:package_id, 'priority', tt.priority) as pretty_priority, tt.ticket_id, tt.subject, to_char(tt.creation_date, 'MM/DD/YYYY HH24:MI') as created, c.state, tt.creation_user as creator_id, acs_object.name(tt.creation_user) as creator_name from wf_cases c, ttracker_tickets tt where tt.category_id = :category_id and c.object_id = tt.ticket_id [ad_dimensional_sql $dimensional] [ad_order_by_from_sort_spec $orderby $table_def] tt.creation_date + 1 > sysdate tt.creation_date + 7 > sysdate tt.creation_date + 30 > sysdate