Order Management(OE) to General Ledger(GL) through Sub Ledger(XLA)

SELECT  ooha.order_number, mmt.transaction_id, mmt.transaction_date,--mtt.transaction_type_name, gcck.CONCATENATED_SEGMENTS,
        xal.accounted_dr, xal.accounted_cr
FROM
  apps.oe_order_headers_all ooha
, apps.oe_order_lines_all oola
, apps.mtl_material_transactions mmt
, apps.mtl_transaction_types mtt
, apps.xla_ae_headers xah
, apps.xla_ae_lines xal
, apps.xla_transaction_entities_upg xte
, apps.gl_import_references gir
, apps.gl_je_headers gjh
, apps.gl_je_lines gjl
, apps.gl_code_combinations_kfv gcck
WHERE ooha.header_id = oola.header_id
AND oola.line_id = mmt.trx_source_line_id
and mmt.transaction_type_id = mtt.transaction_type_id
and xah.ae_header_id = xal.ae_header_id
and xte.source_id_int_1 = mmt.transaction_id
and xte.entity_id = xah.entity_id
and gir.gl_sl_link_id = xal.GL_SL_LINK_ID
and gjh.je_header_id = gir.je_header_id
and gjl.je_line_num = gir.je_line_num
and gjh.je_header_id = gjl.je_header_id
and gcck.code_combination_id = gjl.code_combination_id
and gjl.period_name in (select distinct period_name from apps.gl_periods where start_date between :p_from_per and :p_to_per)
AND ooha.order_number in ('')