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: PA.PA_MC_UPGRADE_RATES

Object Details

Object Name:	PA_MC_UPGRADE_RATES
Object Type:	TABLE
Owner:	PA
FND Design Data:	PA.PA_MC_UPGRADE_RATES
Subobject Name:
Status:	VALID

PA_MC_UPGRADE_RATES caches the rates used by the process to convert open transactions to a given reporting set of books.

Storage Details

Tablespace:	APPS_TS_SEED
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PA_MC_UPGRADE_RATES_U1	NORMAL	UNIQUE	APPS_TS_SEED	FROM_CURRENCY TO_CURRENCY EXCHANGE_DATE RATE_TYPE

Columns

Name	Datatype	Length	Mandatory	Comments
PRIMARY_SET_OF_BOOKS_ID	NUMBER	(15)	Yes	The Unique Identifier for the Primary Set of Books
REPORTING_SET_OF_BOOKS_ID	NUMBER	(15)	Yes	The Unique Identifier for the Reporting set of books
FROM_CURRENCY	VARCHAR2	(15)	Yes	This denotes the Transaction Currency
TO_CURRENCY	VARCHAR2	(15)	Yes	This denotes the Reporting Currency
DENOM_RATE	NUMBER			Denominator Rate
NUM_RATE	NUMBER			Numerator Rate
EXCHANGE_RATE	NUMBER			The effective rate (Numerator/denominator)
EXCHANGE_DATE	DATE			The date on which the rate is obtained
RATE_TYPE	VARCHAR2	(30)		Exchange Rate Type used for getting the rate

Query Text

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


SELECT PRIMARY_SET_OF_BOOKS_ID
,      REPORTING_SET_OF_BOOKS_ID
,      FROM_CURRENCY
,      TO_CURRENCY
,      DENOM_RATE
,      NUM_RATE
,      EXCHANGE_RATE
,      EXCHANGE_DATE
,      RATE_TYPE
FROM PA.PA_MC_UPGRADE_RATES;

Dependencies

[top of page]

PA.PA_MC_UPGRADE_RATES does not reference any database object

PA.PA_MC_UPGRADE_RATES is referenced by following:

APPS: PA_MC_UPGRADE_RATES