Notes

select c1.org_id ,a.transaction_date,mmt.transaction_type_id,
mmt.inventory_item_id,sum(a.base_transaction_value),''
from mtl_transaction_accounts a, gl_code_Combinations b,
mtl_material_transactions mmt,
(
select distinct
o.organization_id organization_id,
o2.ORGANIZATION_ID org_ID
from
HR_ORGANIZATION_UNITS_V o,
HR_ORGANIZATION_UNITS_V o2,
HR_ORGANIZATION_INFORMATION_V oi,
HR_ORGANIZATION_INFORMATION_V oi2,
MTL_PARAMETERS_VIEW io,
MTL_PARAMETERS_VIEW io2
where
o.ORGANIZATION_ID=oi.ORGANIZATION_ID
and oi.ORG_information3=oi2.ORGANIZATION_ID
and oi2.org_information1='OPERATING_UNIT'
and oi.org_information_context = 'Accounting Information'
and o2.ORGANIZATION_ID=oi2.ORGANIZATION_ID
and io.organization_code is not null
and io2.organization_code is not null
and io.organization_id = o.organization_id
and io2.organization_id = o2.organization_id
) c1
where
--a.organization_id = 103
A.organization_id = c1.organization_id
and a.transaction_date >= to_date( '2019/01/01 00:00:00' , 'RRRR/MM/DD HH24:MI:SS')
and a.transaction_date < to_date( '2019/02/01 00:00:00' , 'RRRR/MM/DD HH24:MI:SS')
and a.reference_account = b.CODE_COMBINATION_ID
and b.SEGMENT4 = '51150000'
and a.transaction_id = mmt.transaction_id
and a.ORGANIZATION_ID = mmt.organization_id
and a.INVENTORY_ITEM_ID = mmt.inventory_item_id
GROUP BY c1.org_id ,a.transaction_date,mmt.transaction_type_id,mmt.inventory_item_id;