XLA to GMF eXtract OPM

XLA to GMF eXtract for OPM
---------------------------------
SELECT
   eh.reference_no,
   eh.legal_entity_id,
   eh.ledger_id,
   eh.inventory_item_id,
   eh.organization_id,
   eh.transaction_source_type_id,
   eh.transaction_action_id,
   eh.transaction_type_id,
   eh.entity_code,
   eh.event_class_code,
   eh.event_type_code,
   eh.valuation_cost_type,
   eh.accounted_flag,
   eh.transaction_id,
   xal.code_combination_id,
   xal.ACCOUNTING_CLASS_CODE,
   gcc.concatenated_segments,
   nvl(xal.accounted_dr,0),
   nvl(xal.accounted_cr, 0)
 FROM
    gmf_xla_extract_headers eh,
    xla_ae_headers xah, xla_ae_lines xal,
    gl_code_combinations_kfv  gcc
              WHERE eh.event_id = xah.event_id
              AND xah.ae_header_id = xal.ae_header_id
              AND xah.application_id = 555
              AND eh.transaction_date >= To_Date('01/06/2020 00:00:00','dd-mm-yyyy hh24:mi:ss' )
              AND eh.transaction_date <= To_Date('10/06/2020 23:59:59 ','dd-mm-yyyy hh24:mi:ss' )
              AND xal.code_combination_id = gcc.code_combination_id