VENDOR_ASSIGNED_VIEW |
||
| Column Name | Data Type | Nulls |
|---|---|---|
| vendor_key | decimal (15,0) | |
| name | varchar (255) | |
| prefered | varchar (1) | YES |
| expense_type_key | decimal (15,0) | |
Tables Used |
| VENDOR |
| BILLING_INFO |
| EXPENSE_TYPE_VENDOR_ASSIGNMENT |
SQL*Server Create Statement: |
CREATE VIEW vendor_assigned_view AS select v.vendor_key, v.name, v.prefered, etva.expense_type_key from vendor v, expense_type_vendor_assignment etva, billing_info bi where v.vendor_key = bi.vendor_key AND v.vendor_key = etva.vendor_key |