eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

VIEW: APPS.OKI_DAILY_RATES_V

Object Details

Object Name:	OKI_DAILY_RATES_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	OKI.OKI_DAILY_RATES_V
Subobject Name:
Status:	VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.

This View holds the conversion rate data for all the currency combinations for the conversion type specified by the OKI_DEFAULT_CONVERSION_TYPE profile option. This information is used to perform conversions from the transaction currency to the set of books currency and the base currency.
This view isis based on table OKI_DAILY_RATES

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
FROM_CURRENCY	VARCHAR2	(15)	Yes	The currency from which one is converting.
TO_CURRENCY	VARCHAR2	(15)	Yes	The currency to which one is converting.
CONVERSION_RATE	NUMBER		Yes	The rate to use to convert the currencies.
CONVERSION_DATE	DATE		Yes	The date for the conversion rate.

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT FROM_CURRENCY
,      TO_CURRENCY
,      CONVERSION_RATE
,      CONVERSION_DATE
FROM APPS.OKI_DAILY_RATES_V;

Dependencies

[top of page]

APPS.OKI_DAILY_RATES_V references the following:

APPS: OKI_DAILY_RATES

APPS.OKI_DAILY_RATES_V is not referenced by any database object