Tracking Query For Payment

Tracking Query For Payment 

select *

from ap_invoices_all  aia

where invoice_num='166/2022-23';--89083

select * from ap_invoice_payments_all aipa

where invoice_id=89083;

Select  * from ap_checks_all

where CHECK_NUMBER='12043';--check_id=184320

select * from ap_invoice_payments_all aipa

where check_id=184320;

174353

select * from xla.xla_transaction_entities

where SOURCE_ID_INT_1=184320

and ENTITY_CODE='AP_PAYMENTS'; --ENTITY_ID=243066;--

select * from xla_ae_headers

where ENTITY_ID=243066; -- event_id=286569;--AE_HEADER_ID=205682

select * from xla_ae_lines

where AE_HEADER_ID=295449

and ACCOUNTING_CLASS_CODE='LIABILITY'; --CODE_COMBINATION_ID=61020--GL_SL_LINK_ID=342015--ACCOUNTING_CLASS_CODE=EXPENSE

select * from gl_code_combinations

where CODE_COMBINATION_ID=61020;--SEGMENT2=6410101

select *

from gl_import_references

where GL_SL_LINK_ID=507370;--JE_HEADER_ID=186378

select * 

from

gl_je_headers

where JE_HEADER_ID=281217;--JE_HEADER_ID=281217

select *

from gl_je_lines

where JE_HEADER_ID=281217

and JE_LINE_NUM='2';