Subversion Repositories SmartDukaan

Rev

Rev 11512 | Rev 11750 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 11512 Rev 11583
Line 415... Line 415...
415 
	WHERE i.itemId in
415 
	WHERE i.itemId in
416 
	<foreach item="itemId" index="index" collection="itemIds"
 416 
	<foreach item="itemId" index="index" collection="itemIds"
417 
        open="(" separator="," close=")">
 417 
        open="(" separator="," close=")">
418 
	 #{itemId}
418 
	 #{itemId}
419 
	</foreach>
419 
	</foreach>
420 
	AND t.destinationWarehouseId= 16
420 
	AND t.destinationWarehouseId in (16, 1771)
421 
	AND t.status in ('TRANSFER_COMPLETE','IN_TRANSIT','PARTIAL_TRANSFER')
421 
	AND t.status in ('TRANSFER_COMPLETE','IN_TRANSIT','PARTIAL_TRANSFER')
422 
	AND i.transferStatus is not null AND type='WAREHOUSE_TRANSFER_OUT'
422 
	AND i.transferStatus is not null AND type='WAREHOUSE_TRANSFER_OUT'
423 
	group by i.itemId, s.transferLotId, i.purchaseId, i.id
423 
	group by i.itemId, s.transferLotId, i.purchaseId, i.id
424 
	order by s.scannedAt desc) as X group by inventoryItemId) as Y group by Y.itemId, Y.purchaseId
 424 
	order by s.scannedAt desc) as X group by inventoryItemId) as Y group by Y.itemId, Y.purchaseId
425 
	order by Y.purchaseId desc
 425 
	order by Y.purchaseId desc