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: XLA.XLA_RC_UPGRADE_RATES

Object Details

Object Name:	XLA_RC_UPGRADE_RATES
Object Type:	TABLE
Owner:	XLA
Subobject Name:
Status:	VALID

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
XLA_RC_UPGRADE_RATES_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	RELATIONSHIP_ID UPGRADE_RUN_ID FROM_CURRENCY TO_CURRENCY

Columns

Name	Datatype	Length	Mandatory	Comments
RELATIONSHIP_ID	NUMBER		Yes
UPGRADE_RUN_ID	NUMBER		Yes
FROM_CURRENCY	VARCHAR2	(15)	Yes	Entered Currency Code of the row in Primary Ledger
TO_CURRENCY	VARCHAR2	(15)	Yes	Currency Code of the Secondary/ALC Ledger
DENOMINATOR_RATE	NUMBER			Denominator Rate for currency conversion
NUMERATOR_RATE	NUMBER			Numerator Rate for currency conversion
CONVERSION_RATE	NUMBER			Coversion Rate between the From and To Currencies
PRECISION	NUMBER			Precision. Not used at the moment.
MINIMUM_ACCOUNTABLE_UNIT	NUMBER			Minimum Accountable Unit
CREATION_DATE	DATE		Yes	Standard Who Column
CREATED_BY	NUMBER		Yes	Standard Who Column
LAST_UPDATE_DATE	DATE		Yes	Standard Who Column
LAST_UPDATED_BY	NUMBER		Yes	Standard Who Column
LAST_UPDATE_LOGIN	NUMBER			Standard Who Column

Query Text

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


SELECT RELATIONSHIP_ID
,      UPGRADE_RUN_ID
,      FROM_CURRENCY
,      TO_CURRENCY
,      DENOMINATOR_RATE
,      NUMERATOR_RATE
,      CONVERSION_RATE
,      PRECISION
,      MINIMUM_ACCOUNTABLE_UNIT
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
FROM XLA.XLA_RC_UPGRADE_RATES;

Dependencies

[top of page]

XLA.XLA_RC_UPGRADE_RATES does not reference any database object

XLA.XLA_RC_UPGRADE_RATES is referenced by following:

APPS: XLA_RC_UPGRADE_RATES