I am trying too much, but i didn't find some of Join Conditions between
, mtl_onhand_quantities_detail moqd
, mtl_item_locations mil
, mtl_material_transactions mmt
please help me if you know,
--Thanks & Regards,
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 !