Payables and Cash Management - EBS (MOSC)

MOSC Banner

links between xla_distribution_links and AP_INVOICES_ALL and AP_INVOICE_DISTRIBUTIONS_ALL

edited Oct 31, 2013 7:54PM in Payables and Cash Management - EBS (MOSC) 6 commentsAnswered
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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center