Tracking Query : AP To GL

Tracking Query : AP To GL 

select *

from ap_invoices_all  aia

where invoice_num='522139585';    --152586

select * from

ap_payment_schedules_all apsa

where invoice_id=152586;

select * 

from xla.xla_transaction_entities xte

where SOURCE_ID_INT_1=152586

and ENTITY_CODE='AP_INVOICES';   --ENTITY_ID=202560

select * from xla_ae_headers xah

where ENTITY_ID=202560;            --AE_HEADER_ID=226364

select * from xla_ae_lines xal

where AE_HEADER_ID=226364

and ACCOUNTING_CLASS_CODE='LIABILITY';         --CODE_COMBINATION_I=38011;

select * from gl_code_combinations

where CODE_COMBINATION_ID=38011;                       --SEGMENT2=2250102

select *

from gl_import_references

where GL_SL_LINK_ID in(397950,397949);                   --JE_HEADER_ID=207073

select * 

from

gl_je_headers

where JE_HEADER_ID=207073;

select *

from gl_je_lines

where JE_HEADER_ID=207073

and je_line_num=2;