You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Query to get Total Unit Cost from Review Item Costs

Accepted answer


Query to get Total Unit Cost from Review Item Costs

Content (please ensure you mask any confidential information):

I have tried following Oracle documentation in order to fetch the Total Unit Cost field from the field below on Review Item Costs:

The issue we have found is that most of the queries I have seen utilize either the CST_PERPAVG_COST_HEADER_V view, and/or the CST_ PERPAVG_COST table, and in our environment both this view and table have no rows in it (blank).

I want to get the most effective dated Unit Cost per Item / Cost Org / Valuation Unit, how can I fetch this information given that the above objects do not have data in them?

Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!