DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.FA_BOOKS_MRC_V

Object Details
Object Name: FA_BOOKS_MRC_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewOFA.FA_BOOKS_MRC_V
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns
Name Datatype Length Mandatory Comments
SET_OF_BOOKS_ID NUMBER (15) Yes Reporting set of books identification number for General Ledger sets of books
BOOK_TYPE_CODE VARCHAR2 (30) Yes Book name
ASSET_ID NUMBER (15) Yes Asset identification number
DATE_PLACED_IN_SERVICE DATE
Yes Date the asset was placed in service
DATE_EFFECTIVE DATE
Yes Date the row was entered
DEPRN_START_DATE DATE
Yes Date the asset started to depreciate
DEPRN_METHOD_CODE VARCHAR2 (12) Yes Name of the depreciation method for the asset
LIFE_IN_MONTHS NUMBER

Life of the asset in total months
RATE_ADJUSTMENT_FACTOR NUMBER
Yes Percent of remaining depreciation after a revaluation or an amortized change, or 1
ADJUSTED_COST NUMBER
Yes Recoverable cost less depreciation reserve. Reset when you perform an amortized adjustment or revaluation
COST NUMBER
Yes Current cost of the asset
ORIGINAL_COST NUMBER
Yes Original cost of the asset
SALVAGE_VALUE NUMBER
Yes Asset salvage value
PRORATE_CONVENTION_CODE VARCHAR2 (10) Yes Depreciation prorate convention
PRORATE_DATE DATE
Yes Date used to prorate depreciation
COST_CHANGE_FLAG VARCHAR2 (3) Yes Indicates whether there is an adjustment pending for the asset. The depreciation program recalculates depreciation reserve from the beginning of the asset's life if this flag is set to YES
ADJUSTMENT_REQUIRED_STATUS VARCHAR2 (4) Yes Indicates asset requires an adjustment to depreciation expense for a retroactive transaction
CAPITALIZE_FLAG VARCHAR2 (3) Yes Indicates whether the asset is a capitalized asset
RETIREMENT_PENDING_FLAG VARCHAR2 (3) Yes Identifies whether the asset has a retirement pending
DEPRECIATE_FLAG VARCHAR2 (3) Yes Indicates whether the asset is depreciating
LAST_UPDATE_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER (15) Yes Standard Who column
DATE_INEFFECTIVE DATE

Date which the row became ineffective
TRANSACTION_HEADER_ID_IN NUMBER (15) Yes Identifies the transaction that made this row effective
TRANSACTION_HEADER_ID_OUT NUMBER (15)
Identifies the transaction that made this row ineffective
ITC_AMOUNT_ID NUMBER (15)
Identifies the ITC rate
ITC_AMOUNT NUMBER

Amount of ITC
RETIREMENT_ID NUMBER (15)
Identifies the retirement transaction if the asset has been retired
TAX_REQUEST_ID NUMBER (15)
Concurrent request number for mass copy program
ITC_BASIS NUMBER

Cost basis for calculating ITC
BASIC_RATE NUMBER

Base rate used to calculate depreciation amount for flat-rate methods
ADJUSTED_RATE NUMBER

Actual rate used to calculate depreciation for flat-rate methods
BONUS_RULE VARCHAR2 (30)
Identifies the bonus rule to use in calculating depreciation for the flat-rate methods
CEILING_NAME VARCHAR2 (30)
Identifies a depreciation ceiling to use in calculating depreciation
RECOVERABLE_COST NUMBER
Yes Cost minus salvage value, or depreciation ceiling, which ever is lower
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
ADJUSTED_CAPACITY NUMBER

Capacity of a units of production asset. Reset to the remaining capacity when you perform an amortized capacity adjustment
FULLY_RSVD_REVALS_COUNTER NUMBER

Number of times the asset has been revalued as fully reserved
IDLED_FLAG VARCHAR2 (3)
Reserved for future use
PERIOD_COUNTER_CAPITALIZED NUMBER

Period that the asset was capitalized
PERIOD_COUNTER_FULLY_RESERVED NUMBER (15)
Period that the asset became fully reserved
PERIOD_COUNTER_FULLY_RETIRED NUMBER

Period that the asset became fully retired
PRODUCTION_CAPACITY NUMBER

Capacity of a units of production asset
REVAL_AMORTIZATION_BASIS NUMBER

Revaluation Reserve used in calculating amortization of revaluation reserve. Updated only when the asset is revalued or has an amortized adjustment.
REVAL_CEILING NUMBER

Upper limit for revaluing asset cost
UNIT_OF_MEASURE VARCHAR2 (25)
Unit of measure of a units of production asset
UNREVALUED_COST NUMBER
Yes Cost without regard to any revaluations
ANNUAL_DEPRN_ROUNDING_FLAG VARCHAR2 (5)
Indicates whether Oracle Assets should subtract year-to-date depreciation from the annual depreciation amount to get the depreciation amount for the last period of the fiscal year
PERCENT_SALVAGE_VALUE NUMBER

Salvage value percentage amount
ALLOWED_DEPRN_LIMIT NUMBER

The default depreciation limit as a percentage of cost.
ALLOWED_DEPRN_LIMIT_AMOUNT NUMBER

Cost without regard to any revaluations
PERIOD_COUNTER_LIFE_COMPLETE NUMBER (15)
The period the asset's useful life is fully reserved
ADJUSTED_RECOVERABLE_COST NUMBER

Adjusted recoverable cost with special depreciation limits taken into account
ANNUAL_ROUNDING_FLAG VARCHAR2 (3)
Reserved for future use
GLOBAL_ATTRIBUTE1 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE2 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE3 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE4 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE5 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE6 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE7 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE8 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE9 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE10 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE11 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE12 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE13 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE14 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE15 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE16 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE17 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE18 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE19 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE20 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE_CATEGORY VARCHAR2 (30)
Reserved for country-specific functionality
SHORT_FISCAL_YEAR_FLAG VARCHAR2 (3)
Indicates if asset is added in a short fiscal year
CONVERSION_DATE DATE

Date short tax asset added to the acquiring company
ORIGINAL_DEPRN_START_DATE DATE

Original depreciation start date
FORMULA_FACTOR NUMBER

The formula factor
REMAINING_LIFE1 NUMBER (4)
Remaining useful life as of the conversion date or the beginning of the fiscal year
REMAINING_LIFE2 NUMBER (4)
Remaining useful life as of the beginning of the fiscal year
OLD_ADJUSTED_COST NUMBER

Adjusted cost at the time of the prior adjustment
EOFY_ADJ_COST NUMBER

Adjusted cost at the end of the previous fiscal year
EOFY_FORMULA_FACTOR NUMBER

The formula factor at the end of the fiscal year
GROUP_ASSET_ID NUMBER (15)
Reserved for system use. Do not use.
REDUCTION_RATE NUMBER

If the record is for a group asset, the reduction rate will be a default value for member assets. If the record is for a member asset, the reduction rate is the reduction rate used for transactions
REDUCE_ADDITION_FLAG VARCHAR2 (1)
Indicates whether or not the reduction rate should be used for addition transactions
REDUCE_ADJUSTMENT_FLAG VARCHAR2 (1)
Indicates whether or not the reduction rate should be used for adjustment transactions
REDUCE_RETIREMENT_FLAG VARCHAR2 (1)
Indicates whether or not the reduction rate should be used for retirement transactions
RECOGNIZE_GAIN_LOSS VARCHAR2 (30)
Indicates whether or not the system recognizes gain or loss immediately
RECAPTURE_RESERVE_FLAG VARCHAR2 (1)
Indicates whether or not the reserve for a group asset can exceed its recoverable cost
LIMIT_PROCEEDS_FLAG VARCHAR2 (1)
Indicates whether or not the reserve for a group asset can exceed its recoverable cost
TERMINAL_GAIN_LOSS VARCHAR2 (30)
Indicates whether or not to take terminal gain or loss immediately, or at the end of the fiscal year, when there is accumulated depreciation remaining for the group asset after the last member asset is retired from the group asset
SALVAGE_TYPE VARCHAR2 (30) Yes Indicates whether the salvage type is the amount, percentage, or sum of member assets
DEPRN_LIMIT_TYPE VARCHAR2 (30) Yes Indicates whether the depreciation limit type is the amount, percentage, sum of member assets, or no depreciation limit type(NONE)
TRACKING_METHOD VARCHAR2 (30)
Indicates whether member assets should be tracked, tracked using the allocate method or the calculate method
ALLOCATE_TO_FULLY_RSV_FLAG VARCHAR2 (1)
Indicates whether or not group depreciation expense should be allocated to fully reserved assets
ALLOCATE_TO_FULLY_RET_FLAG VARCHAR2 (1)
Indicates whether or not group depreciation expense should be allocated to fully retired assets
EXCESS_ALLOCATION_OPTION VARCHAR2 (30)
Indicates whether the excess amount incurred during allocation should also be distributed to the member asset, or reduced from the group asset depreciation expense
DEPRECIATION_OPTION VARCHAR2 (30)
Indicates whether a member assets depreciation expenses should be calculated using its group asset depreciation rules or the member asset depreciation rules
MEMBER_ROLLUP_FLAG VARCHAR2 (1)
Indicates whether or not the sum of member asset depreciation expense should be the group asset depreciation amount
YTD_PROCEEDS NUMBER

Year-to-date proceeds of sale
LTD_PROCEEDS NUMBER

Life-to-date proceeds of sale
EXCLUDE_FULLY_RSV_FLAG VARCHAR2 (1)
Indicates whether or not fully reserved assets' depreciable basis should be excluded from the group's depreciable basis
EOFY_RESERVE NUMBER

Accumulated depreciation at the end of the previous fiscal year
CIP_COST NUMBER

Sum of the non-depreciable source line cost if the asset type is CIP
TERMINAL_GAIN_LOSS_AMOUNT NUMBER

Accumulated depreciation remaining for the group asset after the last member asset is retired from the group asset
LTD_COST_OF_REMOVAL NUMBER

Life-to-date cost of removal
PRIOR_EOFY_RESERVE NUMBER

Previous accumulated depreciation at the end of the previous fiscal year
EOP_ADJ_COST NUMBER

Adjusted cost at the end of the previous period
EOP_FORMULA_FACTOR NUMBER

Formula factor at the end of the previous period
EXCLUDE_PROCEEDS_FROM_BASIS VARCHAR2 (1)
Indicates whether or not the proceeds of sale should be included when calculating the depreciable basis.
RETIREMENT_DEPRN_OPTION VARCHAR2 (30)
Indicates whether depreciation should continue depreciating until the last member asset is retired or until the end of the fiscal year
TERMINAL_GAIN_LOSS_FLAG VARCHAR2 (1)
Indicates whether or not the terminal gain/loss amount needs to be processed during the Calculate Gains and Losses program, if it is running in the last period of the fiscal year
SUPER_GROUP_ID NUMBER (15)
Identifies the super group that the asset in this book uses
OVER_DEPRECIATE_OPTION VARCHAR2 (30)
Indicates whether the over depreciate is Do Not Allow, Allow, or Allow and Depreciate.
DISABLED_FLAG VARCHAR2 (1)
OLD_ADJUSTED_CAPACITY NUMBER

Old net remaining capacity before the last depreciation run.
DRY_HOLE_FLAG VARCHAR2 (1)
Indicates whether the asset is of a dry-hole type.
CASH_GENERATING_UNIT_ID NUMBER (15)
CONTRACT_ID NUMBER

RATE_IN_USE NUMBER

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT SET_OF_BOOKS_ID
,      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
,      SHORT_FISCAL_YEAR_FLAG
,      CONVERSION_DATE
,      ORIGINAL_DEPRN_START_DATE
,      FORMULA_FACTOR
,      REMAINING_LIFE1
,      REMAINING_LIFE2
,      OLD_ADJUSTED_COST
,      EOFY_ADJ_COST
,      EOFY_FORMULA_FACTOR
,      GROUP_ASSET_ID
,      REDUCTION_RATE
,      REDUCE_ADDITION_FLAG
,      REDUCE_ADJUSTMENT_FLAG
,      REDUCE_RETIREMENT_FLAG
,      RECOGNIZE_GAIN_LOSS
,      RECAPTURE_RESERVE_FLAG
,      LIMIT_PROCEEDS_FLAG
,      TERMINAL_GAIN_LOSS
,      SALVAGE_TYPE
,      DEPRN_LIMIT_TYPE
,      TRACKING_METHOD
,      ALLOCATE_TO_FULLY_RSV_FLAG
,      ALLOCATE_TO_FULLY_RET_FLAG
,      EXCESS_ALLOCATION_OPTION
,      DEPRECIATION_OPTION
,      MEMBER_ROLLUP_FLAG
,      YTD_PROCEEDS
,      LTD_PROCEEDS
,      EXCLUDE_FULLY_RSV_FLAG
,      EOFY_RESERVE
,      CIP_COST
,      TERMINAL_GAIN_LOSS_AMOUNT
,      LTD_COST_OF_REMOVAL
,      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
,      RATE_IN_USE
FROM APPS.FA_BOOKS_MRC_V;

Dependencies

[top of page]

APPS.FA_BOOKS_MRC_V references the following:

SchemaAPPS
SynonymFA_MC_BOOKS
APPS.FA_BOOKS_MRC_V is referenced by following:

SchemaAPPS
Package BodyFA_BALREP_PKG - show dependent code
Package BodyFA_FAS400_XMLP_PKG - show dependent code
Package BodyFA_FAS401_XMLP_PKG - show dependent code
Package BodyFA_FAS403_XMLP_PKG - show dependent code
Package BodyFA_FAS480_XMLP_PKG - show dependent code
Package BodyFA_FASCOSTD_XMLP_PKG - show dependent code
Package BodyFA_FASCOSTS_XMLP_PKG - show dependent code
Package BodyFA_FASRSVED_XMLP_PKG - show dependent code
Package BodyFA_FASRSVES_XMLP_PKG - show dependent code
Package BodyFA_RES_LDG_PKG - show dependent code
Package BodyFA_RSVLDG_REP_INS_PKG - show dependent code
Package BodyJL_JLMXFGLR_XMLP_PKG - show dependent code
Package BodyJL_JLMXFISR_XMLP_PKG - show dependent code
Package BodyJL_ZZ_FA_FUNCTIONS_PKG - show dependent code