Query to fetch the item wise lots with the on-hand per subinventory

Summary:

Request to have a select query to fetch the item wise lots with the on-hand per subinventory

Content (please ensure you mask any confidential information):

We have a requirement to have a report/query to fetch the item wise lot details with the on-hand balance per subinventory.

Version (include the version you are using, if applicable):

26A (11.13.26.01.0)

Code Snippet (add any code snippets that support your topic, if applicable):