Discrete Manufacturing - EBS (MOSC)

MOSC Banner

Item Average Cost

edited Aug 25, 2022 8:23PM in Discrete Manufacturing - EBS (MOSC) 3 commentsAnswered ✓

Hi Guys

Do the below Query Correct to get average cost ?

SELECT avg(ACTUAL_COST) FROM MTL_MATERIAL_TRANSACTIONS WHERE organization_id='XXX' AND inventory_item_id='XXXXX';

Actually, i compared the result of this query with the average cost from item cost workbench

but they are a different, do I miss another condition on the query ?


Thank you

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center