VIEW: APPS.FA_RETIREMENTS_MRC_V

Source

View Text - Preformatted

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)

View Text - HTML Formatted

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)