SQL Logic required to derive value for Status Field from Manage Transactions screen

I checked for one of the AR Invoice where status value is showing as "Complete" in application. But in ra_customer_trx_all, I checked and found that there is STATUS_TRX field which is having value as "OP".

Kindly, help to provide the SQL logic which can give the status for the AR Invoice Transaction as showing in the application. For eg: In the screen shot shared below Status is showing as "Complete".

Application Screen: Manage Transactions:

 

Backend value:

Thanks

Vipul