All Transactional Data which flows from mmt to gmf_xla_extract tables

All Transactional Data  which flows to gmf_xla_extract tables from MMT

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,
 el.journal_line_type,
 sum(el.component_cost),
 sum(el.trans_amount_raw),
 sum(el.base_amount_raw)
from gmf_xla_extract_lines el,
 gmf_xla_extract_headers eh
where el.header_id = eh.header_id
and eh.transaction_date >= to_date('01/06/2020 00:00:00','dd-mm-yyyy hh24:mi:ss')
and eh.transaction_date <= to_date('30/06/2020 23:59:59','dd-mm-yyyy hh24:mi:ss')
group by 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,
 el.journal_line_type;