Query to find invoice number from credit memo

 SELECT
    rcta.customer_trx_id,
    rcta.trx_number,
    rcta.trx_date,
    rctta.name          transaction_type_name,
    rctta.type          transaction_type,
    rcta.previous_customer_trx_id,
    apsa.payment_schedule_id,
    apsa.class,
    araa.applied_customer_trx_id,
    araa.applied_payment_schedule_id,
    rctai.trx_number    invoice_number
FROM
    ra_customer_trx_all             rcta,
    ra_cust_trx_types_all           rctta,
    ar_payment_schedules_all        apsa,
    ar_receivable_applications_all  araa,
    ar_payment_schedules_all        apsai,
    ra_customer_trx_all             rctai
WHERE
        1 = 1
    AND rcta.cust_trx_type_id = rctta.cust_trx_type_id
    AND rcta.org_id = rctta.org_id
    AND rcta.customer_trx_id = apsa.customer_trx_id
    AND rcta.org_id = apsa.org_id
    AND rcta.customer_trx_id = araa.customer_trx_id
    AND rcta.org_id = araa.org_id
    AND apsa.payment_schedule_id = araa.payment_schedule_id
    AND apsa.org_id = araa.org_id
    AND araa.applied_customer_trx_id = apsai.customer_trx_id
    AND araa.applied_payment_schedule_id = apsai.payment_schedule_id
    AND araa.org_id = apsai.org_id
    AND araa.applied_customer_trx_id = rctai.customer_trx_id
    AND araa.org_id = rctai.org_id
    AND rcta.trx_number = '111111111'
    AND apsa.class = 'CM';