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_ASSET_HISTORY

Object Details

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

FA_ASSET_HISTORY contains information about asset
reclassifications, capitalizations, unit adjustments, and
partial unit retirements.
.
When you initially add an asset, Oracle Assets inserts one row into
the table. This becomes the "active" row for the asset. When you
use the Additions form to reclassify an asset or perform a unit
adjustment, Oracle Assets marks this row as obsolete and inserts
a new row. If you either reclassify an asset or change its asset
type in the period in which you added the asset, Oracle Assets
simply updates the row, since the transaction has no financial
impact. At any point in time, there is only one "active" row in
the table for an asset, and you can always identify it because it
is the only one whose DATE_INEFFECTIVE is NULL.
.
.
Oracle Assets terminates a row by setting the DATE_INEFFECTIVE and
TRANSACTION_HEADER_ID_OUT to the DATE_EFFECTIVE and
TRANSACTION_HEADER_ID_IN of the new row. This means you can
identify rows affected by the same transaction because they have
the same DATE_EFFECTIVE / DATE_INEFFECTIVE and
TRANSACTION_HEADER_ID_IN / TRANSACTION_HEADER_ID_OUT pairs. For
new rows, TRANSACTION_HEADER_ID_IN is the same as
TRANSACTION_HEADER_ID of the row inserted into
FA_TRANSACTION_HEADERS for the transaction, and DATE_EFFECTIVE is
the system date.
.
.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
FA_ASSET_HISTORY_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	DATE_EFFECTIVE ASSET_ID CATEGORY_ID
FA_ASSET_HISTORY_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ASSET_ID DATE_EFFECTIVE CATEGORY_ID
FA_ASSET_HISTORY_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ASSET_ID TRANSACTION_HEADER_ID_IN TRANSACTION_HEADER_ID_OUT

Columns

Name	Datatype	Length	Mandatory	Comments
ASSET_ID	NUMBER	(15)	Yes	Asset identification number
CATEGORY_ID	NUMBER	(15)	Yes	Identifies the category to which the asset belongs
ASSET_TYPE	VARCHAR2	(11)	Yes	Indicates whether the asset is CIP, capitalized, or expensed
UNITS	NUMBER		Yes	Number of units
DATE_EFFECTIVE	DATE		Yes	Date this record became effective
DATE_INEFFECTIVE	DATE			Date this record became ineffective
TRANSACTION_HEADER_ID_IN	NUMBER	(15)	Yes	Identifies transaction that created row
TRANSACTION_HEADER_ID_OUT	NUMBER	(15)		Identifies transaction that made row obsolete
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	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 ASSET_ID
,      CATEGORY_ID
,      ASSET_TYPE
,      UNITS
,      DATE_EFFECTIVE
,      DATE_INEFFECTIVE
,      TRANSACTION_HEADER_ID_IN
,      TRANSACTION_HEADER_ID_OUT
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
FROM FA.FA_ASSET_HISTORY;

Dependencies

[top of page]

FA.FA_ASSET_HISTORY does not reference any database object

FA.FA_ASSET_HISTORY is referenced by following:

FA: FA_ASSET_HISTORY#