CREATE OR REPLACE FORCE VIEW email_trace_v
(report_title
,sender_firstname
,sender_surname
,recipient_email_address
,transmission_date
,flight_no
,flight_date
,transmission_failure
,report_format
)
AS
SELECT r.report_title               AS    report_title           
      ,tu.firstname                 AS    sender_firstname       
      ,tu.surname                   AS    sender_surname         
      ,et.recipient_email_address   AS    recipient_email_address
      ,et.transmission_date         AS    transmission_date      
      ,et.flight_no                 AS    flight_no              
      ,et.flight_date               AS    flight_date            
      ,et.transmission_failure      AS    transmission_failure   
      ,et.report_format             AS    report_format          
  FROM email_trace et, tagtrak_users tu,reports r
 WHERE et.sender_user_id = tu.user_id(+)
   AND et.report_id = r.report_id;