To get data for Misc Receipt

SELECT ood.organization_code,
mmt.inventory_item_id Item_id,
msi.segment1 item_name,
mmt.creation_date,
mmt.transaction_quantity,
mmt.transaction_date,
mtt.transaction_type_name,
mmt.*
FROM mtl_material_transactions mmt,
     mtl_system_items msi,
     mtl_transaction_types mtt,
     org_organization_definitions ood
WHERE     msi.inventory_item_id = mmt.inventory_item_id
and mmt.organization_id = ood.organization_id
      AND mmt.organization_id = msi.organization_id
      AND mmt.transaction_type_id IN (100001, 100002)
      AND mtt.transaction_type_id = mmt.transaction_type_id
      AND TRUNC (mmt.transaction_date) BETWEEN :f AND :t
      AND mmt.organization_id = 81
ORDER BY mmt.transaction_date