eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: FA.FA_MC_BOOKS

Object Details

Object Name:	FA_MC_BOOKS
Object Type:	TABLE
Owner:	FA
FND Design Data:	OFA.FA_MC_BOOKS
Subobject Name:
Status:	VALID

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
FA_MC_BOOKS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	SET_OF_BOOKS_ID TRANSACTION_HEADER_ID_IN
FA_MC_BOOKS_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	SET_OF_BOOKS_ID ASSET_ID BOOK_TYPE_CODE TRANSACTION_HEADER_ID_OUT
FA_MC_BOOKS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SET_OF_BOOKS_ID TRANSACTION_HEADER_ID_OUT
FA_MC_BOOKS_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SET_OF_BOOKS_ID RETIREMENT_ID
FA_MC_BOOKS_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	GROUP_ASSET_ID

Columns

Name	Datatype	Length	Mandatory
SET_OF_BOOKS_ID	NUMBER	(15)	Yes
ASSET_ID	NUMBER	(15)	Yes
BOOK_TYPE_CODE	VARCHAR2	(30)	Yes
TRANSACTION_HEADER_ID_IN	NUMBER	(15)	Yes
TRANSACTION_HEADER_ID_OUT	NUMBER	(15)
ADJUSTED_COST	NUMBER		Yes
COST	NUMBER		Yes
SOURCE_COST	NUMBER
ORIGINAL_COST	NUMBER		Yes
SOURCE_ORIGINAL_COST	NUMBER
SALVAGE_VALUE	NUMBER		Yes
ADJUSTMENT_REQUIRED_STATUS	VARCHAR2	(4)	Yes
RETIREMENT_PENDING_FLAG	VARCHAR2	(3)	Yes
LAST_UPDATE_DATE	DATE		Yes
LAST_UPDATED_BY	NUMBER	(15)	Yes
ITC_AMOUNT	NUMBER
ITC_BASIS	NUMBER
RECOVERABLE_COST	NUMBER		Yes
LAST_UPDATE_LOGIN	NUMBER	(15)
REVAL_CEILING	NUMBER
PERIOD_COUNTER_FULLY_RESERVED	NUMBER	(15)
UNREVALUED_COST	NUMBER		Yes
ALLOWED_DEPRN_LIMIT_AMOUNT	NUMBER
PERIOD_COUNTER_LIFE_COMPLETE	NUMBER	(15)
ADJUSTED_RECOVERABLE_COST	NUMBER
CONVERTED_FLAG	VARCHAR2	(1)
ANNUAL_DEPRN_ROUNDING_FLAG	VARCHAR2	(5)
EOFY_ADJ_COST	NUMBER
OLD_ADJUSTED_COST	NUMBER
EOFY_FORMULA_FACTOR	NUMBER
FORMULA_FACTOR	NUMBER
REMAINING_LIFE1	NUMBER	(4)
REMAINING_LIFE2	NUMBER	(4)
SHORT_FISCAL_YEAR_FLAG	VARCHAR2	(3)
GROUP_ASSET_ID	NUMBER	(15)
REVAL_AMORTIZATION_BASIS	NUMBER
ITC_AMOUNT_ID	NUMBER	(15)
RETIREMENT_ID	NUMBER	(15)
TAX_REQUEST_ID	NUMBER	(15)
BASIC_RATE	NUMBER
ADJUSTED_RATE	NUMBER
BONUS_RULE	VARCHAR2	(30)
CEILING_NAME	VARCHAR2	(30)
ADJUSTED_CAPACITY	NUMBER
FULLY_RSVD_REVALS_COUNTER	NUMBER
IDLED_FLAG	VARCHAR2	(3)
PERIOD_COUNTER_CAPITALIZED	NUMBER
PERIOD_COUNTER_FULLY_RETIRED	NUMBER
PRODUCTION_CAPACITY	NUMBER
UNIT_OF_MEASURE	VARCHAR2	(25)
PERCENT_SALVAGE_VALUE	NUMBER
ALLOWED_DEPRN_LIMIT	NUMBER
ANNUAL_ROUNDING_FLAG	VARCHAR2	(3)
GLOBAL_ATTRIBUTE1	VARCHAR2	(150)
GLOBAL_ATTRIBUTE2	VARCHAR2	(150)
GLOBAL_ATTRIBUTE3	VARCHAR2	(150)
GLOBAL_ATTRIBUTE4	VARCHAR2	(150)
GLOBAL_ATTRIBUTE5	VARCHAR2	(150)
GLOBAL_ATTRIBUTE6	VARCHAR2	(150)
GLOBAL_ATTRIBUTE7	VARCHAR2	(150)
GLOBAL_ATTRIBUTE8	VARCHAR2	(150)
GLOBAL_ATTRIBUTE9	VARCHAR2	(150)
GLOBAL_ATTRIBUTE10	VARCHAR2	(150)
GLOBAL_ATTRIBUTE11	VARCHAR2	(150)
GLOBAL_ATTRIBUTE12	VARCHAR2	(150)
GLOBAL_ATTRIBUTE13	VARCHAR2	(150)
GLOBAL_ATTRIBUTE14	VARCHAR2	(150)
GLOBAL_ATTRIBUTE15	VARCHAR2	(150)
GLOBAL_ATTRIBUTE16	VARCHAR2	(150)
GLOBAL_ATTRIBUTE17	VARCHAR2	(150)
GLOBAL_ATTRIBUTE18	VARCHAR2	(150)
GLOBAL_ATTRIBUTE19	VARCHAR2	(150)
GLOBAL_ATTRIBUTE20	VARCHAR2	(150)
GLOBAL_ATTRIBUTE_CATEGORY	VARCHAR2	(30)
DATE_PLACED_IN_SERVICE	DATE		Yes
DATE_EFFECTIVE	DATE		Yes
DEPRN_START_DATE	DATE		Yes
DEPRN_METHOD_CODE	VARCHAR2	(12)	Yes
LIFE_IN_MONTHS	NUMBER
RATE_ADJUSTMENT_FACTOR	NUMBER		Yes
PRORATE_CONVENTION_CODE	VARCHAR2	(10)	Yes
PRORATE_DATE	DATE		Yes
COST_CHANGE_FLAG	VARCHAR2	(3)	Yes
CAPITALIZE_FLAG	VARCHAR2	(3)	Yes
DEPRECIATE_FLAG	VARCHAR2	(3)	Yes
DATE_INEFFECTIVE	DATE
CONVERSION_DATE	DATE
ORIGINAL_DEPRN_START_DATE	DATE
SALVAGE_TYPE	VARCHAR2	(30)	Yes
DEPRN_LIMIT_TYPE	VARCHAR2	(30)	Yes
REDUCTION_RATE	NUMBER
REDUCE_ADDITION_FLAG	VARCHAR2	(1)
REDUCE_ADJUSTMENT_FLAG	VARCHAR2	(1)
REDUCE_RETIREMENT_FLAG	VARCHAR2	(1)
RECOGNIZE_GAIN_LOSS	VARCHAR2	(30)
RECAPTURE_RESERVE_FLAG	VARCHAR2	(1)
LIMIT_PROCEEDS_FLAG	VARCHAR2	(1)
TERMINAL_GAIN_LOSS	VARCHAR2	(30)
TRACKING_METHOD	VARCHAR2	(30)
EXCLUDE_FULLY_RSV_FLAG	VARCHAR2	(1)
EXCESS_ALLOCATION_OPTION	VARCHAR2	(30)
DEPRECIATION_OPTION	VARCHAR2	(30)
MEMBER_ROLLUP_FLAG	VARCHAR2	(1)
ALLOCATE_TO_FULLY_RSV_FLAG	VARCHAR2	(1)
ALLOCATE_TO_FULLY_RET_FLAG	VARCHAR2	(1)
TERMINAL_GAIN_LOSS_AMOUNT	NUMBER
CIP_COST	NUMBER
YTD_PROCEEDS	NUMBER
LTD_PROCEEDS	NUMBER
LTD_COST_OF_REMOVAL	NUMBER
EOFY_RESERVE	NUMBER
PRIOR_EOFY_RESERVE	NUMBER
EOP_ADJ_COST	NUMBER
EOP_FORMULA_FACTOR	NUMBER
EXCLUDE_PROCEEDS_FROM_BASIS	VARCHAR2	(1)
RETIREMENT_DEPRN_OPTION	VARCHAR2	(30)
TERMINAL_GAIN_LOSS_FLAG	VARCHAR2	(1)
SUPER_GROUP_ID	NUMBER	(15)
OVER_DEPRECIATE_OPTION	VARCHAR2	(30)
DISABLED_FLAG	VARCHAR2	(1)
OLD_ADJUSTED_CAPACITY	NUMBER
DRY_HOLE_FLAG	VARCHAR2	(1)
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
,      ASSET_ID
,      BOOK_TYPE_CODE
,      TRANSACTION_HEADER_ID_IN
,      TRANSACTION_HEADER_ID_OUT
,      ADJUSTED_COST
,      COST
,      SOURCE_COST
,      ORIGINAL_COST
,      SOURCE_ORIGINAL_COST
,      SALVAGE_VALUE
,      ADJUSTMENT_REQUIRED_STATUS
,      RETIREMENT_PENDING_FLAG
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      ITC_AMOUNT
,      ITC_BASIS
,      RECOVERABLE_COST
,      LAST_UPDATE_LOGIN
,      REVAL_CEILING
,      PERIOD_COUNTER_FULLY_RESERVED
,      UNREVALUED_COST
,      ALLOWED_DEPRN_LIMIT_AMOUNT
,      PERIOD_COUNTER_LIFE_COMPLETE
,      ADJUSTED_RECOVERABLE_COST
,      CONVERTED_FLAG
,      ANNUAL_DEPRN_ROUNDING_FLAG
,      EOFY_ADJ_COST
,      OLD_ADJUSTED_COST
,      EOFY_FORMULA_FACTOR
,      FORMULA_FACTOR
,      REMAINING_LIFE1
,      REMAINING_LIFE2
,      SHORT_FISCAL_YEAR_FLAG
,      GROUP_ASSET_ID
,      REVAL_AMORTIZATION_BASIS
,      ITC_AMOUNT_ID
,      RETIREMENT_ID
,      TAX_REQUEST_ID
,      BASIC_RATE
,      ADJUSTED_RATE
,      BONUS_RULE
,      CEILING_NAME
,      ADJUSTED_CAPACITY
,      FULLY_RSVD_REVALS_COUNTER
,      IDLED_FLAG
,      PERIOD_COUNTER_CAPITALIZED
,      PERIOD_COUNTER_FULLY_RETIRED
,      PRODUCTION_CAPACITY
,      UNIT_OF_MEASURE
,      PERCENT_SALVAGE_VALUE
,      ALLOWED_DEPRN_LIMIT
,      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
,      DATE_PLACED_IN_SERVICE
,      DATE_EFFECTIVE
,      DEPRN_START_DATE
,      DEPRN_METHOD_CODE
,      LIFE_IN_MONTHS
,      RATE_ADJUSTMENT_FACTOR
,      PRORATE_CONVENTION_CODE
,      PRORATE_DATE
,      COST_CHANGE_FLAG
,      CAPITALIZE_FLAG
,      DEPRECIATE_FLAG
,      DATE_INEFFECTIVE
,      CONVERSION_DATE
,      ORIGINAL_DEPRN_START_DATE
,      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
,      RATE_IN_USE
FROM FA.FA_MC_BOOKS;

Dependencies

[top of page]

FA.FA_MC_BOOKS does not reference any database object

FA.FA_MC_BOOKS is referenced by following:

APPS: FA_MC_BOOKS