Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.
select a.item_number, item_description, item_class_code, a.location, a.bin, case when item_tracking_option = 'none' then a.quantity when item_tracking_option = 'serial numbers' then c.qty end as quantity, selling_u_of_m, item_tracking_option, xboxupc, serial_num, case when a.bin like '%.p%' and a.bin not like 'te%' then substring(a.bin, 6,3) when a.bin like 'wh%' then substring(a.bin, 6,2) else a.bin end as section, case when a.bin like 'wh%' then substring(a.bin, 4,1) end as pickable from spvinventorymultibin a join spvitemmaster b on a.item_number=b.item_number left join spvinventoryserialnum c on a.item_number=c.item_number and a.bin=c.bin where quantity>0 and a.location='tsp' order by a.location, bin, a.item_number
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
10 Experts available now in Live!