VIEW: APPS.JA_AU_ADDITIONS_BOOKS_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'