Material Distributions

select 

ta.organization_id,

mp.organization_code,

org.name organization_name,

cc.concatenated_segments account,

si.segment1 item,

sum(base_transaction_value) value

from

mtl_transaction_accounts ta,

mtl_system_items si,

mtl_parameters mp,

hr_all_organization_units org,

gl_code_combinations_kfv cc

where

ta.reference_account=cc.code_combination_id 

and cc.code_combination_id=mp.material_account 

and si.inventory_item_id=ta.inventory_item_id 

and si.organization_id=ta.organization_id 

and mp.organization_id=ta.organization_id 

and mp.organization_id=org.organization_id

group by

ta.organization_id,

mp.organization_code,

org.name,

cc.concatenated_segments,

si.segment1

order by

ta.organization_id,

mp.organization_code,

org.name,

cc.concatenated_segments,

si.segment1