SELECT ct.trx_number

      ,l.accounting_class_code

      ,l.entered_dr

      ,l.entered_cr

      ,fnd_flex_ext.get_segs('SQLGL', 'GL#', gcc.chart_of_accounts_id, l.code_combination_id) account_number

      ,xla_oa_functions_pkg.get_ccid_description(gcc.chart_of_accounts_id

                                                ,l.code_combination_id) account_description

  FROM xla_ae_headers               h  --子分类帐头

      ,xla_ae_lines                 l  --子分类帐行

      ,xla_events                   e  --子分类帐表

      ,xla.xla_transaction_entities te --会计分录和事务处理关联的表

      ,ra_customer_trx_all          ct

      ,gl_code_combinations         gcc

 WHERE h.application_id = l.application_id

   AND h.ae_header_id = l.ae_header_id

   AND h.application_id = e.application_id

   AND h.event_id = e.event_id

   AND h.application_id = te.application_id

   AND h.entity_id = te.entity_id

   AND gcc.code_combination_id = l.code_combination_id

   AND te.application_id = 222

   AND te.entity_code = 'TRANSACTIONS'

   AND nvl(te.source_id_int_1, (-99)) = ct.customer_trx_id;