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

Drilldown from GL to Inventory Transactions, Inv to gl Link Query R12,Inventory to General ledger links, r12 ,Inv to gl drill down

Drilldown from GL to Inventory Transactions, Inv to gl Link Query R12,Inventory to General ledger links, r12 ,Inv to gl drill down Link bet...