ALL_MANAGERS

<DEFAULT SERVER>   >   <DEFAULT DATABASE>   >   <DEFAULT SCHEMA>   >   ALL_MANAGERS

Name
EMP_FNAME
EMP_LNAME
ID
MANAGER_ID
NAME

CREATE VIEW ALL_Managers (Id, NAME, Manager_Id, emp_fname, emp_lname)
	AS SELECT 
        AMD.emp_id,
        AMD.emp_fname,
        AMD.emp_lname,
        AMD.phone,
        AMD.status,
        AMD.Name 
      
      FROM
        ALL_Managers_by_Departement AMD
    UNION
      SELECT 
        AMS.emp_id,
        AMS.emp_fname,
        AMS.emp_lname,
        AMS.phone,
        AMS.status,
        AMS.Name 
      
      FROM
        ALL_Managers_by_Site AMS

Name	Types	Description
<DEFAULT SCHEMA>.ALL_MANAGERS_BY_DEPARTEMENT	View	View
<DEFAULT SCHEMA>.ALL_MANAGERS_BY_SITE	View	View
<DEFAULT SCHEMA>.ALL_MANAGERS_BY_DEPARTEMENT.EMP_FNAME	Column	View column
<DEFAULT SCHEMA>.ALL_MANAGERS_BY_SITE.EMP_FNAME	Column	View column
<DEFAULT SCHEMA>.ALL_MANAGERS_BY_SITE.EMP_ID	Column	View column
<DEFAULT SCHEMA>.ALL_MANAGERS_BY_DEPARTEMENT.EMP_ID	Column	View column
<DEFAULT SCHEMA>.ALL_MANAGERS_BY_DEPARTEMENT.EMP_LNAME	Column	View column
<DEFAULT SCHEMA>.ALL_MANAGERS_BY_SITE.EMP_LNAME	Column	View column
NAME	Column	Virtual column
NAME	Column	Virtual column
<DEFAULT SCHEMA>.ALL_MANAGERS_BY_SITE.PHONE	Column	View column
<DEFAULT SCHEMA>.ALL_MANAGERS_BY_DEPARTEMENT.PHONE	Column	View column
<DEFAULT SCHEMA>.ALL_MANAGERS_BY_DEPARTEMENT.STATUS	Column	View column
<DEFAULT SCHEMA>.ALL_MANAGERS_BY_SITE.STATUS	Column	View column

Name	Types	Description
<DEFAULT SCHEMA>.ALL_ORDERS_BY_MANAGER	View	View
<DEFAULT SCHEMA>.GET_LOG_2017_BY_MANAGERS	View	View
<DEFAULT SCHEMA>.GET_LOG_2017_BY_MANAGERS.Select	Select Statement	SELECT Log_date, Action, Title, Message, Employee_Id, EMP_FNAM
<DEFAULT SCHEMA>.ALL_ORDERS_BY_MANAGER.Select	Select Statement	SELECT SO.Id, SO.Cust_id, SO.Fin_Code_Id, SO.order_date, SO.region, SO.Sales_Rep,