Advertisement
Guest User

Untitled

a guest
Jul 28th, 2016
51
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.45 KB | None | 0 0
  1. (select
  2. table_2.product_qty
  3. from
  4. stock_move table_2
  5. join table_1icking spo on (table_2.picking_id=spo.id)
  6. where
  7. to_char(spo.min_date,'YYYY-MM-DD')::date = (current_date + 1) ) tomorrow_order_qty,
  8.  
  9. (select
  10. table_2.product_qty
  11. from
  12. stock_move table_2
  13. join table_1icking spo on (table_2.picking_id=spo.id)
  14. where
  15. to_char(spo.min_date,'YYYY-MM-DD')::date = (current_date + 2) ) next_three_day_qty
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement