	ALL_EMPLOYEES_DETAILS

Item Location

ALL_EMPLOYEES_DETAILS

Columns

Name
DEPT_NAME
EMP_FNAME
EMP_ID
EMP_LNAME
MANAGER_FNAME
PHONE
STATUS

Source Code

CREATE VIEW ALL_EMPLOYEES_DETAILS (emp_id, emp_lname, emp_fname, phone, dept_name,manager_fname,status)
	AS SELECT 
			empByDep.emp_id,
			empByDep.emp_fname,
			empByDep.emp_lname,
			empByDep.phone,
			empByDep.dept_name,
			manager.emp_fname,
			employee.status
		FROM
			EMPLOYEE employee,
			ALL_EMPLOYEES_BY_DEPARTMENT empByDep,
			manager
		WHERE (
			ALL_EMPLOYEES.manager_id = manager.emp_id AND
			ALL_EMPLOYEES.dept_id = empByDep.dept_id AND  employee.EMP_ID = empByDep.emp_id )

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

Name	Types	Description
<DEFAULT SCHEMA>.EMPLOYEE	Table	Table
MANAGER	Table	Table
<DEFAULT SCHEMA>.ALL_EMPLOYEES	View	View
<DEFAULT SCHEMA>.ALL_EMPLOYEES_BY_DEPARTMENT	View	View
<DEFAULT SCHEMA>.ALL_EMPLOYEES_BY_DEPARTMENT.DEPT_NAME	Column	View column
EMP_FNAME	Column	Virtual column
<DEFAULT SCHEMA>.ALL_EMPLOYEES_BY_DEPARTMENT.EMP_FNAME	Column	View column
EMP_ID	Column	Virtual column
<DEFAULT SCHEMA>.ALL_EMPLOYEES_BY_DEPARTMENT.EMP_ID	Column	View column
<DEFAULT SCHEMA>.ALL_EMPLOYEES_BY_DEPARTMENT.EMP_LNAME	Column	View column
<DEFAULT SCHEMA>.ALL_EMPLOYEES_BY_DEPARTMENT.PHONE	Column	View column
STATUS	Column	Virtual column
MANAGER_ID	Undefined Item
<DEFAULT SCHEMA>.EMPLOYEE.EMP_ID	Primary Key	Column
<DEFAULT SCHEMA>.EMPLOYEE.DEPT_ID	Foreign Key	Column

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

Name	Types	Description
<DEFAULT SCHEMA>.EMPLOYEES.GetManagerOfEmployeeById.c1	Cursor	PLSQL Cursor defined in EMPLOYEES.GetManagerOfEmployeeById
<DEFAULT SCHEMA>.EMPLOYEES.GetManagerOfEmployeeById.c1.Select	Select Statement	SELECT manager_fname FROM ALL_EMPLOYEES_DETAILS where emp_id = id