Payables and Cash Management - EBS (MOSC)

MOSC Banner

Help with this SQL

edited Aug 29, 2013 9:54AM in Payables and Cash Management - EBS (MOSC) 1 commentAnswered
 SELECT
       'Check_awt' type_indicator, 
      to_char(chk.check_number) invoice_or_check_number,

      custom_xla.sum_inv_amount_dr_$, 
      custom_xla.sum_inv_amount_cr_$, 

      custom_xla.sum_inv_amount_dr_EGP,
      custom_xla.sum_inv_amount_cr_EGP


FROM   ap_invoice_payments_all inv_payment, ap_checks_all chk,
                            (
                                  select 
                                   X.EVENT_ID,
                                   sum(x.unrounded_accounted_dr) sum_inv_amount_dr_$, 
                                   sum(x.unrounded_accounted_cr) sum_inv_amount_cr_$, 
                                   sum(x.unrounded_entered_dr) sum_inv_amount_dr_EGP,
                                   sum(x.unrounded_entered_cr) sum_inv_amount_cr_EGP
                                from xla_distribution_links x 
                                where  x.ROUNDING_CLASS_CODE  = 'AWT'

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