Description
ShowSalesOrderItems shows items that were ordered in the speciifed sales order. It takes the sales order identifier as an argument.
Procedure properties
| name | value |
|---|
| name | GROUPO.ShowSalesOrderItems
|
| created |
|
| type | SQL stored procedure
|
Parameters
| name | datatype | length | in/out | comment |
|---|
| order_ID | integer | 4 | in | |
Usage
EXEC GROUPO.ShowSalesOrderItems
order_ID = @myinteger1Dependency graph
Objects that GROUPO.ShowSalesOrderItems depends on
Code
create procedure GROUPO.ShowSalesOrderItems( in order_ID integer )
result( LineID integer,
ProductID integer,
Quantity integer,
ShipDate date )
begin
select LineID,ProductID,Quantity,ShipDate
from GROUPO.SalesOrderItems
where SalesOrderItems.ID = order_ID
end