After to run Subledger Accounting (SLA) not impact to GL
How can view unreconciled transactions?
I tried to run the query
7.- select * from xla_ae_lines where ae_header_id in (select ae_header_id from xla_distribution_links where source_distribution_type = 'MTL_TRANSACTION_ACCOUNTS' and source_distribution_id_num_1 in (select inv_sub_ledger_id from mtl_transaction_accounts where transaction_id = '&txnid'))
8.- select * from gl_import_references where gl_sl_link_table = 'XLAJEL' and gl_sl_link_id in (<give the gl_sl_link_id from result of query 7>)
9.- select * from gl_je_lines where je_header_id in (<give the je_header_id from result of query 8>) and je_line_num in ('<result from query 8>')
7.- select * from xla_ae_lines where ae_header_id in (select ae_header_id from xla_distribution_links where source_distribution_type = 'MTL_TRANSACTION_ACCOUNTS' and source_distribution_id_num_1 in (select inv_sub_ledger_id from mtl_transaction_accounts where transaction_id = '&txnid'))
8.- select * from gl_import_references where gl_sl_link_table = 'XLAJEL' and gl_sl_link_id in (<give the gl_sl_link_id from result of query 7>)
9.- select * from gl_je_lines where je_header_id in (<give the je_header_id from result of query 8>) and je_line_num in ('<result from query 8>')
0