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: ENI.ENI_CURRENCY_CONV_RATES_STG

Object Details

Object Name:	ENI_CURRENCY_CONV_RATES_STG
Object Type:	TABLE
Owner:	ENI
Subobject Name:
Status:	VALID

Item Cost Rates table which stores the primary and secondary currency conversion rates for distinct currency code and effective date combinations on item cost transactions.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Comments
EFFECTIVE_DATE	DATE		Date on which the cost is applicable
CURRENCY_CODE	VARCHAR2	(15)	Currency code for cost.
PRIMARY_RATE	NUMBER		Primary Currency conversation rate for the currency on a certain date.
SECONDARY_RATE	NUMBER		Secondary Currency conversation rate for the currency on a certain date.

Query Text

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


SELECT EFFECTIVE_DATE
,      CURRENCY_CODE
,      PRIMARY_RATE
,      SECONDARY_RATE
FROM ENI.ENI_CURRENCY_CONV_RATES_STG;

Dependencies

[top of page]

ENI.ENI_CURRENCY_CONV_RATES_STG does not reference any database object

ENI.ENI_CURRENCY_CONV_RATES_STG is referenced by following:

APPS: ENI_CURRENCY_CONV_RATES_STG