Query to find invoice transaction type, class and status

 SELECT
    rcta.customer_trx_id,
    rcta.trx_number,
    rcta.trx_date,
    apsa.class,
    apsa.status,
    rctta.name    transaction_type_name,
    rctta.type    transaction_type
FROM
    ra_customer_trx_all       rcta,
    ar_payment_schedules_all  apsa,
    ra_cust_trx_types_all     rctta
WHERE
        1 = 1
    AND apsa.customer_trx_id = rcta.customer_trx_id
    AND rcta.cust_trx_type_id = rctta.cust_trx_type_id
    AND rcta.org_id = rctta.org_id
    AND rcta.trx_number IN ( '33333333')
    AND rcta.org_id = 111
ORDER BY
    rcta.creation_date DESC;