Product: | OFA - Assets |
---|---|
Description: | - Retrofitted |
Implementation/DBA Data: | APPS.FA_RETIREMENTS_MRC_V |
SELECT FMCR.SET_OF_BOOKS_ID
, FMCR.RETIREMENT_ID
, FMCR.BOOK_TYPE_CODE
, FMCR.ASSET_ID
, FMCR.TRANSACTION_HEADER_ID_IN
, FMCR.DATE_RETIRED
, FMCR.DATE_EFFECTIVE
, FMCR.COST_RETIRED
, FMCR.STATUS
, FMCR.LAST_UPDATE_DATE
, FMCR.LAST_UPDATED_BY
, FMCR.RETIREMENT_PRORATE_CONVENTION
, FMCR.TRANSACTION_HEADER_ID_OUT
, FMCR.UNITS
, FMCR.COST_OF_REMOVAL
, FMCR.NBV_RETIRED
, FMCR.GAIN_LOSS_AMOUNT
, FMCR.PROCEEDS_OF_SALE
, FMCR.GAIN_LOSS_TYPE_CODE
, FMCR.RETIREMENT_TYPE_CODE
, FMCR.ITC_RECAPTURED
, FMCR.ITC_RECAPTURE_ID
, FMCR.REFERENCE_NUM
, FMCR.SOLD_TO
, FMCR.TRADE_IN_ASSET_ID
, FMCR.STL_METHOD_CODE
, FMCR.STL_LIFE_IN_MONTHS
, FMCR.STL_DEPRN_AMOUNT
, FMCR.CREATED_BY
, FMCR.CREATION_DATE
, FMCR.LAST_UPDATE_LOGIN
, FMCR.ATTRIBUTE1
, FMCR.ATTRIBUTE2
, FMCR.ATTRIBUTE3
, FMCR.ATTRIBUTE4
, FMCR.ATTRIBUTE5
, FMCR.ATTRIBUTE6
, FMCR.ATTRIBUTE7
, FMCR.ATTRIBUTE8
, FMCR.ATTRIBUTE9
, FMCR.ATTRIBUTE10
, FMCR.ATTRIBUTE11
, FMCR.ATTRIBUTE12
, FMCR.ATTRIBUTE13
, FMCR.ATTRIBUTE14
, FMCR.ATTRIBUTE15
, FMCR.ATTRIBUTE_CATEGORY_CODE
, FMCR.REVAL_RESERVE_RETIRED
, FMCR.UNREVALUED_COST_RETIRED
, FMCR.BONUS_RESERVE_RETIRED
, FMCR.RECOGNIZE_GAIN_LOSS
, FMCR.REDUCTION_RATE
, FMCR.RECAPTURE_RESERVE_FLAG
, FMCR.LIMIT_PROCEEDS_FLAG
, FMCR.TERMINAL_GAIN_LOSS
, FMCR.RESERVE_RETIRED
, FMCR.RECAPTURE_AMOUNT
, FMCR.EOFY_RESERVE
FROM FA_MC_RETIREMENTS FMCR
WHERE FMCR.SET_OF_BOOKS_ID = NVL(TO_NUMBER(SUBSTRB(USERENV('CLIENT_INFO')
, 45
, 10))
, -1)