Merge pull request #32280 from s-aga-r/refactor/report/item-shortage-report

refactor: rewrite `Item Shortage Report` queries in QB