APPS.FA_QUICK_BOOKS_V
[Home] [Help]
| Product: | OFA - Assets |
|---|---|
| Description: | - Retrofitted |
| Implementation/DBA Data: |
APPS.FA_QUICK_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.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.PRODUCTION_CAPACITY
, BK.REVAL_AMORTIZATION_BASIS
, BK.REVAL_CEILING
, BK.UNIT_OF_MEASURE
, BK.UNREVALUED_COST
, BK.PERIOD_COUNTER_LIFE_COMPLETE
, BK.ALLOWED_DEPRN_LIMIT
, BK.ALLOWED_DEPRN_LIMIT_AMOUNT
, BK.PERCENT_SALVAGE_VALUE
, BK.ADJUSTED_RECOVERABLE_COST
, BC.ACCOUNTING_FLEX_STRUCTURE ACCT_FLEX_NUM
, 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.EXCLUDE_PROCEEDS_FROM_BASIS
, BK.RETIREMENT_DEPRN_OPTION
, BK.TERMINAL_GAIN_LOSS_FLAG
, BK.DISABLED_FLAG
FROM FA_BOOKS BK
, FA_BOOK_CONTROLS BC
WHERE BK.BOOK_TYPE_CODE = BC.BOOK_TYPE_CODE