--- Organization and Sub Inventory and Transactions Type wise Material Transactions data
SELECT ood.organization_code,
ood.organization_name,
mmt.subinventory_code,
TO_CHAR (transaction_date, 'YYYY') trans_years,
mtt.transaction_type_name,
mtt.description transaction_description,
msi.segment1 item_code,
mmt.primary_quantity,
transaction_date,
transaction_uom,
transaction_quantity
FROM mtl_material_transactions mmt,
mtl_system_items_b msi,
mtl_transaction_types mtt,
org_organization_definitions ood
WHERE msi.inventory_item_id = mmt.inventory_item_id
AND mmt.organization_id = msi.organization_id
AND ood.organization_id = mmt.organization_id
AND mmt.transaction_type_id = mtt.transaction_type_id
AND TO_CHAR (transaction_date, 'YYYY') >= 2021 ---2021 to tail data
Order by mtt.transaction_type_name;