	ALL_SITES

Item Location

ALL_SITES

Columns

Name
EMP_FNAME
EMP_LNAME
ID
MANAGER_ID
NAME

Source Code

CREATE VIEW ALL_Sites (Id, NAME, Manager_Id, emp_fname, emp_lname)
	AS SELECT 
			S.ID,
      S.NAME,

      S.Manager_Id,
      E.emp_fname,
      E.emp_lname 
      
		FROM
			Site S
    INNER JOIN Employee  e ON E.EMP_ID = S.Manager_Id

References
The items listed in the matrix below are called / used by the View “ALL_SITES”

Name	Types	Description
DERIVEDTABLE	Table	Table
<DEFAULT SCHEMA>.EMPLOYEE	Table	Table
<DEFAULT SCHEMA>.SITE	Table	Table
<DEFAULT SCHEMA>.EMPLOYEE.EMP_FNAME	Column	Column
<DEFAULT SCHEMA>.EMPLOYEE.EMP_LNAME	Column	Column
<DEFAULT SCHEMA>.SITE.NAME	Column	Column
<DEFAULT SCHEMA>.EMPLOYEE.EMP_ID	Primary Key	Column
<DEFAULT SCHEMA>.SITE.ID	Primary Key	Column
<DEFAULT SCHEMA>.SITE.MANAGER_ID	Foreign Key	Column

Impact Analysis
The items listed in the matrix below are using / calling the View “ALL_SITES”

Name	Types	Description
<DEFAULT SCHEMA>.ALL_MANAGERS_BY_SITE	View	View
<DEFAULT SCHEMA>.ALL_MANAGERS_BY_SITE.Select	Select Statement	SELECT employee.emp_id, employee.emp_fname, employee.emp_lname, employee.phone, empl