ALL_SALES_ORDER_ITEMS_DETAILS

<DEFAULT SERVER>   >   <DEFAULT DATABASE>   >   <DEFAULT SCHEMA>   >   ALL_SALES_ORDER_ITEMS_DETAILS

Name
FIN_CODE_ID
ID
ITEM_ID
ORDER_DATE
PROD_SIZE
PRODUCT_NAME
REGION
TOTAL_HT

CREATE VIEW ALL_Sales_Order_Items_DETAILS (Id, order_date, fin_code_id, region,item_id,product_name, prod_size,Total_HT)
	AS SELECT 
			sales_order.id,   
			sales_order.order_date,   
			sales_order.fin_code_id,   
			sales_order.region,
			sales_order_items.Id,
			product.Name,
			sum (sales_order_items.quantity*unit_price) 
    FROM   
		 sales_order_items, 
		 product, 
         sales_order 
   WHERE ( employee.emp_id = sales_order.sales_rep ) and  
			(sales_order_items.id = sales_order.id) and
			(product.id = sales_order_items.prod_id)   

	GROUP BY sales_order.id,sales_order.order_date,   
         sales_order.fin_code_id,   
         sales_order.region

Name	Types	Description
<DEFAULT SCHEMA>.EMPLOYEE	Table	Table
<DEFAULT SCHEMA>.PRODUCT	Table	Table
<DEFAULT SCHEMA>.SALES_ORDER	Table	Table
<DEFAULT SCHEMA>.SALES_ORDER_ITEMS	Table	Table
SUM	Function	PL/SQL System Function
FIN_CODE_ID	Column	Virtual column
NAME	Column	Virtual column
ORDER_DATE	Column	Virtual column
QUANTITY	Column	Virtual column
REGION	Column	Virtual column
<DEFAULT SCHEMA>.PRODUCT.UNIT_PRICE	Column	Column
<DEFAULT SCHEMA>.EMPLOYEE.EMP_ID	Primary Key	Column
<DEFAULT SCHEMA>.SALES_ORDER.ID	Primary Key	Column
<DEFAULT SCHEMA>.SALES_ORDER_ITEMS.ID	Primary Key	Column
<DEFAULT SCHEMA>.PRODUCT.ID	Primary Key	Column
<DEFAULT SCHEMA>.SALES_ORDER_ITEMS.PROD_ID	Foreign Key	Column
<DEFAULT SCHEMA>.SALES_ORDER.SALES_REP	Foreign Key	Column

Name	Types	Description
<DEFAULT SCHEMA>.SALEORDER.GetAllItems.c1	Cursor	PLSQL Cursor defined in SALEORDER.GetAllItems
<DEFAULT SCHEMA>.SALEORDER.GetAllItems.c1.Select	Select Statement	SELECT Id, order_date, fin_code_id, region,item_id,product_name, prod_size,Total_HT FROM ALL_Sale