AP INVOICE PAYMENT SUB-LEDGER & GL TRACKING

 ==============================================================

++++++++ AP INVOICE PAYMENT SUB-LEDGER & GL TRACKING +++++++++

==============================================================

SELECT *

FROM AP_INVOICES_ALL

WHERE INVOICE_ID=45

SELECT * FROM AP_INVOICE_PAYMENTS_ALL AIPA

WHERE INVOICE_ID=45 --CHECK_ID=300000692044585

SELECT  * FROM AP_CHECKS_ALL

WHERE CHECK_ID=300000692044585 --CHECK_ID=300000692044585

         --CHECK_NUMBER=12275

SELECT *

FROM XLA_TRANSACTION_ENTITIES

WHERE SOURCE_ID_INT_1=300000692044585

AND ENTITY_CODE='AP_PAYMENTS'  --ENTITY_ID=14418398 

               --APPLICATION_ID=200  

SELECT *

FROM XLA_AE_HEADERS

WHERE ENTITY_ID=14418398 

AND APPLICATION_ID=200 --AE_HEADER_ID=7213035 

        --APPLICATION_ID=200 

        --ENTITY_ID=14418398

        --EVENT_ID=11664092

        --LEDGER_ID=300000001830022  

SELECT *

FROM XLA_AE_LINES

WHERE AE_HEADER_ID=7213035

AND APPLICATION_ID=200  

AND ACCOUNTING_CLASS_CODE='LIABILITY' 

--CODE_COMBINATION_ID = 300000001832042 

--GL_SL_LINK_ID IN (23757501,23757503,23757504,23757505,23757506,23757507,23757508,23757509,23757510,23757511)

SELECT *

FROM XLA_EVENTS

WHERE EVENT_ID=11664092

AND APPLICATION_ID=200

SELECT *

FROM GL_CODE_COMBINATIONS

WHERE CODE_COMBINATION_ID = 300000001832042 

SELECT *

FROM GL_IMPORT_REFERENCES

WHERE GL_SL_LINK_ID IN (23757501,23757503,23757504,23757505,23757506,23757507,23757508,23757509,23757510,23757511)

--JE_HEADER_ID = 4161338

--JE_LINE_NUM IN (1,2)

--JE_BATCH_ID = 6949259

SELECT * 

FROM

GL_JE_HEADERS

WHERE JE_HEADER_ID=4161338 --LEDGER_ID = 300000001830022

        --LEGAL_ENTITY_ID = 300000001829016,

SELECT * 

FROM

GL_JE_LINES

WHERE JE_HEADER_ID=4161338

AND JE_LINE_NUM IN (1,2)

SELECT *

FROM GL_JE_BATCHES

WHERE JE_BATCH_ID = 6949259