BI Publisher (MOSC)

MOSC Banner

How to query item cost as screen shown?

Hi, everybody!

Which is the appropriate way to query cost of an item, given its cost organization, book, valuation unit, as it shown in screen?

I don't understand data from CST_PERPAVG_COST table yet.

So far, I understand that it stores every transaction which affect this type of cost, its date and cost calculation. But, when I query data from shown date, it doesn't retrieve cost as I see it on screen.

Any help, I'll appreciate it.

Thanks!

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