--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;
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