View: FA_RETIRED_ASSET_WEB_V

Product:	OFA - Assets
Description:	Information about retired assets
Implementation/DBA Data:	APPS.FA_RETIRED_ASSET_WEB_V

View Text

SELECT RT.RETIREMENT_ID
, RT.TRANSACTION_HEADER_ID_IN
, RT.TRANSACTION_HEADER_ID_OUT
, RT.ASSET_ID
, RT.BOOK_TYPE_CODE
, RT.DATE_RETIRED
, RT.DATE_EFFECTIVE
, RT.STATUS
, RT.UNITS
, RT.RETIREMENT_TYPE_CODE
, RT.RETIREMENT_PRORATE_CONVENTION
, TO_CHAR(RT.COST_RETIRED
, FND_CURRENCY.SAFE_GET_FORMAT_MASK(GLSB.CURRENCY_CODE
, 30)) COST_RETIRED
, TO_CHAR(RT.COST_OF_REMOVAL
, FND_CURRENCY.SAFE_GET_FORMAT_MASK(GLSB.CURRENCY_CODE
, 30)) COST_OF_REMOVAL
, TO_CHAR(RT.NBV_RETIRED
, FND_CURRENCY.SAFE_GET_FORMAT_MASK(GLSB.CURRENCY_CODE
, 30)) NBV_RETIRED
, TO_CHAR(RT.REVAL_RESERVE_RETIRED
, FND_CURRENCY.SAFE_GET_FORMAT_MASK(GLSB.CURRENCY_CODE
, 30)) REVAL_RESERVE_RETIRED
, TO_CHAR(RT.UNREVALUED_COST_RETIRED
, FND_CURRENCY.SAFE_GET_FORMAT_MASK(GLSB.CURRENCY_CODE
, 30)) UNREVALUED_COST_RETIRED
, RT.GAIN_LOSS_TYPE_CODE
, TO_CHAR(RT.GAIN_LOSS_AMOUNT
, FND_CURRENCY.SAFE_GET_FORMAT_MASK(GLSB.CURRENCY_CODE
, 30)) GAIN_LOSS_AMOUNT
, TO_CHAR(RT.PROCEEDS_OF_SALE
, FND_CURRENCY.SAFE_GET_FORMAT_MASK(GLSB.CURRENCY_CODE
, 30)) PROCEEDS_OF_SALE
, RT.STL_METHOD_CODE
, RT.STL_LIFE_IN_MONTHS
, TO_CHAR(RT.STL_DEPRN_AMOUNT
, FND_CURRENCY.SAFE_GET_FORMAT_MASK(GLSB.CURRENCY_CODE
, 30)) STL_DEPRN_AMOUNT
, TO_CHAR(RT.ITC_RECAPTURED
, FND_CURRENCY.SAFE_GET_FORMAT_MASK(GLSB.CURRENCY_CODE
, 30)) ITC_RECAPTURED
, RT.ITC_RECAPTURE_ID
, RT.REFERENCE_NUM
, RT.SOLD_TO
, RT.TRADE_IN_ASSET_ID
, RT.ATTRIBUTE1
, RT.ATTRIBUTE2
, RT.ATTRIBUTE3
, RT.ATTRIBUTE4
, RT.ATTRIBUTE5
, RT.ATTRIBUTE6
, RT.ATTRIBUTE7
, RT.ATTRIBUTE8
, RT.ATTRIBUTE9
, RT.ATTRIBUTE10
, RT.ATTRIBUTE11
, RT.ATTRIBUTE12
, RT.ATTRIBUTE13
, RT.ATTRIBUTE14
, RT.ATTRIBUTE15
, RT.ATTRIBUTE_CATEGORY_CODE
, RT.LAST_UPDATE_DATE
, RT.LAST_UPDATED_BY
, RT.LAST_UPDATE_LOGIN
, RT.CREATED_BY
, RT.CREATION_DATE
, BK.DATE_PLACED_IN_SERVICE
, BK.DATE_EFFECTIVE BOOK_DATE_EFFECTIVE
, BK.DATE_INEFFECTIVE BOOK_DATE_INEFFECTIVE
, BK.DEPRN_START_DATE
, BK.DEPRN_METHOD_CODE
, BK.LIFE_IN_MONTHS
, BK.RATE_ADJUSTMENT_FACTOR
, TO_CHAR(BK.ADJUSTED_COST
, FND_CURRENCY.SAFE_GET_FORMAT_MASK(GLSB.CURRENCY_CODE
, 30)) ADJUSTED_COST
, TO_CHAR(BK.COST
, FND_CURRENCY.SAFE_GET_FORMAT_MASK(GLSB.CURRENCY_CODE
, 30)) COST
, TO_CHAR(BK.ORIGINAL_COST
, FND_CURRENCY.SAFE_GET_FORMAT_MASK(GLSB.CURRENCY_CODE
, 30)) ORIGINAL_COST
, TO_CHAR(BK.SALVAGE_VALUE
, FND_CURRENCY.SAFE_GET_FORMAT_MASK(GLSB.CURRENCY_CODE
, 30)) SALVAGE_VALUE
, BK.PRORATE_CONVENTION_CODE
, BK.PRORATE_DATE
, BK.COST_CHANGE_FLAG
, BK.ADJUSTMENT_REQUIRED_STATUS
, BK.CAPITALIZE_FLAG
, BK.RETIREMENT_PENDING_FLAG
, BK.DEPRECIATE_FLAG
, BK.ITC_AMOUNT_ID
, TO_CHAR(BK.ITC_AMOUNT
, FND_CURRENCY.SAFE_GET_FORMAT_MASK(GLSB.CURRENCY_CODE
, 30)) ITC_AMOUNT
, BK.TAX_REQUEST_ID
, TO_CHAR(BK.ITC_BASIS
, FND_CURRENCY.SAFE_GET_FORMAT_MASK(GLSB.CURRENCY_CODE
, 30)) ITC_BASIS
, BK.ADJUSTED_RATE
, BK.BONUS_RULE
, BK.CEILING_NAME
, TO_CHAR(BK.RECOVERABLE_COST
, FND_CURRENCY.SAFE_GET_FORMAT_MASK(GLSB.CURRENCY_CODE
, 30)) RECOVERABLE_COST
, BK.ADJUSTED_CAPACITY
, BK.FULLY_RSVD_REVALS_COUNTER
, BK.IDLED_FLAG
, BK.PERIOD_COUNTER_CAPITALIZED
, BK.PERIOD_COUNTER_FULLY_RESERVED
, BK.PERIOD_COUNTER_FULLY_RETIRED
, BK.PRODUCTION_CAPACITY
, BK.REVAL_AMORTIZATION_BASIS
, TO_CHAR(BK.REVAL_CEILING
, FND_CURRENCY.SAFE_GET_FORMAT_MASK(GLSB.CURRENCY_CODE
, 30)) REVAL_CEILING
, BK.UNIT_OF_MEASURE
, TO_CHAR(BK.UNREVALUED_COST
, FND_CURRENCY.SAFE_GET_FORMAT_MASK(GLSB.CURRENCY_CODE
, 30)) UNREVALUED_COST
, BK.ANNUAL_DEPRN_ROUNDING_FLAG
, BK.PERCENT_SALVAGE_VALUE
, BK.ALLOWED_DEPRN_LIMIT
, TO_CHAR(BK.ALLOWED_DEPRN_LIMIT_AMOUNT
, FND_CURRENCY.SAFE_GET_FORMAT_MASK(GLSB.CURRENCY_CODE
, 30)) ALLOWED_DEPRN_LIMIT_AMOUNT
, BK.PERIOD_COUNTER_LIFE_COMPLETE
, TO_CHAR(BK.ADJUSTED_RECOVERABLE_COST
, FND_CURRENCY.SAFE_GET_FORMAT_MASK(GLSB.CURRENCY_CODE
, 30)) ADJUSTED_RECOVERABLE_COST
, TH.TRANSACTION_HEADER_ID
, TH.TRANSACTION_TYPE_CODE
, TH.TRANSACTION_DATE_ENTERED
, TH.TRANSACTION_NAME
, TH.TRANSACTION_SUBTYPE
, AD.ASSET_NUMBER
, AD.DESCRIPTION ASSET_DESCRIPTION
, AD.ASSET_TYPE
, AD.TAG_NUMBER
, AD.CURRENT_UNITS
, AD.ASSET_CATEGORY_ID
, AD.ASSET_KEY_CCID
, AD.PROPERTY_TYPE_CODE
, AD.PROPERTY_1245_1250_CODE
, AD.IN_USE_FLAG
, AD.OWNED_LEASED
, AD.NEW_USED
, AD.UNIT_ADJUSTMENT_FLAG
, AD.ADD_COST_JE_FLAG
, AD.MANUFACTURER_NAME
, AD.SERIAL_NUMBER
, AD.MODEL_NUMBER
, CA.CATEGORY_TYPE
, AK.CONCATENATED_SEGMENTS ASSET_KEY
, CK.CONCATENATED_SEGMENTS CATEGORY
FROM FA_CATEGORIES_B CA
, FA_CATEGORIES_B_KFV CK
, FA_ASSET_KEYWORDS_KFV AK
, FA_BOOKS BK
, FA_BOOK_CONTROLS BC
, GL_SETS_OF_BOOKS GLSB
, FA_ADDITIONS AD
, FA_RETIREMENTS RT
, FA_TRANSACTION_HEADERS TH
WHERE RT.ASSET_ID = AD.ASSET_ID
AND RT.ASSET_ID = BK.ASSET_ID
AND RT.BOOK_TYPE_CODE = BK.BOOK_TYPE_CODE
AND RT.BOOK_TYPE_CODE = BC.BOOK_TYPE_CODE
AND BC.SET_OF_BOOKS_ID = GLSB.SET_OF_BOOKS_ID
AND RT.TRANSACTION_HEADER_ID_IN = BK.TRANSACTION_HEADER_ID_OUT
AND RT.TRANSACTION_HEADER_ID_IN = TH.TRANSACTION_HEADER_ID
AND AD.ASSET_CATEGORY_ID = CA.CATEGORY_ID
AND AD.ASSET_KEY_CCID = AK.CODE_COMBINATION_ID(+)
AND AD.ASSET_CATEGORY_ID = CK.CATEGORY_ID

Columns