How to Query Work Order Picks Pick Confirmed with zero Quantity

We are using Oracle discrete work order Picks. There are situations where a pick is created but picker does not find the quantity in the bin due to inventory issues. Picker pick confirms with zero quantity and the system cancels the pick. That is the expected behavior and it is working.

We want to identify the data where the picks have been pick confirmed with zero quantity, How to query this data either from front end or back end table,