Forum Stats

  • 3,874,176 Users
  • 2,266,677 Discussions


Related to ERP Fusion Cloud : How do we join XLA_AE_LINES table with PJB_INVOICE_ALL table?

Hi ,

Can anyone help with below requirement.

How we can able to join XLA_AE_LIINES table with PJB_INVOICE_Headers/Lines table ,

Requirement is to pull task level data from PJB_INV_distribution.task_id

Join is PJB_Headers -> PJB_Lines -> PJB_Distribution

But we connect PJB table to map Subledger table i,e XLA

ISSUE: I'm getting sort of Cartesian result

Many thanks,