	ALL_EMPLOYEES

Item Location

ALL_EMPLOYEES

Columns

Name
CITY
EMP_FNAME
EMP_ID
EMP_LNAME
EMP_STREET
PHONE
STATE
ZIP_CODE

Source Code

CREATE VIEW ALL_EMPLOYEES (emp_id, emp_lname, emp_fname, emp_street, city,state,zip_code,phone)
	AS SELECT emp_id, emp_lname, emp_fname, emp_street, city,state,zip_code,phone
	FROM EMPLOYEE

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

Name	Types	Description
<DEFAULT SCHEMA>.EMPLOYEE	Table	Table
<DEFAULT SCHEMA>.EMPLOYEE.EMP_FNAME	Column	Column
<DEFAULT SCHEMA>.EMPLOYEE.EMP_LNAME	Column	Column
<DEFAULT SCHEMA>.EMPLOYEE.EMP_ID	Primary Key	Column

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

Name	Types	Description
<DEFAULT SCHEMA>.ALL_EMPLOYEES_BY_DEPARTMENT	View	View
<DEFAULT SCHEMA>.ALL_ORDERS_BY_EMPLOYEE	View	View
<DEFAULT SCHEMA>.EMPLOYEES.GetAllEmployees.c1	Cursor	PLSQL Cursor defined in EMPLOYEES.GetAllEmployees
<DEFAULT SCHEMA>.ALL_EMPLOYEES_DETAILS.Select	Select Statement	SELECT empByDep.emp_id, empByDep.emp_fname, empByDep.emp_lname, empByDep.phone, empB
<DEFAULT SCHEMA>.ALL_ORDERS_BY_EMPLOYEE.Select	Select Statement	SELECT SO.Id, SO.Cust_id, SO.Fin_Code_Id, SO.order_date, SO.region, SO.Sales_Rep,
<DEFAULT SCHEMA>.EMPLOYEES.GetAllEmployees.c1.Select	Select Statement	SELECT emp_id, emp_lname, emp_fname, emp_street, city,state,zip_code,phone FROM ALL_EMPLOYEES
<DEFAULT SCHEMA>.ALL_EMPLOYEES_BY_DEPARTMENT.Select	Select Statement	SELECT ALL_EMPLOYEES.emp_id, ALL_EMPLOYEES.emp_fname, ALL_EMPLOYEES.emp_lname, ALL_EMPL