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

Types of animations

Animation is a diverse and creative field with a variety of styles that artists and filmmakers use to bring their visions to life. Here are ...