Connection Between XLA Table and CST_STD_COSTS for Standard Costing

Summary:

I need assistance in finding the connection between the XLA table of cost update transactions and the CST_STD_COSTS table to retrieve the new and previous costs associated with standard costing.

Content (please ensure you mask any confidential information):

We are currently using standard costing in our system. I am specifically looking for a way to retrieve the new cost and the previous cost for transactions recorded as STANDARD_COST_ADJUSTMENT in the xla_ae_linestable.

I have the following query:

SELECT * FROM xla_ae_lines l WHERE l.accounting_class_code = 'STANDARD_COST_ADJUSTMENT';

From this query, I would like to understand how to access the CST_STD_COSTS table (or another relevant table) to obtain the new and previous costs. Any guidance on the join conditions or additional tables to consider would be greatly appreciated!