How to extract total unit cost data for inventory scrap transactions in Oracle Fusion Cloud?

Summary:

Hi Experts,

We have a requirement where we need to extract total unit cost data for inventory scrap transactions, initially we were using cst_perpavg_cost table to pick up the data, the column name is unit_cost_average, while it was working fine after few days when again ran the SQL query data is not available anymore, no changes have been done to the transaction but that same item was used for other transactions.

Please help with this issue.

Content (please ensure you mask any confidential information):

Version (include the version you are using, if applicable):

Code Snippet (add any code snippets that support your topic, if applicable):