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]

TABLE: OKI.OKI_DBI_CURR_CONV

Object Details

Object Name:	OKI_DBI_CURR_CONV
Object Type:	TABLE
Owner:	OKI
Subobject Name:
Status:	VALID

Staging table that identifies the distinct currency conversions used during the base summary fact load

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
OKI_DBI_CURR_CONV_U1	NORMAL	UNIQUE	APPS_TS_INTERFACE	FROM_CURRENCY TO_CURRENCY CURR_CONV_DATE RATE_TYPE CHR_ID

Columns

Name	Datatype	Length	Comments
FROM_CURRENCY	VARCHAR2	(40)	Transactional currency code
TO_CURRENCY	VARCHAR2	(40)	Functional currency code
CURR_CONV_DATE	DATE		Date used to convert from the transactional to the functional currency as well as the functional to the global and secondary global currencies
RATE_TYPE	VARCHAR2	(40)	Rate typed used to convert from the transational currency to the functional currency
RATE_F	NUMBER		Transactional to functional currency conversion rate
RATE_G	NUMBER		Functional to global currency conversion rate
RATE_SG	NUMBER		Functional to secondary global currency conversion rate
CHR_ID	NUMBER		Internal idenitifer for the original contract

Query Text

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


SELECT FROM_CURRENCY
,      TO_CURRENCY
,      CURR_CONV_DATE
,      RATE_TYPE
,      RATE_F
,      RATE_G
,      RATE_SG
,      CHR_ID
FROM OKI.OKI_DBI_CURR_CONV;

Dependencies

[top of page]

OKI.OKI_DBI_CURR_CONV does not reference any database object

OKI.OKI_DBI_CURR_CONV is referenced by following:

APPS: OKI_DBI_CURR_CONV