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_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 , RET.COST_RETIRED , RET.STATUS , RET.LAST_UPDATE_DATE , RET.LAST_UPDATED_BY , RET.RETIREMENT_PRORATE_CONVENTION , RET.TRANSACTION_HEADER_ID_OUT , RET.UNITS , RET.COST_OF_REMOVAL , RET.NBV_RETIRED , RET.GAIN_LOSS_AMOUNT , RET.PROCEEDS_OF_SALE , RET.GAIN_LOSS_TYPE_CODE , RET.RETIREMENT_TYPE_CODE , RET.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 , RET.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 , RET.REVAL_RESERVE_RETIRED , RET.UNREVALUED_COST_RETIRED , AD.ASSET_NUMBER ASSET_NUMBER , BKS.COST COST , AH.UNITS CURRENT_UNITS , TRADE_IN.ASSET_NUMBER TRADE_IN_ASSET_NUMBER , ADT.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 , TH.INVOICE_TRANSACTION_ID , BKS.GROUP_ASSET_ID GROUP_ASSET_ID , RET.RECOGNIZE_GAIN_LOSS RECOGNIZE_GAIN_LOSS , RET.RECAPTURE_RESERVE_FLAG RECAPTURE_RESERVE_FLAG , RET.LIMIT_PROCEEDS_FLAG LIMIT_PROCEEDS_FLAG , RET.TERMINAL_GAIN_LOSS TERMINAL_GAIN_LOSS , RET.REDUCTION_RATE REDUCTION_RATE , RET.EOFY_RESERVE EOFY_RESERVE , RET.RESERVE_RETIRED RESERVE_RETIRED , RET.RECAPTURE_AMOUNT RECAPTURE_AMOUNT FROM FA_RETIREMENTS RET , FA_ADDITIONS_B AD , FA_BOOKS BKS , FA_BOOK_CONTROLS BC , FA_FISCAL_YEAR FY , FA_ASSET_HISTORY AH , FA_ADDITIONS_B TRADE_IN , FA_ADDITIONS_TL ADT , 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 FY.FISCAL_YEAR_NAME = BC.FISCAL_YEAR_NAME AND FY.FISCAL_YEAR = BC.CURRENT_FISCAL_YEAR AND ADT.ASSET_ID(+) = TRADE_IN.ASSET_ID AND ADT.LANGUAGE(+) = userenv('LANG')

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
, RET.COST_RETIRED
, RET.STATUS
, RET.LAST_UPDATE_DATE
, RET.LAST_UPDATED_BY
, RET.RETIREMENT_PRORATE_CONVENTION
, RET.TRANSACTION_HEADER_ID_OUT
, RET.UNITS
, RET.COST_OF_REMOVAL
, RET.NBV_RETIRED
, RET.GAIN_LOSS_AMOUNT
, RET.PROCEEDS_OF_SALE
, RET.GAIN_LOSS_TYPE_CODE
, RET.RETIREMENT_TYPE_CODE
, RET.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
, RET.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
, RET.REVAL_RESERVE_RETIRED
, RET.UNREVALUED_COST_RETIRED
, AD.ASSET_NUMBER ASSET_NUMBER
, BKS.COST COST
, AH.UNITS CURRENT_UNITS
, TRADE_IN.ASSET_NUMBER TRADE_IN_ASSET_NUMBER
, ADT.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
, TH.INVOICE_TRANSACTION_ID
, BKS.GROUP_ASSET_ID GROUP_ASSET_ID
, RET.RECOGNIZE_GAIN_LOSS RECOGNIZE_GAIN_LOSS
, RET.RECAPTURE_RESERVE_FLAG RECAPTURE_RESERVE_FLAG
, RET.LIMIT_PROCEEDS_FLAG LIMIT_PROCEEDS_FLAG
, RET.TERMINAL_GAIN_LOSS TERMINAL_GAIN_LOSS
, RET.REDUCTION_RATE REDUCTION_RATE
, RET.EOFY_RESERVE EOFY_RESERVE
, RET.RESERVE_RETIRED RESERVE_RETIRED
, RET.RECAPTURE_AMOUNT RECAPTURE_AMOUNT
FROM FA_RETIREMENTS RET
, FA_ADDITIONS_B AD
, FA_BOOKS BKS
, FA_BOOK_CONTROLS BC
, FA_FISCAL_YEAR FY
, FA_ASSET_HISTORY AH
, FA_ADDITIONS_B TRADE_IN
, FA_ADDITIONS_TL ADT
, 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 FY.FISCAL_YEAR_NAME = BC.FISCAL_YEAR_NAME
AND FY.FISCAL_YEAR = BC.CURRENT_FISCAL_YEAR
AND ADT.ASSET_ID(+) = TRADE_IN.ASSET_ID
AND ADT.LANGUAGE(+) = USERENV('LANG')