widana

Untitled

Feb 10th, 2017
122
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. SELECT  B.product_id,B.product_code,B.product_name,COALESCE(SUM(A.qty),0) AS qty,COALESCE(MAX(C.gross_sell_price),0) AS price,f_get_uom_name(B.base_uom_id) AS uom_name  
  2. FROM in_product_balance_stock A  
  3. INNER JOIN m_product B ON A.product_id = B.product_id  
  4. INNER JOIN m_sell_price_product_for_so C ON B.product_id = C.product_id  
  5. WHERE A.tenant_id = 10  
  6. AND  UPPER( B.product_code ) like '%EUS%'  
  7. AND A.warehouse_id  IN ( 158,168 )  
  8. AND A.product_status  IN ( 'GOOD','BAD','RETURN' )  
  9. AND C.ou_id  IN ( 13 )  
  10. AND '20170210' BETWEEN C.date_from AND C.date_to
  11. GROUP BY B.product_id,B.product_code,B.product_name,B.base_uom_id  
  12. LIMIT :limit OFFSET :offset
Advertisement
Add Comment
Please, Sign In to add comment