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: FA.FA_MC_BOOKS_RATES

Object Details

Object Name:	FA_MC_BOOKS_RATES
Object Type:	TABLE
Owner:	FA
FND Design Data:	OFA.FA_MC_BOOKS_RATES
Subobject Name:
Status:	VALID

FA_MC_BOOKS _RATES stores exchange rate information that Oracle
Assets uses to convert transaction amounts in the primary book to the
reporting currencies in the reporting books. Oracle Assets create a
row in this table for each reporting book for the following asset
transaction types: ADDITION, CIP ADDITION, ADJUSTMENT and CIP
ADJUSTMENT.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
FA_MC_BOOKS_RATES_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	SET_OF_BOOKS_ID TRANSACTION_HEADER_ID INVOICE_TRANSACTION_ID

Columns

Name	Datatype	Length	Mandatory	Comments
SET_OF_BOOKS_ID	NUMBER	(15)	Yes	Reporting set of books identification number for GL sets of books
ASSET_ID	NUMBER	(15)	Yes	Asset identification number
BOOK_TYPE_CODE	VARCHAR2	(30)	Yes	Book name
TRANSACTION_HEADER_ID	NUMBER	(15)		Identification number of the transaction that created this row
INVOICE_TRANSACTION_ID	NUMBER	(15)		Identification number of the invoice transaction that created this row
TRANSACTION_DATE_ENTERED	DATE			Date on which the transaction occurred
COST	NUMBER			Cost of the asset in the primary functional currency
EXCHANGE_RATE	NUMBER		Yes	Exchange rate as of the date on which the transaction occurred
AVG_EXCHANGE_RATE	NUMBER		Yes	Weighted average exchange rate based on the prior cost and current cost of the asset
LAST_UPDATED_BY	NUMBER	(15)		Standard Who column
LAST_UPDATE_DATE	DATE			Standard Who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who column
COMPLETE	VARCHAR2	(1)		Indicates whether transaction amounts in related tables, created by this transaction, are completely converted to the reporting currency

Query Text

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


SELECT SET_OF_BOOKS_ID
,      ASSET_ID
,      BOOK_TYPE_CODE
,      TRANSACTION_HEADER_ID
,      INVOICE_TRANSACTION_ID
,      TRANSACTION_DATE_ENTERED
,      COST
,      EXCHANGE_RATE
,      AVG_EXCHANGE_RATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      COMPLETE
FROM FA.FA_MC_BOOKS_RATES;

Dependencies

[top of page]

FA.FA_MC_BOOKS_RATES does not reference any database object

FA.FA_MC_BOOKS_RATES is referenced by following:

FA: FA_MC_BOOKS_RATES#