Retrieving PO_LINE_ID for Purchase Price Variance Transactions in XLA Tables
Summary:
How can I trace the PO_LINE_ID
associated with a Purchase Price Variance transaction in the XLA tables, created during the Purchase Order receiving process under a standard costing setup?
Content (please ensure you mask any confidential information):
Hello,
I am working on identifying the PO_LINE_ID
for Purchase Price Variance (PPV) transactions recorded in the XLA tables during the PO receiving process in a standard costing setup. Here is the query I'm using:
select xal.* from xla_ae_lines xal where xal.ACCOUNTING_CLASS_CODE = 'PURCHASE_PRICE_VARIANCE'
My question is:
How can I retrieve the
0