Thursday, July 21, 2016

Query to find Costing Error Date wise

--Costing Error Datewise

SELECT TRUNC(TRANSACTION_DATE), COUNT(*)
FROM APPS.MTL_MATERIAL_TRANSACTIONS
WHERE COSTED_FLAG IS NOT NULL
--AND TRUNC(TRANSACTION_DATE)='17-FEB-2015'
GROUP BY TRUNC(TRANSACTION_DATE)
ORDER BY TRUNC(TRANSACTION_DATE) ASC;

No comments:

Post a Comment