SELECT Distinct MMT.CREATION_DATE,mmt.transaction_quantity,
MMT.CREATED_BY,
(SELECT DESCRIPTION FROM APPS.FND_USER FU WHERE MMT.CREATED_BY=FU.USER_ID
)DONE_BY,
(SELECT TRANSACTION_TYPE_NAME
FROM APPS.MTL_TRANSACTION_TYPES MTT
WHERE MTT.TRANSACTION_TYPE_ID=MMT.TRANSACTION_TYPE_ID
)TRANSACTION_TYPE,
(SELECT organization_code
FROM APPS.ORG_ORGANIZATION_DEFINITIONS OOD
WHERE MMT.organization_id=ood.organization_id
)organization_code,
(select distinct description from mtl_system_items_b msi
where msi.organization_id= mmt.organization_id
and msi.inventory_item_id=mmt.inventory_item_id) item_name
FROM APPS.MTL_MATERIAL_TRANSACTIONS MMT
WHERE creation_date BETWEEN '01-Jan-2015' AND '10-Mar-2019'
--AND TRANSACTION_TYPE_ID='15'
AND ORGANIZATION_ID=204--1464(C55)
order by creation_date DESC
MMT.CREATED_BY,
(SELECT DESCRIPTION FROM APPS.FND_USER FU WHERE MMT.CREATED_BY=FU.USER_ID
)DONE_BY,
(SELECT TRANSACTION_TYPE_NAME
FROM APPS.MTL_TRANSACTION_TYPES MTT
WHERE MTT.TRANSACTION_TYPE_ID=MMT.
)TRANSACTION_TYPE,
(SELECT organization_code
FROM APPS.ORG_ORGANIZATION_
WHERE MMT.organization_id=ood.
)organization_code,
(select distinct description from mtl_system_items_b msi
where msi.organization_id= mmt.organization_id
and msi.inventory_item_id=mmt.
FROM APPS.MTL_MATERIAL_TRANSACTIONS MMT
WHERE creation_date BETWEEN '01-Jan-2015' AND '10-Mar-2019'
--AND TRANSACTION_TYPE_ID='15'
AND ORGANIZATION_ID=204--1464(C55)
order by creation_date DESC