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

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

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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