VIEW: APPS.FA_RETIRED_ASSET_WEB_V

Source

View Text - Preformatted

SELECT RT.RETIREMENT_ID , RT.TRANSACTION_HEADER_ID_IN , RT.TRANSACTION_HEADER_ID_OUT , RT.ASSET_ID , RT.BOOK_TYPE_CODE , RT.DATE_RETIRED , RT.DATE_EFFECTIVE , RT.STATUS , RT.UNITS , RT.RETIREMENT_TYPE_CODE , RT.RETIREMENT_PRORATE_CONVENTION , TO_CHAR(RT.COST_RETIRED, FND_CURRENCY.SAFE_GET_FORMAT_MASK(GLSB.CURRENCY_CODE,30)) COST_RETIRED , TO_CHAR(RT.COST_OF_REMOVAL, FND_CURRENCY.SAFE_GET_FORMAT_MASK(GLSB.CURRENCY_CODE,30)) COST_OF_REMOVAL , TO_CHAR(RT.NBV_RETIRED, FND_CURRENCY.SAFE_GET_FORMAT_MASK(GLSB.CURRENCY_CODE,30)) NBV_RETIRED , TO_CHAR(RT.REVAL_RESERVE_RETIRED, FND_CURRENCY.SAFE_GET_FORMAT_MASK(GLSB.CURRENCY_CODE,30)) REVAL_RESERVE_RETIRED , TO_CHAR(RT.UNREVALUED_COST_RETIRED, FND_CURRENCY.SAFE_GET_FORMAT_MASK(GLSB.CURRENCY_CODE,30)) UNREVALUED_COST_RETIRED , RT.GAIN_LOSS_TYPE_CODE , TO_CHAR(RT.GAIN_LOSS_AMOUNT, FND_CURRENCY.SAFE_GET_FORMAT_MASK(GLSB.CURRENCY_CODE,30)) GAIN_LOSS_AMOUNT , TO_CHAR(RT.PROCEEDS_OF_SALE, FND_CURRENCY.SAFE_GET_FORMAT_MASK(GLSB.CURRENCY_CODE,30)) PROCEEDS_OF_SALE , RT.STL_METHOD_CODE , RT.STL_LIFE_IN_MONTHS , TO_CHAR(RT.STL_DEPRN_AMOUNT, FND_CURRENCY.SAFE_GET_FORMAT_MASK(GLSB.CURRENCY_CODE,30)) STL_DEPRN_AMOUNT , TO_CHAR(RT.ITC_RECAPTURED, FND_CURRENCY.SAFE_GET_FORMAT_MASK(GLSB.CURRENCY_CODE,30)) ITC_RECAPTURED , RT.ITC_RECAPTURE_ID , RT.REFERENCE_NUM , RT.SOLD_TO , RT.TRADE_IN_ASSET_ID , RT.ATTRIBUTE1 , RT.ATTRIBUTE2 , RT.ATTRIBUTE3 , RT.ATTRIBUTE4 , RT.ATTRIBUTE5 , RT.ATTRIBUTE6 , RT.ATTRIBUTE7 , RT.ATTRIBUTE8 , RT.ATTRIBUTE9 , RT.ATTRIBUTE10 , RT.ATTRIBUTE11 , RT.ATTRIBUTE12 , RT.ATTRIBUTE13 , RT.ATTRIBUTE14 , RT.ATTRIBUTE15 , RT.ATTRIBUTE_CATEGORY_CODE , RT.LAST_UPDATE_DATE , RT.LAST_UPDATED_BY , RT.LAST_UPDATE_LOGIN , RT.CREATED_BY , RT.CREATION_DATE , BK.DATE_PLACED_IN_SERVICE , BK.DATE_EFFECTIVE BOOK_DATE_EFFECTIVE , BK.DATE_INEFFECTIVE BOOK_DATE_INEFFECTIVE , BK.DEPRN_START_DATE , BK.DEPRN_METHOD_CODE , BK.LIFE_IN_MONTHS , BK.RATE_ADJUSTMENT_FACTOR , TO_CHAR(BK.ADJUSTED_COST, FND_CURRENCY.SAFE_GET_FORMAT_MASK(GLSB.CURRENCY_CODE,30)) ADJUSTED_COST , TO_CHAR(BK.COST, FND_CURRENCY.SAFE_GET_FORMAT_MASK(GLSB.CURRENCY_CODE,30)) COST , TO_CHAR(BK.ORIGINAL_COST, FND_CURRENCY.SAFE_GET_FORMAT_MASK(GLSB.CURRENCY_CODE,30)) ORIGINAL_COST , TO_CHAR(BK.SALVAGE_VALUE, FND_CURRENCY.SAFE_GET_FORMAT_MASK(GLSB.CURRENCY_CODE,30)) SALVAGE_VALUE , BK.PRORATE_CONVENTION_CODE , BK.PRORATE_DATE , BK.COST_CHANGE_FLAG , BK.ADJUSTMENT_REQUIRED_STATUS , BK.CAPITALIZE_FLAG , BK.RETIREMENT_PENDING_FLAG , BK.DEPRECIATE_FLAG , BK.ITC_AMOUNT_ID , TO_CHAR(BK.ITC_AMOUNT, FND_CURRENCY.SAFE_GET_FORMAT_MASK(GLSB.CURRENCY_CODE,30)) ITC_AMOUNT , BK.TAX_REQUEST_ID , TO_CHAR(BK.ITC_BASIS, FND_CURRENCY.SAFE_GET_FORMAT_MASK(GLSB.CURRENCY_CODE,30)) ITC_BASIS , BK.ADJUSTED_RATE , BK.BONUS_RULE , BK.CEILING_NAME , TO_CHAR(BK.RECOVERABLE_COST, FND_CURRENCY.SAFE_GET_FORMAT_MASK(GLSB.CURRENCY_CODE,30)) RECOVERABLE_COST , BK.ADJUSTED_CAPACITY , BK.FULLY_RSVD_REVALS_COUNTER , BK.IDLED_FLAG , BK.PERIOD_COUNTER_CAPITALIZED , BK.PERIOD_COUNTER_FULLY_RESERVED , BK.PERIOD_COUNTER_FULLY_RETIRED , BK.PRODUCTION_CAPACITY , BK.REVAL_AMORTIZATION_BASIS , TO_CHAR(BK.REVAL_CEILING, FND_CURRENCY.SAFE_GET_FORMAT_MASK(GLSB.CURRENCY_CODE,30)) REVAL_CEILING , BK.UNIT_OF_MEASURE , TO_CHAR(BK.UNREVALUED_COST, FND_CURRENCY.SAFE_GET_FORMAT_MASK(GLSB.CURRENCY_CODE,30)) UNREVALUED_COST , BK.ANNUAL_DEPRN_ROUNDING_FLAG , BK.PERCENT_SALVAGE_VALUE , BK.ALLOWED_DEPRN_LIMIT , TO_CHAR(BK.ALLOWED_DEPRN_LIMIT_AMOUNT, FND_CURRENCY.SAFE_GET_FORMAT_MASK(GLSB.CURRENCY_CODE,30)) ALLOWED_DEPRN_LIMIT_AMOUNT , BK.PERIOD_COUNTER_LIFE_COMPLETE , TO_CHAR(BK.ADJUSTED_RECOVERABLE_COST, FND_CURRENCY.SAFE_GET_FORMAT_MASK(GLSB.CURRENCY_CODE,30)) ADJUSTED_RECOVERABLE_COST , TH.TRANSACTION_HEADER_ID , TH.TRANSACTION_TYPE_CODE , TH.TRANSACTION_DATE_ENTERED , TH.TRANSACTION_NAME , TH.TRANSACTION_SUBTYPE , AD.ASSET_NUMBER , AD.DESCRIPTION ASSET_DESCRIPTION , AD.ASSET_TYPE , AD.TAG_NUMBER , AD.CURRENT_UNITS , AD.ASSET_CATEGORY_ID , AD.ASSET_KEY_CCID , AD.PROPERTY_TYPE_CODE , AD.PROPERTY_1245_1250_CODE , AD.IN_USE_FLAG , AD.OWNED_LEASED , AD.NEW_USED , AD.UNIT_ADJUSTMENT_FLAG , AD.ADD_COST_JE_FLAG , AD.MANUFACTURER_NAME , AD.SERIAL_NUMBER , AD.MODEL_NUMBER , CA.CATEGORY_TYPE , AK.CONCATENATED_SEGMENTS ASSET_KEY , CK.CONCATENATED_SEGMENTS CATEGORY FROM FA_CATEGORIES_B CA, FA_CATEGORIES_B_KFV CK, FA_ASSET_KEYWORDS_KFV AK, FA_BOOKS BK, FA_BOOK_CONTROLS BC, GL_SETS_OF_BOOKS GLSB, FA_ADDITIONS AD, FA_RETIREMENTS RT, FA_TRANSACTION_HEADERS TH WHERE RT.ASSET_ID = AD.ASSET_ID AND RT.ASSET_ID = BK.ASSET_ID AND RT.BOOK_TYPE_CODE = BK.BOOK_TYPE_CODE AND RT.BOOK_TYPE_CODE = BC.BOOK_TYPE_CODE AND BC.SET_OF_BOOKS_ID = GLSB.SET_OF_BOOKS_ID AND RT.TRANSACTION_HEADER_ID_IN = BK.TRANSACTION_HEADER_ID_OUT AND RT.TRANSACTION_HEADER_ID_IN = TH.TRANSACTION_HEADER_ID AND AD.ASSET_CATEGORY_ID = CA.CATEGORY_ID AND AD.ASSET_KEY_CCID = AK.CODE_COMBINATION_ID(+) AND AD.ASSET_CATEGORY_ID = CK.CATEGORY_ID

View Text - HTML Formatted

SELECT RT.RETIREMENT_ID
, RT.TRANSACTION_HEADER_ID_IN
, RT.TRANSACTION_HEADER_ID_OUT
, RT.ASSET_ID
, RT.BOOK_TYPE_CODE
, RT.DATE_RETIRED
, RT.DATE_EFFECTIVE
, RT.STATUS
, RT.UNITS
, RT.RETIREMENT_TYPE_CODE
, RT.RETIREMENT_PRORATE_CONVENTION
, TO_CHAR(RT.COST_RETIRED
, FND_CURRENCY.SAFE_GET_FORMAT_MASK(GLSB.CURRENCY_CODE
, 30)) COST_RETIRED
, TO_CHAR(RT.COST_OF_REMOVAL
, FND_CURRENCY.SAFE_GET_FORMAT_MASK(GLSB.CURRENCY_CODE
, 30)) COST_OF_REMOVAL
, TO_CHAR(RT.NBV_RETIRED
, FND_CURRENCY.SAFE_GET_FORMAT_MASK(GLSB.CURRENCY_CODE
, 30)) NBV_RETIRED
, TO_CHAR(RT.REVAL_RESERVE_RETIRED
, FND_CURRENCY.SAFE_GET_FORMAT_MASK(GLSB.CURRENCY_CODE
, 30)) REVAL_RESERVE_RETIRED
, TO_CHAR(RT.UNREVALUED_COST_RETIRED
, FND_CURRENCY.SAFE_GET_FORMAT_MASK(GLSB.CURRENCY_CODE
, 30)) UNREVALUED_COST_RETIRED
, RT.GAIN_LOSS_TYPE_CODE
, TO_CHAR(RT.GAIN_LOSS_AMOUNT
, FND_CURRENCY.SAFE_GET_FORMAT_MASK(GLSB.CURRENCY_CODE
, 30)) GAIN_LOSS_AMOUNT
, TO_CHAR(RT.PROCEEDS_OF_SALE
, FND_CURRENCY.SAFE_GET_FORMAT_MASK(GLSB.CURRENCY_CODE
, 30)) PROCEEDS_OF_SALE
, RT.STL_METHOD_CODE
, RT.STL_LIFE_IN_MONTHS
, TO_CHAR(RT.STL_DEPRN_AMOUNT
, FND_CURRENCY.SAFE_GET_FORMAT_MASK(GLSB.CURRENCY_CODE
, 30)) STL_DEPRN_AMOUNT
, TO_CHAR(RT.ITC_RECAPTURED
, FND_CURRENCY.SAFE_GET_FORMAT_MASK(GLSB.CURRENCY_CODE
, 30)) ITC_RECAPTURED
, RT.ITC_RECAPTURE_ID
, RT.REFERENCE_NUM
, RT.SOLD_TO
, RT.TRADE_IN_ASSET_ID
, RT.ATTRIBUTE1
, RT.ATTRIBUTE2
, RT.ATTRIBUTE3
, RT.ATTRIBUTE4
, RT.ATTRIBUTE5
, RT.ATTRIBUTE6
, RT.ATTRIBUTE7
, RT.ATTRIBUTE8
, RT.ATTRIBUTE9
, RT.ATTRIBUTE10
, RT.ATTRIBUTE11
, RT.ATTRIBUTE12
, RT.ATTRIBUTE13
, RT.ATTRIBUTE14
, RT.ATTRIBUTE15
, RT.ATTRIBUTE_CATEGORY_CODE
, RT.LAST_UPDATE_DATE
, RT.LAST_UPDATED_BY
, RT.LAST_UPDATE_LOGIN
, RT.CREATED_BY
, RT.CREATION_DATE
, BK.DATE_PLACED_IN_SERVICE
, BK.DATE_EFFECTIVE BOOK_DATE_EFFECTIVE
, BK.DATE_INEFFECTIVE BOOK_DATE_INEFFECTIVE
, BK.DEPRN_START_DATE
, BK.DEPRN_METHOD_CODE
, BK.LIFE_IN_MONTHS
, BK.RATE_ADJUSTMENT_FACTOR
, TO_CHAR(BK.ADJUSTED_COST
, FND_CURRENCY.SAFE_GET_FORMAT_MASK(GLSB.CURRENCY_CODE
, 30)) ADJUSTED_COST
, TO_CHAR(BK.COST
, FND_CURRENCY.SAFE_GET_FORMAT_MASK(GLSB.CURRENCY_CODE
, 30)) COST
, TO_CHAR(BK.ORIGINAL_COST
, FND_CURRENCY.SAFE_GET_FORMAT_MASK(GLSB.CURRENCY_CODE
, 30)) ORIGINAL_COST
, TO_CHAR(BK.SALVAGE_VALUE
, FND_CURRENCY.SAFE_GET_FORMAT_MASK(GLSB.CURRENCY_CODE
, 30)) SALVAGE_VALUE
, BK.PRORATE_CONVENTION_CODE
, BK.PRORATE_DATE
, BK.COST_CHANGE_FLAG
, BK.ADJUSTMENT_REQUIRED_STATUS
, BK.CAPITALIZE_FLAG
, BK.RETIREMENT_PENDING_FLAG
, BK.DEPRECIATE_FLAG
, BK.ITC_AMOUNT_ID
, TO_CHAR(BK.ITC_AMOUNT
, FND_CURRENCY.SAFE_GET_FORMAT_MASK(GLSB.CURRENCY_CODE
, 30)) ITC_AMOUNT
, BK.TAX_REQUEST_ID
, TO_CHAR(BK.ITC_BASIS
, FND_CURRENCY.SAFE_GET_FORMAT_MASK(GLSB.CURRENCY_CODE
, 30)) ITC_BASIS
, BK.ADJUSTED_RATE
, BK.BONUS_RULE
, BK.CEILING_NAME
, TO_CHAR(BK.RECOVERABLE_COST
, FND_CURRENCY.SAFE_GET_FORMAT_MASK(GLSB.CURRENCY_CODE
, 30)) RECOVERABLE_COST
, BK.ADJUSTED_CAPACITY
, BK.FULLY_RSVD_REVALS_COUNTER
, BK.IDLED_FLAG
, BK.PERIOD_COUNTER_CAPITALIZED
, BK.PERIOD_COUNTER_FULLY_RESERVED
, BK.PERIOD_COUNTER_FULLY_RETIRED
, BK.PRODUCTION_CAPACITY
, BK.REVAL_AMORTIZATION_BASIS
, TO_CHAR(BK.REVAL_CEILING
, FND_CURRENCY.SAFE_GET_FORMAT_MASK(GLSB.CURRENCY_CODE
, 30)) REVAL_CEILING
, BK.UNIT_OF_MEASURE
, TO_CHAR(BK.UNREVALUED_COST
, FND_CURRENCY.SAFE_GET_FORMAT_MASK(GLSB.CURRENCY_CODE
, 30)) UNREVALUED_COST
, BK.ANNUAL_DEPRN_ROUNDING_FLAG
, BK.PERCENT_SALVAGE_VALUE
, BK.ALLOWED_DEPRN_LIMIT
, TO_CHAR(BK.ALLOWED_DEPRN_LIMIT_AMOUNT
, FND_CURRENCY.SAFE_GET_FORMAT_MASK(GLSB.CURRENCY_CODE
, 30)) ALLOWED_DEPRN_LIMIT_AMOUNT
, BK.PERIOD_COUNTER_LIFE_COMPLETE
, TO_CHAR(BK.ADJUSTED_RECOVERABLE_COST
, FND_CURRENCY.SAFE_GET_FORMAT_MASK(GLSB.CURRENCY_CODE
, 30)) ADJUSTED_RECOVERABLE_COST
, TH.TRANSACTION_HEADER_ID
, TH.TRANSACTION_TYPE_CODE
, TH.TRANSACTION_DATE_ENTERED
, TH.TRANSACTION_NAME
, TH.TRANSACTION_SUBTYPE
, AD.ASSET_NUMBER
, AD.DESCRIPTION ASSET_DESCRIPTION
, AD.ASSET_TYPE
, AD.TAG_NUMBER
, AD.CURRENT_UNITS
, AD.ASSET_CATEGORY_ID
, AD.ASSET_KEY_CCID
, AD.PROPERTY_TYPE_CODE
, AD.PROPERTY_1245_1250_CODE
, AD.IN_USE_FLAG
, AD.OWNED_LEASED
, AD.NEW_USED
, AD.UNIT_ADJUSTMENT_FLAG
, AD.ADD_COST_JE_FLAG
, AD.MANUFACTURER_NAME
, AD.SERIAL_NUMBER
, AD.MODEL_NUMBER
, CA.CATEGORY_TYPE
, AK.CONCATENATED_SEGMENTS ASSET_KEY
, CK.CONCATENATED_SEGMENTS CATEGORY
FROM FA_CATEGORIES_B CA
, FA_CATEGORIES_B_KFV CK
, FA_ASSET_KEYWORDS_KFV AK
, FA_BOOKS BK
, FA_BOOK_CONTROLS BC
, GL_SETS_OF_BOOKS GLSB
, FA_ADDITIONS AD
, FA_RETIREMENTS RT
, FA_TRANSACTION_HEADERS TH
WHERE RT.ASSET_ID = AD.ASSET_ID
AND RT.ASSET_ID = BK.ASSET_ID
AND RT.BOOK_TYPE_CODE = BK.BOOK_TYPE_CODE
AND RT.BOOK_TYPE_CODE = BC.BOOK_TYPE_CODE
AND BC.SET_OF_BOOKS_ID = GLSB.SET_OF_BOOKS_ID
AND RT.TRANSACTION_HEADER_ID_IN = BK.TRANSACTION_HEADER_ID_OUT
AND RT.TRANSACTION_HEADER_ID_IN = TH.TRANSACTION_HEADER_ID
AND AD.ASSET_CATEGORY_ID = CA.CATEGORY_ID
AND AD.ASSET_KEY_CCID = AK.CODE_COMBINATION_ID(+)
AND AD.ASSET_CATEGORY_ID = CK.CATEGORY_ID