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_HR_RETIREMENT_DETAILS

Object Details

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

Individual retirements made as a result of a mass retirement on an asset hierarchy.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
FA_HR_RETIREMENT_DETAILS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	BATCH_ID BOOK_TYPE_CODE ASSET_ID
FA_HR_RETIREMENT_DETAILS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ASSET_ID

Columns

Name	Datatype	Length	Mandatory	Comments
BATCH_ID	NUMBER		Yes	System generated identifier of a batch
BOOK_TYPE_CODE	VARCHAR2	(15)	Yes	Identifier of the Book associated with the Asset
ASSET_ID	NUMBER		Yes	Unique identifier of an asset
DATE_PLACED_IN_SERVICE	DATE		Yes	Date placed in service.
CURRENT_COST	NUMBER		Yes	Asset cost.
COST_RETIRED	NUMBER		Yes	Amount retired.
CURRENT_UNITS	NUMBER			Asset units.
UNITS_RETIRED	NUMBER			Number of units retired.
PRORATE_PERCENT	NUMBER			Percentage to prorate.
RETIREMENT_CONVENTION_CODE	VARCHAR2	(30)		Retirement convention.
STATUS_CODE	VARCHAR2	(2)		Status of the batch: 'P' - Pending, 'C' - Processed, 'R' - Rejected
REJECTION_REASON	VARCHAR2	(240)		Reason the asset line was Rejected
RETIREMENT_ID	NUMBER			Retirement id of record inserted into FA_RETIREMENTS
CREATED_BY	NUMBER		Yes	Standard WHO columns.
CREATION_DATE	DATE		Yes	Standard WHO columns.
LAST_UPDATED_BY	NUMBER		Yes	Standard WHO columns.
LAST_UPDATE_DATE	DATE		Yes	Standard WHO columns.
LAST_UPDATE_LOGIN	NUMBER		Yes	Standard WHO columns.
CONCURRENT_REQUEST_ID	NUMBER			Concurrent request Id of the run which created this record
COST_OF_REMOVAL	NUMBER			Cost of removing the asset
PROCEEDS_OF_SALE	NUMBER			Proceeds from the sale of the asset

Query Text

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


SELECT BATCH_ID
,      BOOK_TYPE_CODE
,      ASSET_ID
,      DATE_PLACED_IN_SERVICE
,      CURRENT_COST
,      COST_RETIRED
,      CURRENT_UNITS
,      UNITS_RETIRED
,      PRORATE_PERCENT
,      RETIREMENT_CONVENTION_CODE
,      STATUS_CODE
,      REJECTION_REASON
,      RETIREMENT_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      CONCURRENT_REQUEST_ID
,      COST_OF_REMOVAL
,      PROCEEDS_OF_SALE
FROM FA.FA_HR_RETIREMENT_DETAILS;

Dependencies

[top of page]

FA.FA_HR_RETIREMENT_DETAILS does not reference any database object

FA.FA_HR_RETIREMENT_DETAILS is referenced by following:

FA: FA_HR_RETIREMENT_DETAILS#