AR Lockbox Queries

select * from apps.ar_transmissions_all
where org_id = XX
and transmission_name = 'BANK_XXXX_14290534'

select * from apps.ar_payments_interface_all
where transmission_request_id = XXX --- Get the transmission_request_id from above query
--- Need to check the status column for errors

select * from apps.AR_BATCHES_ALL
where TRANSMISSION_REQUEST_ID = XXX
-- Get the batchid here using transmission_request_id

select * from apps.ar_interim_cash_receipts_all
where batch_id = XXX
-- Check for any stuck receipts, normally this table should be empty otherwise period will not be closed

select * from apps.ar_cash_Receipt_history_all
where batch_id = XXX
-- Get the batch_id from AR_BATCHES_ALL table
-- To get all the receipts created under this batch
-- Take the event_id to get the GL Posting details

select * from apps.ar_cash_Receipts_all
where cash_Receipt_id = XXX
-- Get the receipt details, based on the cash_Receipt_id from history table

select * from apps.ar_receivable_applications_all
where cash_Receipt_id = XXX
-- To get the receipt application details