View: FA_RETIREMENTS_WEB_V

Product:	OFA - Assets
Description:	Asset retirement transaction information
Implementation/DBA Data:	APPS.FA_RETIREMENTS_WEB_V

View Text

SELECT RET.ROWID RET_ROWID
, RET.RETIREMENT_ID
, RET.BOOK_TYPE_CODE
, RET.ASSET_ID
, RET.TRANSACTION_HEADER_ID_IN
, RET.DATE_RETIRED
, RET.DATE_EFFECTIVE
, TO_CHAR(RET.COST_RETIRED
, FND_CURRENCY.SAFE_GET_FORMAT_MASK(GLSB.CURRENCY_CODE
, 30)) COST_RETIRED
, RET.STATUS
, RET.LAST_UPDATE_DATE
, RET.LAST_UPDATED_BY
, RET.RETIREMENT_PRORATE_CONVENTION
, RET.TRANSACTION_HEADER_ID_OUT
, RET.UNITS
, TO_CHAR(RET.COST_OF_REMOVAL
, FND_CURRENCY.SAFE_GET_FORMAT_MASK(GLSB.CURRENCY_CODE
, 30)) COST_OF_REMOVAL
, TO_CHAR(RET.NBV_RETIRED
, FND_CURRENCY.SAFE_GET_FORMAT_MASK(GLSB.CURRENCY_CODE
, 30)) NBV_RETIRED
, TO_CHAR(RET.GAIN_LOSS_AMOUNT
, FND_CURRENCY.SAFE_GET_FORMAT_MASK(GLSB.CURRENCY_CODE
, 30)) GAIN_LOSS_AMOUNT
, TO_CHAR(RET.PROCEEDS_OF_SALE
, FND_CURRENCY.SAFE_GET_FORMAT_MASK(GLSB.CURRENCY_CODE
, 30)) PROCEEDS_OF_SALE
, RET.GAIN_LOSS_TYPE_CODE
, RET.RETIREMENT_TYPE_CODE
, TO_CHAR(RET.ITC_RECAPTURED
, FND_CURRENCY.SAFE_GET_FORMAT_MASK(GLSB.CURRENCY_CODE
, 30)) ITC_RECAPTURED
, RET.ITC_RECAPTURE_ID
, RET.REFERENCE_NUM
, RET.SOLD_TO
, RET.TRADE_IN_ASSET_ID
, RET.STL_METHOD_CODE
, RET.STL_LIFE_IN_MONTHS
, TO_CHAR(RET.STL_DEPRN_AMOUNT
, FND_CURRENCY.SAFE_GET_FORMAT_MASK(GLSB.CURRENCY_CODE
, 30)) STL_DEPRN_AMOUNT
, RET.CREATED_BY
, RET.CREATION_DATE
, RET.LAST_UPDATE_LOGIN
, RET.ATTRIBUTE1 RET_ATTRIBUTE1
, RET.ATTRIBUTE2 RET_ATTRIBUTE2
, RET.ATTRIBUTE3 RET_ATTRIBUTE3
, RET.ATTRIBUTE4 RET_ATTRIBUTE4
, RET.ATTRIBUTE5 RET_ATTRIBUTE5
, RET.ATTRIBUTE6 RET_ATTRIBUTE6
, RET.ATTRIBUTE7 RET_ATTRIBUTE7
, RET.ATTRIBUTE8 RET_ATTRIBUTE8
, RET.ATTRIBUTE9 RET_ATTRIBUTE9
, RET.ATTRIBUTE10 RET_ATTRIBUTE10
, RET.ATTRIBUTE11 RET_ATTRIBUTE11
, RET.ATTRIBUTE12 RET_ATTRIBUTE12
, RET.ATTRIBUTE13 RET_ATTRIBUTE13
, RET.ATTRIBUTE14 RET_ATTRIBUTE14
, RET.ATTRIBUTE15 RET_ATTRIBUTE15
, RET.ATTRIBUTE_CATEGORY_CODE RET_ATTRIBUTE_CATEGORY_CODE
, TO_CHAR(RET.REVAL_RESERVE_RETIRED
, FND_CURRENCY.SAFE_GET_FORMAT_MASK(GLSB.CURRENCY_CODE
, 30)) REVAL_RESERVE_RETIRED
, TO_CHAR(RET.UNREVALUED_COST_RETIRED
, FND_CURRENCY.SAFE_GET_FORMAT_MASK(GLSB.CURRENCY_CODE
, 30)) UNREVALUED_COST_RETIRED
, AD.ASSET_NUMBER ASSET_NUMBER
, TO_CHAR(BKS.COST
, FND_CURRENCY.SAFE_GET_FORMAT_MASK(GLSB.CURRENCY_CODE
, 30)) COST
, AH.UNITS CURRENT_UNITS
, TRADE_IN.ASSET_NUMBER TRADE_IN_ASSET_NUMBER
, TRADE_IN.DESCRIPTION TRADE_IN_ASSET_DESC
, TH.TRANSACTION_NAME
, TH.ATTRIBUTE1
, TH.ATTRIBUTE2
, TH.ATTRIBUTE3
, TH.ATTRIBUTE4
, TH.ATTRIBUTE5
, TH.ATTRIBUTE6
, TH.ATTRIBUTE7
, TH.ATTRIBUTE8
, TH.ATTRIBUTE9
, TH.ATTRIBUTE10
, TH.ATTRIBUTE11
, TH.ATTRIBUTE12
, TH.ATTRIBUTE13
, TH.ATTRIBUTE14
, TH.ATTRIBUTE15
, TH.ATTRIBUTE_CATEGORY_CODE
, BC.CURRENT_FISCAL_YEAR
, BC.FISCAL_YEAR_NAME
, FY.START_DATE FY_START_DATE
, FY.END_DATE FY_END_DATE
FROM FA_RETIREMENTS RET
, FA_ADDITIONS AD
, FA_BOOKS BKS
, FA_BOOK_CONTROLS BC
, GL_SETS_OF_BOOKS GLSB
, FA_FISCAL_YEAR FY
, FA_ASSET_HISTORY AH
, FA_ADDITIONS TRADE_IN
, FA_TRANSACTION_HEADERS TH
WHERE AD.ASSET_ID = RET.ASSET_ID
AND BKS.BOOK_TYPE_CODE = RET.BOOK_TYPE_CODE
AND BKS.ASSET_ID = RET.ASSET_ID
AND BKS.TRANSACTION_HEADER_ID_OUT = RET.TRANSACTION_HEADER_ID_IN
AND BKS.DATE_INEFFECTIVE > AH.DATE_EFFECTIVE
AND BKS.DATE_INEFFECTIVE <= NVL(AH.DATE_INEFFECTIVE
, SYSDATE)
AND AH.ASSET_ID = RET.ASSET_ID
AND TRADE_IN.ASSET_ID(+) = RET.TRADE_IN_ASSET_ID
AND TH.TRANSACTION_HEADER_ID = RET.TRANSACTION_HEADER_ID_IN
AND BC.BOOK_TYPE_CODE = RET.BOOK_TYPE_CODE
AND BC.SET_OF_BOOKS_ID = GLSB.SET_OF_BOOKS_ID
AND FY.FISCAL_YEAR_NAME = BC.FISCAL_YEAR_NAME
AND FY.FISCAL_YEAR = BC.CURRENT_FISCAL_YEAR

Columns