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

How to improve blog performance

Improving the performance of a blog can involve a variety of strategies, including optimizing the website's technical infrastructure, im...