Purchase Invoice Technical flow AP , SLA to GL

SELECT    AP_INVOICES_PKG.GET_POSTING_STATUS( AIA.INVOICE_ID) "Accounted Status"     
,APPS.AP_INVOICES_PKG.GET_APPROVAL_STATUS (
             AIA.INVOICE_ID
            ,AIA.INVOICE_AMOUNT
            ,AIA.PAYMENT_STATUS_FLAG
            ,AIA.INVOICE_TYPE_LOOKUP_CODE

            ) Approval_Status -- Invoice Staus
,AIA.*
FROM AP_INVOICES_ALL AIA
WHERE AIA.INVOICE_ID = 221309 
--AND T.INVOICE_NUM = 'TEST-IFTIKHAR'

----------------------------------------------------

SELECT    AP_INVOICES_PKG.GET_POSTING_STATUS( t.INVOICE_ID) "Accounted Status"      ,T.*
FROM AP_INVOICE_LINES_ALL T
WHERE T.INVOICE_ID = 221309 
--AND T.INVOICE_NUM = 'TEST-IFTIKHAR'

----------------------------------------------------

SELECT AP_INVOICES_PKG.GET_POSTING_STATUS( D.INVOICE_ID) "Accounting Status" ,accounting_event_id,MATCH_STATUS_FLAG ,D.*
FROM AP_INVOICE_DISTRIBUTIONS_ALL D
WHERE D.INVOICE_ID = 221309

----------------------------------------------------
SELECT *
FROM ap_payment_schedules_all AA
WHERE AA.INVOICE_ID = 221309 

----------------------------------------------------
Please Run the following process :    **** Transfer Journal Entries to GL ***

----------------------------------------------------


----  Accounting Table (Create Accounting Process ) SLA -------------------------

--Create accounting

-- Following  below entry created  in SLA with master entry
SELECT entity_id, xte.* 
FROM xla.xla_transaction_entities xte
WHERE 1=1
AND xte.entity_code = 'AP_INVOICES'
AND xte.application_id = 200 -- payable
and SOURCE_ID_INT_1 = 221309 --INVOICE_ID (AP_INVOICES_ALL)
and xte.transaction_number = 'IHG-TEST' -- INVOICE_NUM ( AP_INVOICES_ALL)

----------------------------------------------------

SELECT entity_id, aa.*
FROM XLA_AE_HEADERS aa
WHERE 1=1
AND aa.ENTITY_ID = 3278257 --entity_id (xla_transaction_entities)
--WHERE EVENT_ID = 3347721 -- accounting_event_id (AP_INVOICE_DISTRIBUTIONS_ALL)

----------------------------------------------------

SELECT *
FROM XLA_AE_LINES INV
where inv.ae_header_id = 4957029 --ae_header_id (XLA_AE_HEADERS)