VIEW: APPS.FAFV_ASSET_BKS

Source

View Text - Preformatted

SELECT BK.TRANSACTION_HEADER_ID_IN , BK.DATE_PLACED_IN_SERVICE , BK.DEPRN_START_DATE , BK.DEPRN_METHOD_CODE , BK.LIFE_IN_MONTHS , BK.COST , BK.ORIGINAL_COST , BK.SALVAGE_VALUE , BK.PRORATE_CONVENTION_CODE , BK.PRORATE_DATE , BK.DEPRECIATE_FLAG , BK.ITC_AMOUNT_ID , BK.ITC_AMOUNT , BK.ITC_BASIS , BK.BASIC_RATE , BK.ADJUSTED_RATE , BK.BONUS_RULE , BK.CEILING_NAME , BK.RECOVERABLE_COST , BK.PRODUCTION_CAPACITY , BK.REVAL_CEILING , BK.UNIT_OF_MEASURE , BK.UNREVALUED_COST , BK.PERCENT_SALVAGE_VALUE , BK.ALLOWED_DEPRN_LIMIT_AMOUNT , BK.BOOK_TYPE_CODE , BK.ASSET_ID , AD.ASSET_NUMBER , BK.FULLY_RSVD_REVALS_COUNTER , BK.PERIOD_COUNTER_CAPITALIZED , DP1.PERIOD_NAME , BK.PERIOD_COUNTER_FULLY_RESERVED , DP2.PERIOD_NAME , BK.PERIOD_COUNTER_FULLY_RETIRED , DP3.PERIOD_NAME , BK.PERIOD_COUNTER_LIFE_COMPLETE , DP4.PERIOD_NAME , BK.LAST_UPDATE_DATE , BK.LAST_UPDATED_BY FROM FA_BOOKS BK, FA_ADDITIONS AD, FA_DEPRN_PERIODS DP1, FA_DEPRN_PERIODS DP2, FA_DEPRN_PERIODS DP3, FA_DEPRN_PERIODS DP4 WHERE BK.TRANSACTION_HEADER_ID_OUT IS NULL AND BK.DATE_INEFFECTIVE IS NULL AND BK.ASSET_ID = AD.ASSET_ID AND BK.BOOK_TYPE_CODE = DP1.BOOK_TYPE_CODE (+) AND BK.BOOK_TYPE_CODE = DP2.BOOK_TYPE_CODE (+) AND BK.BOOK_TYPE_CODE = DP3.BOOK_TYPE_CODE (+) AND BK.BOOK_TYPE_CODE = DP4.BOOK_TYPE_CODE (+) AND BK.PERIOD_COUNTER_CAPITALIZED = DP1.PERIOD_COUNTER (+) AND BK.PERIOD_COUNTER_FULLY_RESERVED = DP2.PERIOD_COUNTER (+) AND BK.PERIOD_COUNTER_FULLY_RETIRED = DP3.PERIOD_COUNTER (+) AND BK.PERIOD_COUNTER_LIFE_COMPLETE = DP4.PERIOD_COUNTER (+) WITH READ ONLY

View Text - HTML Formatted

SELECT BK.TRANSACTION_HEADER_ID_IN
, BK.DATE_PLACED_IN_SERVICE
, BK.DEPRN_START_DATE
, BK.DEPRN_METHOD_CODE
, BK.LIFE_IN_MONTHS
, BK.COST
, BK.ORIGINAL_COST
, BK.SALVAGE_VALUE
, BK.PRORATE_CONVENTION_CODE
, BK.PRORATE_DATE
, BK.DEPRECIATE_FLAG
, BK.ITC_AMOUNT_ID
, BK.ITC_AMOUNT
, BK.ITC_BASIS
, BK.BASIC_RATE
, BK.ADJUSTED_RATE
, BK.BONUS_RULE
, BK.CEILING_NAME
, BK.RECOVERABLE_COST
, BK.PRODUCTION_CAPACITY
, BK.REVAL_CEILING
, BK.UNIT_OF_MEASURE
, BK.UNREVALUED_COST
, BK.PERCENT_SALVAGE_VALUE
, BK.ALLOWED_DEPRN_LIMIT_AMOUNT
, BK.BOOK_TYPE_CODE
, BK.ASSET_ID
, AD.ASSET_NUMBER
, BK.FULLY_RSVD_REVALS_COUNTER
, BK.PERIOD_COUNTER_CAPITALIZED
, DP1.PERIOD_NAME
, BK.PERIOD_COUNTER_FULLY_RESERVED
, DP2.PERIOD_NAME
, BK.PERIOD_COUNTER_FULLY_RETIRED
, DP3.PERIOD_NAME
, BK.PERIOD_COUNTER_LIFE_COMPLETE
, DP4.PERIOD_NAME
, BK.LAST_UPDATE_DATE
, BK.LAST_UPDATED_BY
FROM FA_BOOKS BK
, FA_ADDITIONS AD
, FA_DEPRN_PERIODS DP1
, FA_DEPRN_PERIODS DP2
, FA_DEPRN_PERIODS DP3
, FA_DEPRN_PERIODS DP4
WHERE BK.TRANSACTION_HEADER_ID_OUT IS NULL
AND BK.DATE_INEFFECTIVE IS NULL
AND BK.ASSET_ID = AD.ASSET_ID
AND BK.BOOK_TYPE_CODE = DP1.BOOK_TYPE_CODE (+)
AND BK.BOOK_TYPE_CODE = DP2.BOOK_TYPE_CODE (+)
AND BK.BOOK_TYPE_CODE = DP3.BOOK_TYPE_CODE (+)
AND BK.BOOK_TYPE_CODE = DP4.BOOK_TYPE_CODE (+)
AND BK.PERIOD_COUNTER_CAPITALIZED = DP1.PERIOD_COUNTER (+)
AND BK.PERIOD_COUNTER_FULLY_RESERVED = DP2.PERIOD_COUNTER (+)
AND BK.PERIOD_COUNTER_FULLY_RETIRED = DP3.PERIOD_COUNTER (+)
AND BK.PERIOD_COUNTER_LIFE_COMPLETE = DP4.PERIOD_COUNTER (+) WITH READ ONLY