I am looking for logic/possibility of finding received quantity at wsh_delivery_details level.
Scenario:
One order line with multiple wsh_delivery_details (Shipped separately with different tracking and all these records are assigned to Same Delivery Id. I am looking for a SQL logic to find received quantity at wsh_delivery_details level.