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.

[Home] [Help]

View: FA_MASS_EXT_RETIREMENTS_V

Product:	OFA - Assets
Description:
Implementation/DBA Data:	APPS.FA_MASS_EXT_RETIREMENTS_V

View Text

SELECT EXT.ROWID
, EXT.MASS_EXTERNAL_RETIRE_ID
, EXT.BATCH_NAME
, EXT.BOOK_TYPE_CODE
, EXT.ASSET_ID
, EXT.DATE_RETIRED
, EXT.TRANSACTION_NAME
, EXT.REVIEW_STATUS
, EXT.DATE_EFFECTIVE
, EXT.COST_RETIRED
, EXT.RETIREMENT_PRORATE_CONVENTION
, EXT.UNITS
, EXT.COST_OF_REMOVAL
, EXT.PROCEEDS_OF_SALE
, EXT.RETIREMENT_TYPE_CODE
, EXT.REFERENCE_NUM
, EXT.SOLD_TO
, EXT.TRADE_IN_ASSET_ID
, EXT.STL_METHOD_CODE
, EXT.STL_LIFE_IN_MONTHS
, EXT.STL_DEPRN_AMOUNT
, EXT.LAST_UPDATE_LOGIN
, EXT.CALC_GAIN_LOSS_FLAG
, AD.ASSET_NUMBER ASSET_NUMBER
, BKS.COST COST
, AH.UNITS CURRENT_UNITS
, TRADE_IN.ASSET_NUMBER TRADE_IN_ASSET_NUMBER
, TRADE_IN.DESCRIPTION TRADE_IN_ASSET_DESC
, BC.CURRENT_FISCAL_YEAR
, BC.FISCAL_YEAR_NAME
, FY.START_DATE FY_START_DATE
, FY.END_DATE FY_END_DATE
, EXT.TH_ATTRIBUTE_CATEGORY
, EXT.TH_ATTRIBUTE1
, EXT.TH_ATTRIBUTE2
, EXT.TH_ATTRIBUTE3
, EXT.TH_ATTRIBUTE4
, EXT.TH_ATTRIBUTE5
, EXT.TH_ATTRIBUTE6
, EXT.TH_ATTRIBUTE7
, EXT.TH_ATTRIBUTE8
, EXT.TH_ATTRIBUTE9
, EXT.TH_ATTRIBUTE10
, EXT.TH_ATTRIBUTE11
, EXT.TH_ATTRIBUTE12
, EXT.TH_ATTRIBUTE13
, EXT.TH_ATTRIBUTE14
, EXT.TH_ATTRIBUTE15
, EXT.ATTRIBUTE_CATEGORY
, EXT.ATTRIBUTE1
, EXT.ATTRIBUTE2
, EXT.ATTRIBUTE3
, EXT.ATTRIBUTE4
, EXT.ATTRIBUTE5
, EXT.ATTRIBUTE6
, EXT.ATTRIBUTE7
, EXT.ATTRIBUTE8
, EXT.ATTRIBUTE9
, EXT.ATTRIBUTE10
, EXT.ATTRIBUTE11
, EXT.ATTRIBUTE12
, EXT.ATTRIBUTE13
, EXT.ATTRIBUTE14
, EXT.ATTRIBUTE15
, EXT.RECOGNIZE_GAIN_LOSS
FROM FA_MASS_EXT_RETIREMENTS EXT
, FA_ADDITIONS AD
, FA_BOOKS BKS
, FA_BOOK_CONTROLS BC
, FA_FISCAL_YEAR FY
, FA_ASSET_HISTORY AH
, FA_ADDITIONS TRADE_IN
WHERE AD.ASSET_ID = EXT.ASSET_ID
AND BKS.BOOK_TYPE_CODE = EXT.BOOK_TYPE_CODE
AND BKS.ASSET_ID = EXT.ASSET_ID
AND BKS.DATE_INEFFECTIVE IS NULL
AND AH.ASSET_ID = EXT.ASSET_ID
AND AH.DATE_EFFECTIVE IN (SELECT MAX(AH2.DATE_EFFECTIVE)
FROM FA_ASSET_HISTORY AH2
WHERE AH2.ASSET_ID = EXT.ASSET_ID)
AND TRADE_IN.ASSET_ID(+) = EXT.TRADE_IN_ASSET_ID
AND BC.BOOK_TYPE_CODE = EXT.BOOK_TYPE_CODE
AND FY.FISCAL_YEAR_NAME = BC.FISCAL_YEAR_NAME
AND FY.FISCAL_YEAR = BC.CURRENT_FISCAL_YEAR

Columns

Name
RET_ROWID
MASS_EXTERNAL_RETIRE_ID
BATCH_NAME
BOOK_TYPE_CODE
ASSET_ID
DATE_RETIRED
TRANSACTION_NAME
REVIEW_STATUS
DATE_EFFECTIVE
COST_RETIRED
RETIREMENT_PRORATE_CONVENTION
UNITS
COST_OF_REMOVAL
PROCEEDS_OF_SALE
RETIREMENT_TYPE_CODE
REFERENCE_NUM
SOLD_TO
TRADE_IN_ASSET_ID
STL_METHOD_CODE
STL_LIFE_IN_MONTHS
STL_DEPRN_AMOUNT
LAST_UPDATE_LOGIN
CALC_GAIN_LOSS_FLAG
ASSET_NUMBER
COST
CURRENT_UNITS
TRADE_IN_ASSET_NUMBER
TRADE_IN_ASSET_DESC
CURRENT_FISCAL_YEAR
FISCAL_YEAR_NAME
FY_START_DATE
FY_END_DATE
ATTRIBUTE_CATEGORY_CODE
ATTRIBUTE1
ATTRIBUTE2
ATTRIBUTE3
ATTRIBUTE4
ATTRIBUTE5
ATTRIBUTE6
ATTRIBUTE7
ATTRIBUTE8
ATTRIBUTE9
ATTRIBUTE10
ATTRIBUTE11
ATTRIBUTE12
ATTRIBUTE13
ATTRIBUTE14
ATTRIBUTE15
RET_ATTRIBUTE_CATEGORY_CODE
RET_ATTRIBUTE1
RET_ATTRIBUTE2
RET_ATTRIBUTE3
RET_ATTRIBUTE4
RET_ATTRIBUTE5
RET_ATTRIBUTE6
RET_ATTRIBUTE7
RET_ATTRIBUTE8
RET_ATTRIBUTE9
RET_ATTRIBUTE10
RET_ATTRIBUTE11
RET_ATTRIBUTE12
RET_ATTRIBUTE13
RET_ATTRIBUTE14
RET_ATTRIBUTE15
RECOGNIZE_GAIN_LOSS