لو سمخت ممكن حد يشرح فائدة xla schema
وايه الربط مابينها وبين cash managment

لو سمخت ممكن حد يشرح فائدة xla schema
وايه الربط مابينها وبين cash managment

ارجو المساعدة

SELECT   ael.currency_code,
	 aeh.GROUP_ID,
	 aeh.ae_header_id,
	 ael.ae_line_num,
	 aeh.event_id,
	 aeh.entity_id,
	 aeh.accounting_date,
	 aeh.accounting_entry_status_code aesc,
	 aeh.gl_transfer_status_code glsc,
	 aeh.gl_transfer_date,
	 e.event_date,
	 e.event_status_code,
	 e.process_status_code,
	 cf.cashflow_id,
	 cf.trxn_reference_number,
	 cf.cashflow_date,
	 cf.statement_line_id,
	 ba.bank_id,
	 bk.bank_name,
	 ba.bank_account_id,
	 ba.bank_account_num,
	 ba.bank_account_name,
	 ba.currency_code bank_currency_code,
	 cf.cashflow_exchange_rate,
	 cf.cashflow_status_code,
	 cf.cleared_exchange_rate,
	 cf.cleared_amount je_category_name,
	 accounting_class_code,
	 aeh.doc_sequence_value,
	 glcc.code_combination_id,
	 glcc.concatenated_segments,
	 ael.entered_dr,
	 ael.entered_cr,
	 ael.accounted_dr,
	 ael.accounted_cr,
	 jeb.name batch_name,
	 jeh.name journal_name,
	 jel.je_line_num
 FROM   xla.xla_ae_headers aeh,
	 xla.xla_ae_lines ael,
	 xla.xla_events e,
	 xla.xla_transaction_entities te,
	 apps.gl_code_combinations_kfv glcc,
	 ce.ce_cashflows cf,
	 --   ce.ce_cashflow_acct_h cfah,
	 ce.ce_bank_accounts ba,
	 apps.ce_banks_v bk,
	 gl.gl_import_references glref,
	 gl.gl_je_batches jeb,
	 gl.gl_je_headers jeh,
	 gl.gl_je_lines jel
WHERE	   aeh.application_id(+) = 260
	 AND cf.cashflow_bank_account_id = ba.bank_account_id
	 AND (ba.bank_id = bk.pk_id)
	 AND cf.cashflow_id = te.source_id_int_1(+)
	 AND te.application_id = e.application_id(+)
	 AND te.entity_id = e.entity_id(+)
	 AND e.application_id = aeh.application_id(+)
	 AND e.event_id = aeh.event_id(+)
	 AND aeh.ae_header_id = ael.ae_header_id(+)
	 AND ael.code_combination_id = glcc.code_combination_id(+)
	 AND ael.gl_sl_link_id = glref.gl_sl_link_id(+)
	 AND (glref.je_header_id = jel.je_header_id(+))
	 AND (glref.je_line_num = jel.je_line_num(+))
	 AND (jel.je_header_id = jeh.je_header_id(+))
	 AND (jeh.je_batch_id = jeb.je_batch_id(+));