Query to find the functional and usd amount for the ar invoice

 SELECT
    hca.account_number                                                       customer_number,
    hp.party_name                                                            customer_name,
    hca.attribute5                                                           customer_key,
    rcta.trx_number,
    rcta.trx_date,
    ar.amount_due_original,
    round(ar.amount_due_original * nvl(ar.exchange_rate, 1), 2)              functional_amount,
   --  ar.*
    round(ar.amount_due_original * decode(rcta.invoice_currency_code, 'USD', 1, nvl((
        SELECT
            gld.conversion_rate
        FROM
            gl_daily_rates gld
        WHERE
                gld.from_currency = ar.invoice_currency_code
            AND gld.to_currency = 'USD'
            AND gld.conversion_type = 'Corporate'
            AND trunc(rcta.trx_date) = trunc(gld.conversion_date)
            AND ROWNUM = 1
    ),
                                                                                    1)),
          2)                                                                 usd_amount
FROM
    hz_parties                hp,
    hz_cust_accounts          hca,
    ra_customer_trx_all       rcta,
    ar_payment_schedules_all  ar
WHERE
        1 = 1
    AND hp.party_id = hca.party_id
    AND rcta.bill_to_customer_id = hca.cust_account_id
    AND rcta.customer_trx_id = ar.customer_trx_id
    AND ar.class IN ( 'INV', 'CM', 'DM' )
    AND hp.status = 'A'
    AND hca.status = 'A'
    AND hp.party_type = 'ORGANIZATION'
    AND rcta.trx_date BETWEEN '01-JUL-2025' AND '30-JUN-2026'
    --AND rcta.trx_number = '40047438'
    AND hca.account_number IN ( '13357' );-- '1416594' );