SELECT ct.trx_number

      ,adj.adjustment_number

      ,ad.amount_dr

      ,ad.amount_cr

      ,ad.source_table

      ,ad.source_type

      ,xla_oa_functions_pkg.get_ccid_description(gcc.chart_of_accounts_id

                                                ,ad.code_combination_id)

  FROM ar_distributions_all ad

      ,ar_adjustments_all   adj

      ,ra_customer_trx_all  ct

      ,gl_code_combinations         gcc

 WHERE ad.source_table = 'ADJ'

   AND ad.source_id = adj.adjustment_id

   AND adj.customer_trx_id = ct.customer_trx_id

   AND gcc.code_combination_id = ad.code_combination_id;