Product: | JA - Asia/Pacific Localizations |
---|---|
Description: | - Retrofitted |
Implementation/DBA Data: | APPS.JA_AU_ADDITIONS_BOOKS_V |
SELECT B.ORIGINAL_COST
, B.COST
, B.DATE_PLACED_IN_SERVICE
, B.BOOK_TYPE_CODE
, A.ASSET_ID
, A.ASSET_NUMBER
, A.TAG_NUMBER
, A.DESCRIPTION
, A.ASSET_CATEGORY_ID
, A.ATTRIBUTE_CATEGORY_CODE
, A.ASSET_KEY_CCID
, A.ASSET_TYPE
, A.MANUFACTURER_NAME
, A.MODEL_NUMBER
, A.SERIAL_NUMBER
, A.CURRENT_UNITS
, B.SALVAGE_VALUE
, B.RECOVERABLE_COST
, B.ADJUSTED_RATE
, B.CEILING_NAME
, B.BONUS_RULE
, B.DEPRN_METHOD_CODE
, B.LIFE_IN_MONTHS
, B.PRORATE_DATE
, B.DEPRN_START_DATE
, B.DEPRECIATE_FLAG
, B.RATE_ADJUSTMENT_FACTOR
, B.REVAL_AMORTIZATION_BASIS
, B.PRODUCTION_CAPACITY
, B.LAST_UPDATE_LOGIN
, B.LAST_UPDATED_BY
, B.LAST_UPDATE_DATE
, R.DATE_RETIRED
FROM FA_BOOKS B
, FA_ADDITIONS A
, FA_RETIREMENTS R
WHERE B.ASSET_ID = A.ASSET_ID
AND R.ASSET_ID (+) = B.ASSET_ID
AND R.BOOK_TYPE_CODE(+) = B.BOOK_TYPE_CODE
AND B.DATE_INEFFECTIVE IS NULL
AND NVL(B.DEPRECIATE_FLAG
, 'ZZZ') = 'YES'
AND NVL(A.PROPERTY_TYPE_CODE
, 'ZZZ') <> 'DIV 10D'