AP to GL - Tables

AP to GL
------------
Invoice Header:
select * from ap_invoices_all
where invoice_num ='INV1'; -- Copy the value for Invoice_id for future rerfrence 1615220

Invoice Line :
select * from ap_invoice_lines_all
where invoice_id=1615300;

Invoice Distributions :
select * from ap_invoice_distributions_all
where invoice_id=1615300;

SLA Tables :
select * from XLA.xla_transaction_entities
where source_id_int_1=1615300
and transaction_number='INV1'; -- From this table copy value for Entity id 5849176
-- 
SELECT * FROM XLA_AE_HEADERS
WHERE ENTITY_ID=5849177;  --- From this table copy value Event id 582978337 and ae_header_id value 126276903
--
select * from xla_events
WHERE EVENT_ID=5849177;
--
select * from xla_ae_lines
WHERE AE_HEADER_ID=13000516;
--


SELECT *
from gl_import_references gir
where gir.gl_sl_link_id in
(select gl_sl_link_id from xla_ae_lines
WHERE AE_HEADER_ID=13000516); -- from this table you will get detail for je_header_id, je_line_num, je_batch_id

--
select * from gl_je_batches
where je_batch_id= 4857124;
--
select * from gl_je_headers
where je_batch_id= 4857124 --je_header_id=7510235

--
select * from gl_je_lines
where je_header_id=7510235
--and je_line_num in (9619,6734);
--
 
select
gjh.name Journal_name,
gjb.name Batch_name,
gjl.description Line_desc,
gjc.je_category_name,
gjs.je_source_name,
xl.entered_dr,
xl.entered_cr,
xl.accounted_dr,
xl.accounted_cr
from gl_import_references gir,
gl_je_headers gjh,
gl_je_batches gjb,
gl_je_lines gjl,
xla_ae_lines XL,
gl_je_categories gjc,
gl_je_sources gjs
where gir.gl_sl_link_id in
(select gl_sl_link_id from xla_ae_lines
WHERE AE_HEADER_ID=13000516)
and gir.je_batch_id=gir.je_batch_id
and gjh.je_header_id=gir.je_header_id
and gjl.je_line_num=gir.je_line_num
and gjl.je_header_id=gjh.je_header_id
and gjh.je_batch_id=gjb.je_batch_id
and gjh.actual_flag='A'
--AND gjh.status='P'
and xl.gl_sl_link_id=gir.gl_sl_link_id
and gjh.je_category=gjc.je_category_name
and gjs.je_source_name=gjh.je_source    ;