GetAllOrders

<DEFAULT SERVER>   >   <DEFAULT DATABASE>   >   <DEFAULT SCHEMA>   >   SALEORDER   >   GetAllOrders

Procedure body GetAllOrders(), Package SALEORDER

Name	Types	Value
r1	Variable
Impact Analysis:	Object calling \"r1\" Object Type <DEFAULT SCHEMA>.SALEORDER.GetAllOrders Procedure

Name	Definition
c1	cursor c1 is SELECT Id, Cust_id, Fin_Code_Id, order_date, Sales_Rep,Total_HT,EmployeeId,EmployeeFname,EmployeeLname FROM ALL_ORDERS_By_Employee;

procedure GetAllOrders 
	is
		cursor c1 is
				SELECT Id, Cust_id, Fin_Code_Id, order_date, Sales_Rep,Total_HT,EmployeeId,EmployeeFname,EmployeeLname
				FROM ALL_ORDERS_By_Employee;
    
    begin

        for r1 in c1 loop
			dbms_output.put_line(
				lpad(r1.ID,12)
			);
			end loop;

    end GetAllOrders

Name	Types	Description
<DEFAULT SCHEMA>.ALL_ORDERS_BY_EMPLOYEE	View	View
<DEFAULT SCHEMA>.SALEORDER.GetAllOrders	Procedure	Procedure interface GetAllOrders(), Package SALEORDER
LPAD	Function	PL/SQL System Function
DBMS_OUTPUT.PUT_LINE	Function	PL/SQL System Function
<DEFAULT SCHEMA>.ALL_ORDERS_BY_EMPLOYEE.CUST_ID	Column	View column
<DEFAULT SCHEMA>.ALL_ORDERS_BY_EMPLOYEE.EMPLOYEEFNAME	Column	View column
<DEFAULT SCHEMA>.ALL_ORDERS_BY_EMPLOYEE.EMPLOYEEID	Column	View column
<DEFAULT SCHEMA>.ALL_ORDERS_BY_EMPLOYEE.EMPLOYEELNAME	Column	View column
<DEFAULT SCHEMA>.ALL_ORDERS_BY_EMPLOYEE.FIN_CODE_ID	Column	View column
<DEFAULT SCHEMA>.ALL_ORDERS_BY_EMPLOYEE.ID	Column	View column
<DEFAULT SCHEMA>.ALL_ORDERS_BY_EMPLOYEE.ORDER_DATE	Column	View column
<DEFAULT SCHEMA>.ALL_ORDERS_BY_EMPLOYEE.SALES_REP	Column	View column
<DEFAULT SCHEMA>.ALL_ORDERS_BY_EMPLOYEE.TOTAL_HT	Column	View column
PUBLIC.DBMS_OUTPUT	Synonym	PL/SQL System Synonym