Author: Not specified Language: tsql
Description: Not specified Timestamp: 2017-06-15 17:25:13 +0000
View raw paste Reply
SELECT vi.cntnr_name, vi.prod_name, vi.quantity, vi.zone_num, vi.uom_weight, vcs.num_cells, ((vi.quantity*vi.uom_weight)*.0022) AS 'Total Weight', vi.last_put_assign_time
FROM v_inventory vi INNER join v_ep_container_summary vcs ON vi.cntnr_id = vcs.cntnr_id
WHERE vi.cntnr_name in ('12 400290','12 400942','12 400841','12 400733','12 400189','12 401174',
        '12 400794','12 401495','12 401004','12 200667','12 201347','12 200765','12 401485','12 200004','12 201331')
and ((vi.quantity*vi.uom_weight)*.0022) > (50/num_cells)
and last_put_assign_time > '2017-06-05 23:00:52.000'
View raw paste Reply