ALL_ORDERS_BY_MANAGER

<DEFAULT SERVER>   >   <DEFAULT DATABASE>   >   <DEFAULT SCHEMA>   >   ALL_ORDERS_BY_MANAGER

Name
CUST_ID
EMPLOYEEFNAME
EMPLOYEEID
EMPLOYEELNAME
FIN_CODE_ID
ID
ORDER_DATE
SALES_REP
TOTAL_HT

CREATE VIEW ALL_ORDERS_By_Manager (Id, Cust_id, Fin_Code_Id, order_date, Sales_Rep,Total_HT,EmployeeId,EmployeeFname,EmployeeLname)
	AS SELECT 
			SO.Id,
			SO.Cust_id,
			SO.Fin_Code_Id,
			SO.order_date,
			SO.region,
			SO.Sales_Rep,
			SO.Total_HT,
			EMP.emp_id,
			EMP.emp_fname,
			EMP.emp_lname
		FROM
			SALES_ORDER SO,
			ALL_Managers EMP
		WHERE (
			SO.Sales_Rep = EMP.emp_id )

Name	Types	Description
<DEFAULT SCHEMA>.SALES_ORDER	Table	Table
<DEFAULT SCHEMA>.ALL_MANAGERS	View	View
CUST_ID	Column	Virtual column
<DEFAULT SCHEMA>.ALL_MANAGERS.EMP_FNAME	Column	View column
<DEFAULT SCHEMA>.ALL_MANAGERS_BY_DEPARTEMENT.EMP_ID	Column	View column
<DEFAULT SCHEMA>.ALL_MANAGERS.EMP_LNAME	Column	View column
FIN_CODE_ID	Column	Virtual column
ORDER_DATE	Column	Virtual column
REGION	Column	Virtual column
TOTAL_HT	Column	Virtual column
<DEFAULT SCHEMA>.SALES_ORDER.ID	Primary Key	Column
<DEFAULT SCHEMA>.SALES_ORDER.SALES_REP	Foreign Key	Column