Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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
- FROM in_product_balance_stock A
- INNER JOIN m_product B ON A.product_id = B.product_id
- INNER JOIN m_sell_price_product_for_so C ON B.product_id = C.product_id
- WHERE A.tenant_id = 10
- AND UPPER( B.product_code ) like '%EUS%'
- AND A.warehouse_id IN ( 158,168 )
- AND A.product_status IN ( 'GOOD','BAD','RETURN' )
- AND C.ou_id IN ( 13 )
- AND '20170210' BETWEEN C.date_from AND C.date_to
- GROUP BY B.product_id,B.product_code,B.product_name,B.base_uom_id
- LIMIT :limit OFFSET :offset
Advertisement
Add Comment
Please, Sign In to add comment