	ALL_DEPARTMENTS

Item Location

ALL_DEPARTMENTS

Columns

Name
DEPT_HEAD_ID
DEPT_ID
DEPT_NAME
MANAGER_ID
SITE_ID

Source Code

CREATE VIEW ALL_DEPARTMENTS (DEPT_ID, DEPT_HEAD_ID, DEPT_NAME,SITE_ID,Manager_Id)
	AS SELECT 
			DEPT_ID,
			DEPT_HEAD_ID,
			DEPT_NAME,
      SITE_ID,
      Manager_Id

		FROM
			department

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

Name	Types	Description
<DEFAULT SCHEMA>.DEPARTMENT	Table	Table
<DEFAULT SCHEMA>.DEPARTMENT.DEPT_HEAD_ID	Column	Column
<DEFAULT SCHEMA>.DEPARTMENT.DEPT_NAME	Column	Column
<DEFAULT SCHEMA>.DEPARTMENT.DEPT_ID	Primary Key	Column
<DEFAULT SCHEMA>.DEPARTMENT.MANAGER_ID	Foreign Key	Column
<DEFAULT SCHEMA>.DEPARTMENT.SITE_ID	Foreign Key	Column

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

Name	Types	Description
<DEFAULT SCHEMA>.ALL_EMPLOYEES_BY_DEPARTMENT	View	View
<DEFAULT SCHEMA>.ALL_MANAGERS_BY_DEPARTEMENT	View	View
<DEFAULT SCHEMA>.ALL_MANAGERS_BY_DEPARTEMENT.Select	Select Statement	SELECT employee.emp_id, employee.emp_fname, employee.emp_lname, employee.phone, empl
<DEFAULT SCHEMA>.ALL_EMPLOYEES_BY_DEPARTMENT.Select	Select Statement	SELECT ALL_EMPLOYEES.emp_id, ALL_EMPLOYEES.emp_fname, ALL_EMPLOYEES.emp_lname, ALL_EMPL