By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| ITEM_NUM | SUB_INV | LOT_NUM | QUANTITY | LOT_EXPIRY_DATE | RUNNING_QUANTITY | QTY_FETCHED |
|---|---|---|---|---|---|---|
| 101 | 22 | A2 | 14 | 28-SEP-19 | 14 | 14 |
| 101 | 22 | A1 | 10 | 29-SEP-19 | 24 | 6 |
| ITEM_NUM | SUB_INV | LOT_NUM | QUANTITY | LOT_EXPIRY_DATE | RUNNING_QUANTITY | QTY_FETCHED |
|---|---|---|---|---|---|---|
| 101 | 22 | A2 | 14 | 28-SEP-19 | 14 | 14 |
| 101 | 22 | A1 | 10 | 29-SEP-19 | 24 | 6 |