eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.FA_RETIREMENTS_WEB_V

Source

View Text - Preformatted


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

View Text - HTML Formatted

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