mtl_onhand_quantities_detail moqd ,
tables with INVENTORY_ITEM_ID and ORGANIZATION_ID columns
Additionally, add a join of,
mil.INVENTORY_LOCATION_ID= mmt.LOCATOR_ID for joining mtl_item_locations and mtl_material_transactions.
you might need to change a little in join conditions depending on your requirements else that too may not required.
good luck !