Line Activity
A reporting stored procedure used for the following report(s): Line Detail, Line Summary. These reports can be found in the Legacy Reports category. The stored procedure uses the following table(s) to gather its data set: ilinestats, linegrouplines, linegroupconfig.
| Column | Parameter Direction | Data Type (Size) | Description |
|---|---|---|---|
| @WhereClause | INPUT | nvarchar (4000) | Filters the data set based on the selected filtering options. |
| @OrderClause | INPUT | nvarchar (2048) | Orders the data set based on the selected ordering options. |
| Column | Parameter Direction | Data Type (Size) | Description |
|---|---|---|---|
| i_WhereClause | INPUT | varchar2 | Filters the data set based on the selected filtering options. |
| i_OrderClause | INPUT | varchar2 | Orders the data set based on the selected ordering options. |
| o_prc | OUTPUT | sys_refcursor |