Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- (select
- table_2.product_qty
- from
- stock_move table_2
- join table_1icking spo on (table_2.picking_id=spo.id)
- where
- to_char(spo.min_date,'YYYY-MM-DD')::date = (current_date + 1) ) tomorrow_order_qty,
- (select
- table_2.product_qty
- from
- stock_move table_2
- join table_1icking spo on (table_2.picking_id=spo.id)
- where
- 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