SEARCH_PROJECT_VIEW

  Tables Used  

SQL*Server Create Statement:

CREATE VIEW search_project_view AS
SELECT project.project_key, customer.customer_code, project.project_code,
       project.manager_key, person.last_name, person.first_name,
       project.project_type_key, project_type.project_type,
       project.project_status_key, project_status.status
FROM   project, person, customer, project_type, project_status
WHERE  project.customer_key = customer.customer_key and
       project.manager_key *= person.person_key and
       project.project_type_key *= project_type.project_type_key and
       project.project_status_key *= project_status.project_status_key