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: ISC.ISC_DBI_FTE_CURR_RATES

Object Details

Object Name:	ISC_DBI_FTE_CURR_RATES
Object Type:	TABLE
Owner:	ISC
Subobject Name:
Status:	VALID

This Table contains currency conversion rate for freight transportation reports

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	30
PCT Used:

Columns

Name	Datatype	Length	Comments
TRX_CURRENCY_CODE	VARCHAR2	(30)	Transactional currency code
WH_CURRENCY_CODE	VARCHAR2	(30)	Warehouse currency code
CONVERSION_DATE	DATE		Conversion Date
CONVERSION_TYPE_CODE	VARCHAR2	(40)	Conversion Type Code
TRX_WH_RATE	NUMBER		Trx to WH Conversion Rate
WH_PRIM_RATE	NUMBER		WH to primary currency Conversion Rate
WH_SEC_RATE	NUMBER		WH to secondary currency Conversion Rate

Query Text

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


SELECT TRX_CURRENCY_CODE
,      WH_CURRENCY_CODE
,      CONVERSION_DATE
,      CONVERSION_TYPE_CODE
,      TRX_WH_RATE
,      WH_PRIM_RATE
,      WH_SEC_RATE
FROM ISC.ISC_DBI_FTE_CURR_RATES;

Dependencies

[top of page]

ISC.ISC_DBI_FTE_CURR_RATES does not reference any database object

ISC.ISC_DBI_FTE_CURR_RATES is referenced by following:

APPS: ISC_DBI_FTE_CURR_RATES