713: union all
714: SELECT to_char(xd.source_distribution_id_num_1) transaction_id,
715: (NVL(xd.unrounded_accounted_dr,0) -
716: NVL(xd.unrounded_accounted_cr,0)) amount
717: FROM gl_import_references gli,
718: xla_ae_lines xl,
719: xla_ae_headers xh,
720: xla_distribution_links xd
721: WHERE gli.je_batch_id = vl_je_batch_id