Help with this SQL
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'
Tagged:
0