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_DISTRIBUTION_HISTORY

Object Details

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

FA_DISTRIBUTION_HISTORY contains information about the
employee,
location, and Accounting Flexfield values you assign to your
assets. The depreciation program uses this information to
allocate depreciation expense and the Transfers form uses it to
maintain an audit trail of asset transfers.
.
When you initially assign distributions to an asset using the
Transfers form, Oracle Assets inserts one row into this table for
each distribution. Whenever you transfer, retire, reinstate, or
reclassify an asset, Oracle Assets marks the appropriate rows as
obsolete and creates new rows that reflect changes in assigned
units, employees, general ledger depreciation expense account, or
location.
.
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.
.
When you perform a full retirement, Oracle Assets updates the
asset's current distribution lines with the RETIREMENT_ID from
FA_RETIREMENTS so you can easily determine which retirement
affected the rows. Oracle Assets stores the number of units
retired as a negative number in TRANSACTION_UNITS. The sum of
TRANSACTION_UNITS for the retired distribution lines matches the
UNITS column in FA_RETIREMENTS, except the signs are opposite.
.
When you perform a partial unit retirement, Oracle Assets updates
only the rows affected by the retirement. For any distribution
lines that have units remaining after the retirement, Oracle Assets
inserts new rows into this table where UNITS_ASSIGNED is reduced
by the units retired, and terminates the old rows.
.
Partial cost retirements do not affect this table.
.
If you reinstate a full retirement, Oracle Assets inserts new rows
that are the same as those that were active when you retired
the asset, except that they have a different DISTRIBUTION_ID,
TRANSACTION_HEADER_ID_IN and DATE_EFFECTIVE. If you reinstate a
partial unit retirement, Oracle Assets inserts new rows that are
the same as those that were active except UNITS_ASSIGNED
increases by the units retired and the rows have a new
DISTRIBUTION_ID, TRANSACTION_HEADER_ID_IN and DATE_EFFECTIVE.
.
Oracle Assets terminates the previous rows by setting
TRANSACTION_HEADER_ID_OUT to the
TRANSACTION_HEADER_ID of the reinstated transaction.
.
RETIREMENT_ID identifies all the rows affected by a retirement.
.
TRANSACTION_UNITS is the number of units affected by each
retirement, reinstatement, transfer, addition or reclassification
transaction.
.
.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
FA_DISTRIBUTION_HISTORY_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	DISTRIBUTION_ID
FA_DISTRIBUTION_HISTORY_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TRANSACTION_HEADER_ID_IN
FA_DISTRIBUTION_HISTORY_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ASSET_ID BOOK_TYPE_CODE
FA_DISTRIBUTION_HISTORY_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TRANSACTION_HEADER_ID_OUT
FA_DISTRIBUTION_HISTORY_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	RETIREMENT_ID BOOK_TYPE_CODE
FA_DISTRIBUTION_HISTORY_N5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CODE_COMBINATION_ID
FA_DISTRIBUTION_HISTORY_N6	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	LOCATION_ID
FA_DISTRIBUTION_HISTORY_N7	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ASSIGNED_TO

Columns

Name	Datatype	Length	Mandatory	Comments
DISTRIBUTION_ID	NUMBER	(15)	Yes	Unique distribution identification number
BOOK_TYPE_CODE	VARCHAR2	(15)	Yes	Book name
ASSET_ID	NUMBER	(15)	Yes	Asset identification number
UNITS_ASSIGNED	NUMBER		Yes	Number of units assigned to the distribution
DATE_EFFECTIVE	DATE		Yes	Date the distribution became active
CODE_COMBINATION_ID	NUMBER	(15)	Yes	Depreciation expense account identification number
LOCATION_ID	NUMBER	(15)	Yes	Location flexfield identification number
TRANSACTION_HEADER_ID_IN	NUMBER	(15)	Yes	Identifies the transaction that created the distribution
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who column
DATE_INEFFECTIVE	DATE			Date the distribution became inactive
ASSIGNED_TO	NUMBER	(15)		Employee identification number
TRANSACTION_HEADER_ID_OUT	NUMBER	(15)		Identifies the transaction that made the distribution obsolete
TRANSACTION_UNITS	NUMBER			Number of units involved in the transaction. Negative for the row from which the units were transferred away or retired. Positive for the row to which the units were transferred or added.
RETIREMENT_ID	NUMBER	(15)		Identifies a retirement
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who column
CAPITAL_ADJ_ACCOUNT_CCID	NUMBER	(15)
GENERAL_FUND_ACCOUNT_CCID	NUMBER	(15)

Query Text

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


SELECT DISTRIBUTION_ID
,      BOOK_TYPE_CODE
,      ASSET_ID
,      UNITS_ASSIGNED
,      DATE_EFFECTIVE
,      CODE_COMBINATION_ID
,      LOCATION_ID
,      TRANSACTION_HEADER_ID_IN
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      DATE_INEFFECTIVE
,      ASSIGNED_TO
,      TRANSACTION_HEADER_ID_OUT
,      TRANSACTION_UNITS
,      RETIREMENT_ID
,      LAST_UPDATE_LOGIN
,      CAPITAL_ADJ_ACCOUNT_CCID
,      GENERAL_FUND_ACCOUNT_CCID
FROM FA.FA_DISTRIBUTION_HISTORY;

Dependencies

[top of page]

FA.FA_DISTRIBUTION_HISTORY does not reference any database object

FA.FA_DISTRIBUTION_HISTORY is referenced by following:

FA: FA_DISTRIBUTION_HISTORY#