DBA Data[Home] [Help] [Dependency Information]

TABLE: FA.FA_MC_MASS_RATES

Object Details
Object Name: FA_MC_MASS_RATES
Object Type: TABLE
Owner: FA
FND Design Data: TableOFA.FA_MC_MASS_RATES
Subobject Name:
Status: VALID


FA_MC_MASS _RATES stores exchange rate information that Oracle Assets
uses during the mass additions posting process.


Storage Details
Tablespace: TablespaceAPPS_TS_INTERFACE
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
FA_MC_MASS_RATES_U1 NORMAL NONUNIQUE TablespaceAPPS_TS_INTERFACE ColumnSET_OF_BOOKS_ID
ColumnMASS_ADDITION_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
MASS_ADDITION_ID NUMBER (15) Yes Unique identification number of the mass addition
PARENT_MASS_ADDITION_ID NUMBER (15)
Identifies the mass addition into which you merged this mass addition
FIXED_ASSETS_COST NUMBER

Cost of the asset, in the primary functional currency, in Oracle Assets
EXCHANGE_RATE NUMBER

Exchange rate used to convert the cost of the asset to the reporting currency
CREATED_BY NUMBER (15)
Standard Who column
CREATION_DATE DATE

Standard Who column
LAST_UPDATED_BY NUMBER (15)
Standard Who column
LAST_UPDATE_DATE DATE

Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
Query Text

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


SELECT SET_OF_BOOKS_ID
,      MASS_ADDITION_ID
,      PARENT_MASS_ADDITION_ID
,      FIXED_ASSETS_COST
,      EXCHANGE_RATE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM FA.FA_MC_MASS_RATES;

Dependencies

[top of page]

FA.FA_MC_MASS_RATES does not reference any database object

FA.FA_MC_MASS_RATES is referenced by following:

SchemaFA
ViewFA_MC_MASS_RATES#