View: FA_SXL_BOOKS_V

Product:	OFA - Assets
Description:
Implementation/DBA Data:	APPS.FA_SXL_BOOKS_V

View Text

SELECT ROWID ROW_ID
, BOOK_TYPE_CODE
, ASSET_ID
, SALVAGE_VALUE
, ADJUSTED_RATE
, ADJUSTED_COST
, LIFE_IN_MONTHS
, DATE_INEFFECTIVE
, RATE_ADJUSTMENT_FACTOR
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, PERIOD_COUNTER_FULLY_RESERVED
, PERIOD_COUNTER_LIFE_COMPLETE
, ANNUAL_DEPRN_ROUNDING_FLAG
FROM FA_BOOKS
WHERE DATE_INEFFECTIVE IS NULL
AND PERIOD_COUNTER_LIFE_COMPLETE IS NOT NULL
AND SALVAGE_VALUE != 0
AND RECOVERABLE_COST < ADJUSTED_RECOVERABLE_COST
AND PERIOD_COUNTER_FULLY_RESERVED IS NULL
AND RATE_ADJUSTMENT_FACTOR <= 1

Columns