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

Join between xla_distribution_links and po_distributions_all

in Reporting and Analytics for ERP 1 comment

Hi,

Can anyone tell me how to join from xla_distribution_links to the purchase order tables (po_distributions_all)?

For example, for the receipt accounting accrual. In xla_distribution_links, I have the ae_header_id and ae_line_num and the source_distribution_type is PERIOD_END_ACCRUAL. I need to join to the purchase order to bring in information about the order that generated the accrual.

I had thought this would be the source_distribution_id_num_1 field however when I query the po_distributions_all table no results are returned. Do I need to join to a different table?

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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