Forum Stats

  • 3,874,176 Users
  • 2,266,677 Discussions
  • 7,911,757 Comments

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,