Product: | OFA - Assets |
---|---|
Description: | Selects active financial information for an asset in a given book |
Implementation/DBA Data: | APPS.FA_BOOKS_V |
SELECT BK.ROWID ROW_ID
, BK.BOOK_TYPE_CODE
, BK.ASSET_ID
, BK.DATE_PLACED_IN_SERVICE
, BK.DATE_EFFECTIVE
, BK.DEPRN_START_DATE
, BK.DEPRN_METHOD_CODE
, BK.LIFE_IN_MONTHS
, BK.RATE_ADJUSTMENT_FACTOR
, BK.ADJUSTED_COST
, BK.COST
, BK.ORIGINAL_COST
, BK.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.LAST_UPDATE_DATE
, BK.LAST_UPDATED_BY
, BK.DATE_INEFFECTIVE
, BK.TRANSACTION_HEADER_ID_IN
, BK.TRANSACTION_HEADER_ID_OUT
, BK.ITC_AMOUNT_ID
, BK.ITC_AMOUNT
, BK.RETIREMENT_ID
, BK.TAX_REQUEST_ID
, BK.ITC_BASIS
, BK.BASIC_RATE
, BK.ADJUSTED_RATE
, BK.BONUS_RULE
, BK.CEILING_NAME
, BK.RECOVERABLE_COST
, BK.ADJUSTED_RECOVERABLE_COST
, BK.LAST_UPDATE_LOGIN
, 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.PERIOD_COUNTER_LIFE_COMPLETE
, BK.PRODUCTION_CAPACITY
, BK.REVAL_AMORTIZATION_BASIS
, BK.REVAL_CEILING
, BK.UNIT_OF_MEASURE
, BK.UNREVALUED_COST
, BK.ANNUAL_DEPRN_ROUNDING_FLAG
, BK.PERCENT_SALVAGE_VALUE
, BK.ALLOWED_DEPRN_LIMIT
, BK.ALLOWED_DEPRN_LIMIT_AMOUNT
, DECODE ( BC.ALLOW_REVAL_FLAG
, 'YES'
, 'Y'
, 'N') ALLOW_REVAL_FLAG
, MTH.RATE_SOURCE_RULE
, MTH.DEPRN_BASIS_RULE
, BK.GLOBAL_ATTRIBUTE1
, BK.GLOBAL_ATTRIBUTE2
, BK.GLOBAL_ATTRIBUTE3
, BK.GLOBAL_ATTRIBUTE4
, BK.GLOBAL_ATTRIBUTE5
, BK.GLOBAL_ATTRIBUTE6
, BK.GLOBAL_ATTRIBUTE7
, BK.GLOBAL_ATTRIBUTE8
, BK.GLOBAL_ATTRIBUTE9
, BK.GLOBAL_ATTRIBUTE10
, BK.GLOBAL_ATTRIBUTE11
, BK.GLOBAL_ATTRIBUTE12
, BK.GLOBAL_ATTRIBUTE13
, BK.GLOBAL_ATTRIBUTE14
, BK.GLOBAL_ATTRIBUTE15
, BK.GLOBAL_ATTRIBUTE16
, BK.GLOBAL_ATTRIBUTE17
, BK.GLOBAL_ATTRIBUTE18
, BK.GLOBAL_ATTRIBUTE19
, BK.GLOBAL_ATTRIBUTE20
, BK.GLOBAL_ATTRIBUTE_CATEGORY
, BK.SHORT_FISCAL_YEAR_FLAG
, BK.CONVERSION_DATE
, BK.ORIGINAL_DEPRN_START_DATE
, BK.FORMULA_FACTOR
, BK.GROUP_ASSET_ID
, BK.SUPER_GROUP_ID
, BK.REDUCTION_RATE
, BK.REDUCE_ADDITION_FLAG
, BK.REDUCE_ADJUSTMENT_FLAG
, BK.REDUCE_RETIREMENT_FLAG
, BK.OVER_DEPRECIATE_OPTION
, BK.RECOGNIZE_GAIN_LOSS
, BK.RECAPTURE_RESERVE_FLAG
, BK.LIMIT_PROCEEDS_FLAG
, BK.TERMINAL_GAIN_LOSS
, BK.SALVAGE_TYPE
, BK.DEPRN_LIMIT_TYPE
, BK.TRACKING_METHOD
, BK.ALLOCATE_TO_FULLY_RSV_FLAG
, BK.ALLOCATE_TO_FULLY_RET_FLAG
, BK.EXCESS_ALLOCATION_OPTION
, BK.DEPRECIATION_OPTION
, BK.MEMBER_ROLLUP_FLAG
, BK.YTD_PROCEEDS
, BK.LTD_PROCEEDS
, BK.EXCLUDE_FULLY_RSV_FLAG
, BK.EOFY_RESERVE
, BK.TERMINAL_GAIN_LOSS_AMOUNT
, BK.LTD_COST_OF_REMOVAL
, BK.EXCLUDE_PROCEEDS_FROM_BASIS
, BK.RETIREMENT_DEPRN_OPTION
, BK.TERMINAL_GAIN_LOSS_FLAG
, BK.DISABLED_FLAG
, BK.OLD_ADJUSTED_CAPACITY
, BK.CASH_GENERATING_UNIT_ID
FROM FA_BOOKS BK
, FA_BOOK_CONTROLS BC
, FA_METHODS MTH
WHERE BK.DATE_INEFFECTIVE IS NULL
AND BK.BOOK_TYPE_CODE = BC.BOOK_TYPE_CODE
AND BK.DEPRN_METHOD_CODE = MTH.METHOD_CODE
AND BK.LIFE_IN_MONTHS = MTH.LIFE_IN_MONTHS UNION SELECT BK.ROWID ROW_ID
, BK.BOOK_TYPE_CODE
, BK.ASSET_ID
, BK.DATE_PLACED_IN_SERVICE
, BK.DATE_EFFECTIVE
, BK.DEPRN_START_DATE
, BK.DEPRN_METHOD_CODE
, BK.LIFE_IN_MONTHS
, BK.RATE_ADJUSTMENT_FACTOR
, BK.ADJUSTED_COST
, BK.COST
, BK.ORIGINAL_COST
, BK.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.LAST_UPDATE_DATE
, BK.LAST_UPDATED_BY
, BK.DATE_INEFFECTIVE
, BK.TRANSACTION_HEADER_ID_IN
, BK.TRANSACTION_HEADER_ID_OUT
, BK.ITC_AMOUNT_ID
, BK.ITC_AMOUNT
, BK.RETIREMENT_ID
, BK.TAX_REQUEST_ID
, BK.ITC_BASIS
, BK.BASIC_RATE
, BK.ADJUSTED_RATE
, BK.BONUS_RULE
, BK.CEILING_NAME
, BK.RECOVERABLE_COST
, BK.ADJUSTED_RECOVERABLE_COST
, BK.LAST_UPDATE_LOGIN
, 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.PERIOD_COUNTER_LIFE_COMPLETE
, BK.PRODUCTION_CAPACITY
, BK.REVAL_AMORTIZATION_BASIS
, BK.REVAL_CEILING
, BK.UNIT_OF_MEASURE
, BK.UNREVALUED_COST
, BK.ANNUAL_DEPRN_ROUNDING_FLAG
, BK.PERCENT_SALVAGE_VALUE
, BK.ALLOWED_DEPRN_LIMIT
, BK.ALLOWED_DEPRN_LIMIT_AMOUNT
, DECODE ( BC.ALLOW_REVAL_FLAG
, 'YES'
, 'Y'
, 'N') ALLOW_REVAL_FLAG
, MTH.RATE_SOURCE_RULE
, MTH.DEPRN_BASIS_RULE
, BK.GLOBAL_ATTRIBUTE1
, BK.GLOBAL_ATTRIBUTE2
, BK.GLOBAL_ATTRIBUTE3
, BK.GLOBAL_ATTRIBUTE4
, BK.GLOBAL_ATTRIBUTE5
, BK.GLOBAL_ATTRIBUTE6
, BK.GLOBAL_ATTRIBUTE7
, BK.GLOBAL_ATTRIBUTE8
, BK.GLOBAL_ATTRIBUTE9
, BK.GLOBAL_ATTRIBUTE10
, BK.GLOBAL_ATTRIBUTE11
, BK.GLOBAL_ATTRIBUTE12
, BK.GLOBAL_ATTRIBUTE13
, BK.GLOBAL_ATTRIBUTE14
, BK.GLOBAL_ATTRIBUTE15
, BK.GLOBAL_ATTRIBUTE16
, BK.GLOBAL_ATTRIBUTE17
, BK.GLOBAL_ATTRIBUTE18
, BK.GLOBAL_ATTRIBUTE19
, BK.GLOBAL_ATTRIBUTE20
, BK.GLOBAL_ATTRIBUTE_CATEGORY
, BK.SHORT_FISCAL_YEAR_FLAG
, BK.CONVERSION_DATE
, BK.ORIGINAL_DEPRN_START_DATE
, BK.FORMULA_FACTOR
, BK.GROUP_ASSET_ID
, BK.SUPER_GROUP_ID
, BK.REDUCTION_RATE
, BK.REDUCE_ADDITION_FLAG
, BK.REDUCE_ADJUSTMENT_FLAG
, BK.REDUCE_RETIREMENT_FLAG
, BK.OVER_DEPRECIATE_OPTION
, BK.RECOGNIZE_GAIN_LOSS
, BK.RECAPTURE_RESERVE_FLAG
, BK.LIMIT_PROCEEDS_FLAG
, BK.TERMINAL_GAIN_LOSS
, BK.SALVAGE_TYPE
, BK.DEPRN_LIMIT_TYPE
, BK.TRACKING_METHOD
, BK.ALLOCATE_TO_FULLY_RSV_FLAG
, BK.ALLOCATE_TO_FULLY_RET_FLAG
, BK.EXCESS_ALLOCATION_OPTION
, BK.DEPRECIATION_OPTION
, BK.MEMBER_ROLLUP_FLAG
, BK.YTD_PROCEEDS
, BK.LTD_PROCEEDS
, BK.EXCLUDE_FULLY_RSV_FLAG
, BK.EOFY_RESERVE
, BK.TERMINAL_GAIN_LOSS_AMOUNT
, BK.LTD_COST_OF_REMOVAL
, BK.EXCLUDE_PROCEEDS_FROM_BASIS
, BK.RETIREMENT_DEPRN_OPTION
, BK.TERMINAL_GAIN_LOSS_FLAG
, BK.DISABLED_FLAG
, BK.OLD_ADJUSTED_CAPACITY
, BK.CASH_GENERATING_UNIT_ID
FROM FA_BOOKS BK
, FA_BOOK_CONTROLS BC
, FA_METHODS MTH
WHERE BK.DATE_INEFFECTIVE IS NULL
AND BK.BOOK_TYPE_CODE = BC.BOOK_TYPE_CODE
AND BK.DEPRN_METHOD_CODE = MTH.METHOD_CODE
AND BK.LIFE_IN_MONTHS IS NULL
AND MTH.LIFE_IN_MONTHS IS NULL