CREATE VIEW export_expense_view AS
SELECT er.expense_report_key, er.owner_key, er.status, er.purpose, er.location,
er.date_completed, p.first_name, p.last_name, p.middle_initial,
er.amount report_total, et.expense_type, et.account_number, c.currency_code,
pm.payment_method_code, ed.expense_date, prj.project_code,
t.task_name, ed.vendor_name, eda.amount, eda.project_key, eda.task_key,
ed.summary, ed.comments, ptype.project_type, ed.billable, eda.expense_currency
FROM expense_report er, expense_data ed, expense_data_allocation eda, person p,
expense_type et, currency c, payment_method pm, project prj, task t, project_type ptype
WHERE er.expense_report_key = ed.expense_report_key
AND ed.expense_data_key = eda.expense_data_key
AND er.owner_key = p.person_key
AND ed.expense_type_key = et.expense_type_key
AND ed.currency_key= c.currency_key
AND ed.payment_method_key = pm.payment_method_key
AND ed.project_type_key = ptype.project_type_key
AND eda.project_key *= prj.project_key
AND eda.task_key *= t.task_key
|