Material Transactions Query

Material Transactions Query

SELECT Distinct MMT.CREATION_DATE,
  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
FROM APPS.MTL_MATERIAL_TRANSACTIONS MMT
WHERE creation_date BETWEEN '01-Jan-2015' AND '10-Mar-2015'
AND TRANSACTION_TYPE_ID='15'
AND ORGANIZATION_ID='4203' --1464(C55)
order by creation_date DESC;

Post a Comment