VIEW: APPS.FA_MASS_EXT_RETIREMENTS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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