462: -- o Conversion_type exists,
463: -- o Conversion_rate is not a negative number
464: -- o Inverse_conversion_rate is not a negative number
465: -- o From_Currency and To_Currency:
466: -- a. Currency exists in the FND_CURRENCIES table
467: -- b. Currency is enabled
468: -- c. Currency is not a statistical currency
469: -- d. Currency is not out of date
470: -- e. Currency is not an EMU currency
585: 0, 'EMU_TO_CURRENCY',
586: ''))))))))))))))))))
587: FROM gl_daily_rates_interface ri2,
588: gl_daily_conversion_types ct,
589: fnd_currencies from_curr,
590: fnd_currencies to_curr
591: WHERE ri2.ROWID = ri.ROWID
592: AND ct.user_conversion_type(+) = ri2.user_conversion_type
593: AND from_curr.currency_code(+) = ri2.from_currency
586: ''))))))))))))))))))
587: FROM gl_daily_rates_interface ri2,
588: gl_daily_conversion_types ct,
589: fnd_currencies from_curr,
590: fnd_currencies to_curr
591: WHERE ri2.ROWID = ri.ROWID
592: AND ct.user_conversion_type(+) = ri2.user_conversion_type
593: AND from_curr.currency_code(+) = ri2.from_currency
594: AND to_curr.currency_code(+) = ri2.to_currency)