EXPENSE_PROJECT_VIEW |
||
| Column Name | Data Type | Nulls |
|---|---|---|
| expense_report_key | decimal (15,0) | |
| allocation | decimal (18,0) | YES |
| sequence | int | |
| expense_project_allocation_key | decimal (15,0) | |
| project_code | varchar (30) | |
| task_name | varchar (50) | YES |
Tables Used |
| TASK |
| EXPENSE_PROJECT_ALLOCATION |
| PROJECT |
SQL*Server Create Statement: |
CREATE VIEW expense_project_view AS
select epa.expense_report_key,
epa.allocation,
epa.sequence,
epa.expense_project_allocation_key,
p.project_code,
t.task_name
FROM expense_project_allocation epa, project p, task t
WHERE p.project_key = epa.project_key AND t.task_key =* epa.task_key
|