|#000|+Sandeep| Product search query refactored
|#000| amc field in lineitem is integer not numeric