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_BOOK_CONTROLS

Object Details

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

FA_MC_BOOK_CONTROLS is an MRC sub-table of FA_ BOOK_CONTROLS. This
table stores control information that affects all assets in a
reporting depreciation book.
The BOOK_TYPE_CODE in FA_MC_BOOK_CONTROLS is the same as the
BOOK_TYPE_CODE in the parent record in FA_ BOOK_CONTROLS.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
FA_MC_BOOK_CONTROLS_U1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SET_OF_BOOKS_ID BOOK_TYPE_CODE

Columns

Name	Datatype	Length	Mandatory	Comments
SET_OF_BOOKS_ID	NUMBER	(15)	Yes	Reporting set of books identification number for GL sets of books
BOOK_TYPE_CODE	VARCHAR2	(30)	Yes	Book name
CURRENCY_CODE	VARCHAR2	(15)	Yes	Transaction currency
DEPRN_STATUS	VARCHAR2	(1)		Specifies whether the depreciation program is locking the book. Either C (completed), E (error), R (running), or S (submitted)
DEPRN_REQUEST_ID	NUMBER	(15)		Concurrent request identification number for the last depreciation run
LAST_PERIOD_COUNTER	NUMBER	(15)	Yes	Last period depreciated in this book
LAST_DEPRN_RUN_DATE	DATE		Yes	Date of the last depreciation
CURRENT_FISCAL_YEAR	NUMBER	(4)	Yes	Current fiscal year for the book
RETIRED_STATUS	VARCHAR2	(1)	Yes	Reserved for future use
RETIRED_REQUEST_ID	NUMBER	(15)	Yes	Reserved for future use
PRIMARY_SET_OF_BOOKS_ID	NUMBER	(15)	Yes	Primary set of books identification number for this reporting set of books
PRIMARY_CURRENCY_CODE	VARCHAR2	(15)	Yes	The currency code of the primary set of books
SOURCE_RETIRED_STATUS	VARCHAR2	(1)	Yes	Reserved for future use
SOURCE_RETIRED_REQUEST_ID	NUMBER	(15)	Yes	Reserved for future use
MRC_CONVERTED_FLAG	VARCHAR2	(1)	Yes	Indicates whether the set of books is converted to Multiple Reporting Currencies options
ENABLED_FLAG	VARCHAR2	(1)	Yes	Indicates if this set of books is enabled for transactions
NBV_AMOUNT_THRESHOLD	NUMBER			Rounding information for depreciation based on currency and precision
CONVERSION_STATUS	VARCHAR2	(1)		Conversion status
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who column
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who column
MASS_REQUEST_ID	NUMBER	(15)		Concurrent request ID of a mass transaction locking any assets in this book
ALLOW_IMPAIRMENT_FLAG	VARCHAR2	(1)		Indicates whether to allow asset impairments
GL_POSTING_ALLOWED_FLAG	VARCHAR2	(3)		Indicates whether to allow journals to be created in General Ledger

Query Text

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


SELECT SET_OF_BOOKS_ID
,      BOOK_TYPE_CODE
,      CURRENCY_CODE
,      DEPRN_STATUS
,      DEPRN_REQUEST_ID
,      LAST_PERIOD_COUNTER
,      LAST_DEPRN_RUN_DATE
,      CURRENT_FISCAL_YEAR
,      RETIRED_STATUS
,      RETIRED_REQUEST_ID
,      PRIMARY_SET_OF_BOOKS_ID
,      PRIMARY_CURRENCY_CODE
,      SOURCE_RETIRED_STATUS
,      SOURCE_RETIRED_REQUEST_ID
,      MRC_CONVERTED_FLAG
,      ENABLED_FLAG
,      NBV_AMOUNT_THRESHOLD
,      CONVERSION_STATUS
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      MASS_REQUEST_ID
,      ALLOW_IMPAIRMENT_FLAG
,      GL_POSTING_ALLOWED_FLAG
FROM FA.FA_MC_BOOK_CONTROLS;

Dependencies

[top of page]

FA.FA_MC_BOOK_CONTROLS does not reference any database object

FA.FA_MC_BOOK_CONTROLS is referenced by following:

FA: FA_MC_BOOK_CONTROLS#