Item Details in between that transaction dates

SELECT  --OOD.ORGANIZATION_NAME,
MSIB.SEGMENT1 ITEM_CODE,SUBSTR(MSIB.DESCRIPTION,1,INSTR(MSIB.DESCRIPTION,' ',1,1)) PART_NO,
MSIB.DESCRIPTION ITEM_DESC,MSIB.ATTRIBUTE6 MODEL_NO,MSIB.ATTRIBUTE7 ITEM_CLASS,OOD.ORGANIZATION_NAME
FROM MTL_SYSTEM_ITEMS_B MSIB,
mtl_material_transactions MT,
ORG_ORGANIZATION_DEFINITIONS OOD
WHERE
MSIB.INVENTORY_ITEM_ID=MT.INVENTORY_ITEM_ID
AND MSIB.ORGANIZATION_ID=MT.ORGANIZATION_ID
AND MSIB.ORGANIZATION_ID=MT.ORGANIZATION_ID
AND MSIB.ORGANIZATION_ID=OOD.ORGANIZATION_ID
AND MT.ORGANIZATION_ID=OOD.ORGANIZATION_ID
AND OOD.ORGANIZATION_NAME LIKE '%XXX%'
AND MT.CREATION_DATE between TO_DATE(:PFROM) AND TO_DATE(:PTO)