links between xla_distribution_links and AP_INVOICES_ALL and AP_INVOICE_DISTRIBUTIONS_ALL
Hi all,
Could you tell me how to link these 3 tables( xla_distribution_links and AP_INVOICES_ALL and AP_INVOICE_DISTRIBUTIONS_ALL) together in a SQL query ,please
i want to retrieve ( sum (UNROUNDED_ENTERED_DR),
sum (UNROUNDED_ENTERED_CR),
sum (UNROUNDED_ACCOUNTED_CR),
sum (UNROUNDED_ACCOUNTED_DR)
) columns from the xla_distribution_links
with the invoices event_type_code = PREPAYMENT APPLIED or PREPAYMENT UNAPPLIED
Thanks
Tagged:
0