# mes.spGetLotActivity

## Description
Returns a history of lot activity, including movements, quantities, lot states, and operation metadata. Useful for material traceability and inventory audits. Includes JOINs on `vwLot` and `vwLotEvent`.

## Syntax
<b>mes.spGetLotActivity @lotId, @lotName, @assetId, @assetPath, ...</b><br /><br />

<b>Parameters:</b><br />
@lotId (int): Specific lot to trace.<br />
@lotName (nvarchar): Lot name (supports partial matches).<br />
@assetId (int): Filter to a specific asset.<br />
@assetPath (nvarchar): Asset path (supports LIKE).<br />
@hasQty (bit): If 1, only show lots with non-zero net movement.<br />
@startDate, @endDate (datetime): Filter by event timestamps.<br />
@workOrderId, @workOrderName (int/nvarchar): Work order filters.<br />
@itemId, @itemName, @itemPath (int/nvarchar): Item filters.<br />
@assetTransportName (nvarchar): Optional transport association.<br />
@lotStateName, @lotStateReasonName (nvarchar): Optional lot state filters.<br /><br />

<b>Returns:</b><br />
Summarized lot activity records per lot ID, including:<br />
- Item and unit info<br />
- State and reason<br />
- Asset, transport, and timestamp data<br />
- Work order and quantity summary

### Code Example

```sql
EXEC mes.spGetLotActivity
    @lotName = '%FG%',
    @hasQty = 1,
    @startDate = '2025-07-01',
    @endDate = '2025-07-30';