PROJECT_ASSIGNMENT_VIEW

  Tables Used  

SQL*Server Create Statement:

CREATE VIEW project_assignment_view AS
SELECT person.person_key,
       project.project_key,
       customer.customer_key,
       project.project_code,
       customer.customer_code,
       project.expense_assignment_flag,
       project.er_task_required,
       project.ts_task_required
FROM   person, project, customer, project_status
WHERE  customer.customer_key = project.customer_key
   AND project_status.project_status_key = project.project_status_key
   AND project_status.open_status = 'Y'
   AND (exists (SELECT *
                FROM   project_assignment
                WHERE  project_assignment.person_key = person.person_key
                  AND  project_assignment.project_key = project.project_key) OR
        exists (SELECT *
             FROM   person p, customer_assignment
                WHERE  p.person_key = person.person_key
                   AND customer_assignment.customer_key = person.customer_key
                   AND customer_assignment.project_key = project.project_key))