Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
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 Conditions for PO to XLA to Projects and AP Payments to XLA to Projects in Oracle Fusion

edited Sep 12, 2020 10:24AM in Subledger Accounting & Accounting Hub 1 comment

Summary

Join Conditions for PO to XLA to Projects and AP Payments to XLA to Projects in Oracle Fusion

Content

Dear All,

Can you please let me know the Join Conditions in Oracle Fusion for 

1. PO to  XLA to Projects

Tried to link po_distributions_allpda ,pjc_exp_items_all peia and xla_distribution_links xdl

with pda.po_distribution_id            = xdl.source_distribution_id_num_1

peia.parent_dist_id               = pda.po_distribution_id

Also tried with rcv_transactions table but not able to find.

2.AP Payments to XLA to Projects.

For this I am using ap_invoice_payments_all table to join with projects tables but not able to find.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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