EXPENSE_DATA_VIEW

  Tables Used  

SQL*Server Create Statement:

CREATE VIEW expense_data_view AS
SELECT ed.expense_data_key,
       ed.expense_report_key,
       et.expense_type,
       c.currency_code,
       pm.payment_method_code,
       ed.expense_date,
       ed.expense_project_allocation_key,
       ed.comments,
       ed.amount,
       ed.summary,
       ed.sequence,
       ed.vendor_name,
       c.exchange_rate
from   expense_data ed,
       expense_type et,
       currency c,
       payment_method pm
where  et.expense_type_key = ed.expense_type_key AND
       c.currency_key = ed.currency_key AND
       pm.payment_method_key = ed.payment_method_key