Skip to Main Content

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

Uday PNov 18 2022

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,

Comments
Post Details
Added on Nov 18 2022
0 comments
16 views