Need organization inventory data unit cost wise
We have 11 Inventory Organization in which we want inventory unit cost as per org id.
so we created customized query
join cst_transactions ct into inv_material_txns imt through ct.INVENTORY_ORG_ID = imt.ORGANIZATION_ID
and select 1 inventory organization but still its shows all organization data.