Subversion Repositories SmartDukaan

Rev

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

Rev 9830 Rev 10120
Line 332... Line 332...
332 
	SELECT *
332 
	SELECT *
333 
	FROM scanNew
 333 
	FROM scanNew
334 
	WHERE transferLotId = #{id}
 334 
	WHERE transferLotId = #{id}
335 
	AND type = 'WAREHOUSE_TRANSFER_OUT'
 335 
	AND type = 'WAREHOUSE_TRANSFER_OUT'
336 
</select>
 336 
</select>
- 
 
 337 
 
- 
 
 338 
<select id= "getScansForTransferLotAndInventoryItem" resultType = "scan" parameterType="map" >
- 
 
 339 
	SELECT *
- 
 
 340 
	FROM scanNew
- 
 
 341 
	WHERE transferLotId = #{transferLotId}
- 
 
 342 
	AND inventoryItemId = #{inventoryItemId}
- 
 
 343 
	AND type = 'WAREHOUSE_TRANSFER_OUT'
- 
 
 344 
	LIMIT 1
- 
 
 345 
</select>
337
346
338 
</mapper>
 347 
</mapper>