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: BIM.BIM_I_MKT_RATES

Object Details

Object Name:	BIM_I_MKT_RATES
Object Type:	TABLE
Owner:	BIM
Subobject Name:
Status:	VALID

Rate table for marketing facts

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Comments
TC_CODE	VARCHAR2	(30)	Transaction Currency Code
PRIM_CONVERSION_RATE	NUMBER		Primary Conversion Rate
SEC_CONVERSION_RATE	NUMBER		Secondary Conversion Rate
TRX_DATE	DATE		Transaction Date

Query Text

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


SELECT TC_CODE
,      PRIM_CONVERSION_RATE
,      SEC_CONVERSION_RATE
,      TRX_DATE
FROM BIM.BIM_I_MKT_RATES;

Dependencies

[top of page]

BIM.BIM_I_MKT_RATES does not reference any database object

BIM.BIM_I_MKT_RATES is referenced by following:

APPS: BIM_I_MKT_RATES