oracle8.1.6 select j.subject, j.text_header, j.text_body, j.text_footer, j.html_header, j.html_body, j.html_footer, j.mails_sent, j.mails_bounced, j.state, j.track_links_p, p.first_names || ' ' || p.last_name as user_name, to_char(j.execution_date, 'YYYY-MM-DD HH24:MI') as execution_date, r.title as css_filename, r.content_length as css_file_length, j.sender_email, c.name as class_name, j.template_p, j.mime_type, j.selection_id, j.list_id from ml_mail_jobs j, ml_mail_classes c, acs_objects o, persons p, cr_revisions r where j.mail_job_id = :mail_job_id and c.mail_class_id = j.mail_class_id and o.object_id = j.mail_job_id and p.person_id = o.creation_user and r.revision_id (+) = j.css_revision_id