[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | FA_BOOKS |
|---|---|
| Object Type: | TABLE |
| Owner: | FA |
| FND Design Data: |  OFA.FA_BOOKS
|
| Subobject Name: | |
| Status: | VALID |
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| FA_BOOKS_U1 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
 TRANSACTION_HEADER_ID_IN
|
| FA_BOOKS_N1 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
ASSET_ID
BOOK_TYPE_CODE
|
| FA_BOOKS_N2 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
TRANSACTION_HEADER_ID_OUT
|
| FA_BOOKS_N3 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
RETIREMENT_ID
|
| FA_BOOKS_N4 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
GROUP_ASSET_ID
|
| FA_BOOKS_U2 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
BOOK_TYPE_CODE
TRANSACTION_HEADER_ID_OUT
ASSET_ID
|
Cut, paste (and edit) the following text to query this object:
SELECT BOOK_TYPE_CODE
, ASSET_ID
, DATE_PLACED_IN_SERVICE
, DATE_EFFECTIVE
, DEPRN_START_DATE
, DEPRN_METHOD_CODE
, LIFE_IN_MONTHS
, RATE_ADJUSTMENT_FACTOR
, ADJUSTED_COST
, COST
, ORIGINAL_COST
, SALVAGE_VALUE
, PRORATE_CONVENTION_CODE
, PRORATE_DATE
, COST_CHANGE_FLAG
, ADJUSTMENT_REQUIRED_STATUS
, CAPITALIZE_FLAG
, RETIREMENT_PENDING_FLAG
, DEPRECIATE_FLAG
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, DATE_INEFFECTIVE
, TRANSACTION_HEADER_ID_IN
, TRANSACTION_HEADER_ID_OUT
, ITC_AMOUNT_ID
, ITC_AMOUNT
, RETIREMENT_ID
, TAX_REQUEST_ID
, ITC_BASIS
, BASIC_RATE
, ADJUSTED_RATE
, BONUS_RULE
, CEILING_NAME
, RECOVERABLE_COST
, LAST_UPDATE_LOGIN
, ADJUSTED_CAPACITY
, FULLY_RSVD_REVALS_COUNTER
, IDLED_FLAG
, PERIOD_COUNTER_CAPITALIZED
, PERIOD_COUNTER_FULLY_RESERVED
, PERIOD_COUNTER_FULLY_RETIRED
, PRODUCTION_CAPACITY
, REVAL_AMORTIZATION_BASIS
, REVAL_CEILING
, UNIT_OF_MEASURE
, UNREVALUED_COST
, ANNUAL_DEPRN_ROUNDING_FLAG
, PERCENT_SALVAGE_VALUE
, ALLOWED_DEPRN_LIMIT
, ALLOWED_DEPRN_LIMIT_AMOUNT
, PERIOD_COUNTER_LIFE_COMPLETE
, ADJUSTED_RECOVERABLE_COST
, ANNUAL_ROUNDING_FLAG
, GLOBAL_ATTRIBUTE1
, GLOBAL_ATTRIBUTE2
, GLOBAL_ATTRIBUTE3
, GLOBAL_ATTRIBUTE4
, GLOBAL_ATTRIBUTE5
, GLOBAL_ATTRIBUTE6
, GLOBAL_ATTRIBUTE7
, GLOBAL_ATTRIBUTE8
, GLOBAL_ATTRIBUTE9
, GLOBAL_ATTRIBUTE10
, GLOBAL_ATTRIBUTE11
, GLOBAL_ATTRIBUTE12
, GLOBAL_ATTRIBUTE13
, GLOBAL_ATTRIBUTE14
, GLOBAL_ATTRIBUTE15
, GLOBAL_ATTRIBUTE16
, GLOBAL_ATTRIBUTE17
, GLOBAL_ATTRIBUTE18
, GLOBAL_ATTRIBUTE19
, GLOBAL_ATTRIBUTE20
, GLOBAL_ATTRIBUTE_CATEGORY
, EOFY_ADJ_COST
, EOFY_FORMULA_FACTOR
, SHORT_FISCAL_YEAR_FLAG
, CONVERSION_DATE
, ORIGINAL_DEPRN_START_DATE
, REMAINING_LIFE1
, REMAINING_LIFE2
, OLD_ADJUSTED_COST
, FORMULA_FACTOR
, GROUP_ASSET_ID
, SALVAGE_TYPE
, DEPRN_LIMIT_TYPE
, REDUCTION_RATE
, REDUCE_ADDITION_FLAG
, REDUCE_ADJUSTMENT_FLAG
, REDUCE_RETIREMENT_FLAG
, RECOGNIZE_GAIN_LOSS
, RECAPTURE_RESERVE_FLAG
, LIMIT_PROCEEDS_FLAG
, TERMINAL_GAIN_LOSS
, TRACKING_METHOD
, EXCLUDE_FULLY_RSV_FLAG
, EXCESS_ALLOCATION_OPTION
, DEPRECIATION_OPTION
, MEMBER_ROLLUP_FLAG
, ALLOCATE_TO_FULLY_RSV_FLAG
, ALLOCATE_TO_FULLY_RET_FLAG
, TERMINAL_GAIN_LOSS_AMOUNT
, CIP_COST
, YTD_PROCEEDS
, LTD_PROCEEDS
, LTD_COST_OF_REMOVAL
, EOFY_RESERVE
, PRIOR_EOFY_RESERVE
, EOP_ADJ_COST
, EOP_FORMULA_FACTOR
, EXCLUDE_PROCEEDS_FROM_BASIS
, RETIREMENT_DEPRN_OPTION
, TERMINAL_GAIN_LOSS_FLAG
, SUPER_GROUP_ID
, OVER_DEPRECIATE_OPTION
, DISABLED_FLAG
, OLD_ADJUSTED_CAPACITY
, DRY_HOLE_FLAG
, CASH_GENERATING_UNIT_ID
, CONTRACT_ID
, EXTENDED_DEPRN_FLAG
, EXTENDED_DEPRECIATION_PERIOD
, PERIOD_COUNTER_FULLY_EXTENDED
, RATE_IN_USE
FROM FA.FA_BOOKS;
FA.FA_BOOKS does not reference any database object
FA.FA_BOOKS is referenced by following:
APPS
FA_BOOKS
FA_BOOKS_BAS
JL_ZZ_FA_BOOKS_GLOB_FLEX_RL
JL_ZZ_FA_BOOKS_GLOB_FLEX_SL
|
|
|
|