Query - Find AR Distributions with different GL segments for different Accounting Class

  SELECT '''' || trx_number Invoice_number,
         trx_date Transaction_date,
         b.amount Rec_amount,
         b1.amount Rev_amount,
         c.segment1 REC_Company,
         c1.segment1 REV_Company,
         c.concatenated_segments REC_Accounting_string,
         c1.concatenated_segments REV_accounting_string
    FROM apps.ra_customer_trx_all a,
         apps.ra_cust_trx_line_gl_dist_all b,
         apps.ra_cust_trx_line_gl_dist_all b1,
         apps.gl_code_combinations_kfv c,
         apps.gl_code_combinations_kfv c1
   WHERE     a.customer_trx_id = b.customer_trx_id
         AND a.customer_trx_id = b1.customer_trx_id
         AND b.code_combination_id = c.code_combination_id
         AND b1.code_combination_id = c1.code_combination_id
         AND b.account_class = 'REC'
         AND b1.account_class = 'REV'
         AND c.segment1 != c1.segment1
ORDER BY a.creation_date DESC