Total Pageviews

November 19, 2019

11/19/2019 10:40:00 AM
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
 
Related Posts Plugin for WordPress, Blogger...