AP INVOICE SUB-LEDGER & GL Tracking Queries

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

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

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

SELECT *

FROM AP_INVOICES_ALL

WHERE INVOICE_ID=45

SELECT *

FROM XLA_TRANSACTION_ENTITIES

WHERE SOURCE_ID_INT_1=45

AND ENTITY_CODE='AP_INVOICES'  --ENTITY_ID=21001 

   --APPLICATION_ID=200  

SELECT *

FROM XLA_AE_HEADERS

WHERE ENTITY_ID=21001 

AND APPLICATION_ID=200 --AE_HEADER_ID=38187 

        --APPLICATION_ID=200 

        --ENTITY_ID=21001

        --EVENT_ID=16003

        --LEDGER_ID=300000001830022  

SELECT *

FROM XLA_AE_LINES

WHERE AE_HEADER_ID=38187

AND APPLICATION_ID=200  

AND ACCOUNTING_CLASS_CODE='LIABILITY' 

                                                                    --CODE_COMBINATION_ID = 300000001832042 

    --GL_SL_LINK_ID = 93371

SELECT *

FROM XLA_EVENTS

WHERE EVENT_ID=16003

AND APPLICATION_ID=200  --SEGMENT2 = 9999

SELECT *

FROM GL_CODE_COMBINATIONS

WHERE CODE_COMBINATION_ID = 300000001832042 

SELECT *

FROM GL_IMPORT_REFERENCES

WHERE GL_SL_LINK_ID =93371 --JE_HEADER_ID = 21001

        --JE_LINE_NUM = 6

        --JE_BATCH_ID = 27001

SELECT * 

FROM

GL_JE_HEADERS

WHERE JE_HEADER_ID=21001 --LEDGER_ID = 300000001830022

        --LEGAL_ENTITY_ID = 300000001829016,

SELECT * 

FROM

GL_JE_LINES

WHERE JE_HEADER_ID=21001

AND JE_LINE_NUM = 6

SELECT *

FROM GL_JE_BATCHES

WHERE JE_BATCH_ID = 27001