QUERY TO CONVERT SUPPLIER INVOICE AMOUNT INTO COMMON CURRENCY VALUE BASED ON DAILY RATES

Dear Team,

We are using Oracle EBS 12.2.9 VERSION.

We have multiple ledgers implemented each having its own based currency like EUR, USD, etc.

If AP Invoice is enter in respective ledger currency, we want to convert that foreign currency invoice amount into one common currency amount and invoke AP Invoice approval rule based on converted common currency amount value.

Please let me know how we can right a query to fetch exchange rate from daily exchange rates table and match with ap invoice table supplier invoice amount currency to convert that amount into common currency and invoke AP Invoice approval rule.