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

TABLE: OKI.OKI_DAILY_RATES

Object Details
Object Name: OKI_DAILY_RATES
Object Type: TABLE
Owner: OKI
FND Design Data: TableOKI.OKI_DAILY_RATES
Subobject Name:
Status: VALID


This table 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 table is populated from the GL_DAILY_RATES table with the latest conversion rate for that currency combination. This means that there will be only one record for any combination of from currency band to currency.
It is maintained by the Load Daily Rates, Contracts Intelligence concurrent manager job.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
OKI_DAILY_RATES_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnFROM_CURRENCY
ColumnTO_CURRENCY
ColumnCONVERSION_RATE
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.
SECURITY_GROUP_ID NUMBER

Used for application hosting.
Query Text

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


SELECT FROM_CURRENCY
,      TO_CURRENCY
,      CONVERSION_RATE
,      CONVERSION_DATE
,      SECURITY_GROUP_ID
FROM OKI.OKI_DAILY_RATES;

Dependencies

[top of page]

OKI.OKI_DAILY_RATES does not reference any database object

OKI.OKI_DAILY_RATES is referenced by following:

SchemaAPPS
SynonymOKI_DAILY_RATES