item inventory availability quantity

Summary:

how could build an report to retrieve the item availability quantity based on organization_id, sub_organization, item_inventory_id and lot number.

Content (required):

kindly need to build a report for item availability quantity based on the following parameters organization_id, sub_organization, item_inventory_id and lot number, we are facing issue to linked the reservation quantity with lot number as there is no linked find between the reservation tables and lot tables.

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

oracle fusion cloud