AP Payments Techinical flow AP , SLA, GL

                      
SELECT AP_CHECKS_PKG.get_posting_status(ACA.CHECK_ID) Accounted_status, ACA.* 
FROM AP_CHECKS_ALL ACA
WHERE 1=1
AND ACA.CHECK_ID = 82531
--AND ACA.CHECK_NUMBER = '8299'

--------------------------------------------------
SELECT POSTED_FLAG Accounted_status, AA.*
FROM AP_INVOICE_PAYMENTS_ALL AA
WHERE AA.CHECK_ID = 82531 

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

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

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

-- Following  below entry created  in SLA with master entry
SELECT  xte.* 
FROM xla.xla_transaction_entities xte
WHERE 1=1
AND xte.entity_code = 'AP_PAYMENTS'
AND xte.application_id = 200 -- PAYABLE
and SOURCE_ID_INT_1 = 82531 --CHECK_ID (AP_CHECKS_ALL)
and xte.transaction_number = '8299' -- CHECK_NUMBER ( AP_CHECKS_ALL)

--------------------------------------------------
SELECT entity_id, aa.*
FROM XLA_AE_HEADERS aa
WHERE 1=1
AND aa.ENTITY_ID = 3278258 --entity_id (xla_transaction_entities)

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

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