Link between Receivables, Payables and Projects

 --Link between AP, AR and PA

select

aia.*

from

ap_invoices_all aia

,pjc_exp_items_all peia

,pjb_bill_trxs pbt

,pjb_inv_line_dists pild

,pjb_invoice_lines pil

,ra_customer_trx_lines_all rctla

,ra_customer_trx_all rcta

where

rcta.customer_trx_id=rctla.customer_trx_id

and rctla.customer_trx_line_id=pil.ra_cust_trx_line_id

and rctla.customer_trx_id=pil.ra_cust_trx_id

and pil.invoice_id=pild.invoice_id

and pil.invoice_line_id=pild.invoice_line_id

and pild.bill_trx_id=pbt.bill_trx_id

and pbt.transaction_id=peia.expenditure_item_id

and peia.original_header_id=aia.invoice_id