Item On-Hand Quantity For A Specific Date SELECT qslt.organization_id, qslt.inventory_item_id, as_of_date_on_hand FROM ( SELECT organization_id, inventory_item_id, SUM (qty) AS as_of_date_on_hand FROM ( SELECT organization_id, inventory_item_id, SUM (transaction_quantity) qty FROM mtl_onhand_quantities_detail ...