| Line 416... |
Line 416... |
| 416 |
AND t.destinationWarehouseId= 16
|
416 |
AND t.destinationWarehouseId= 16
|
| 417 |
AND t.status in ('TRANSFER_COMPLETE','IN_TRANSIT','PARTIAL_TRANSFER')
|
417 |
AND t.status in ('TRANSFER_COMPLETE','IN_TRANSIT','PARTIAL_TRANSFER')
|
| 418 |
AND i.transferStatus is not null AND type='WAREHOUSE_TRANSFER_OUT'
|
418 |
AND i.transferStatus is not null AND type='WAREHOUSE_TRANSFER_OUT'
|
| 419 |
group by i.itemId, s.transferLotId, i.purchaseId, i.id
|
419 |
group by i.itemId, s.transferLotId, i.purchaseId, i.id
|
| 420 |
order by s.scannedAt desc) as X group by inventoryItemId) as Y group by Y.itemId, Y.purchaseId
|
420 |
order by s.scannedAt desc) as X group by inventoryItemId) as Y group by Y.itemId, Y.purchaseId
|
| - |
|
421 |
order by Y.purchaseId desc
|
| 421 |
</select>
|
422 |
</select>
|
| 422 |
|
423 |
|
| 423 |
<select id="getScansforPurchase" resultType="scan" parameterType="map" >
|
424 |
<select id="getScansforPurchase" resultType="scan" parameterType="map" >
|
| 424 |
SELECT s.id, s.inventoryItemId, s.warehouseId, s.type, s.scannedAt, s.quantity, s.orderId, s.remarks, s.transferLotId
|
425 |
SELECT s.id, s.inventoryItemId, s.warehouseId, s.type, s.scannedAt, s.quantity, s.orderId, s.remarks, s.transferLotId
|
| 425 |
FROM scanNew s
|
426 |
FROM scanNew s
|