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]

VIEW: APPS.FA_BOOKS_BK_CNTRL_WEB_V

Object Details

Object Name:	FA_BOOKS_BK_CNTRL_WEB_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	OFA.FA_BOOKS_BK_CNTRL_WEB_V
Subobject Name:
Status:	VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.

This web inquiry view contains financial information associated with an asset in a given depreciation book.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
BOOK_CLASS	VARCHAR2	(15)	Yes	Indicates whether the book is a corporate, tax, or budget book
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
BOOK_TYPE_CODE	VARCHAR2	(15)	Yes	Book name
ASSET_ID	NUMBER	(15)	Yes	Asset identification number
DATE_INEFFECTIVE	DATE			Date which the row became ineffective
COST	VARCHAR2	(4000)		Refer to base table.
ORIGINAL_COST	VARCHAR2	(4000)		Refer to base table.
CEILING_NAME	VARCHAR2	(30)		Refer to base table.
SALVAGE_VALUE	VARCHAR2	(4000)		Refer to base table.
REVAL_CEILING	VARCHAR2	(4000)		Refer to base table.
ITC_BASIS	VARCHAR2	(4000)		Refer to base table.
ITC_AMOUNT_ID	NUMBER	(15)		Refer to base table.
DATE_PLACED_IN_SERVICE	DATE		Yes	Refer to base table.
DEPRECIATE_FLAG	VARCHAR2	(3)	Yes	Refer to base table.
PRORATE_CONVENTION_CODE	VARCHAR2	(10)	Yes	Refer to base table.
PRORATE_DATE	DATE		Yes	Refer to base table.
DEPRN_METHOD_CODE	VARCHAR2	(12)	Yes	Refer to base table.
LIFE_IN_MONTHS	NUMBER	(4)		Refer to base table.
BASIC_RATE	NUMBER			Refer to base table.
ADJUSTED_RATE	NUMBER			Refer to base table.
BONUS_RULE	VARCHAR2	(30)		Refer to base table.
UNIT_OF_MEASURE	VARCHAR2	(25)		Refer to base table.
PRODUCTION_CAPACITY	NUMBER			Refer to base table.
RECOVERABLE_COST	VARCHAR2	(4000)		Refer to base table.
ASSET_NUMBER	VARCHAR2	(15)	Yes	Refer to base table.
DEPRN_METHOD	VARCHAR2	(12)	Yes	Refer to base table.
ITC_ELIGIBLE_FLAG	VARCHAR2	(3)	Yes	Refer to base table.
CURRENCY_CODE	VARCHAR2	(15)	Yes	Refer to base table.

Query Text

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


SELECT BOOK_CLASS
,      TRANSACTION_HEADER_ID_IN
,      TRANSACTION_HEADER_ID_OUT
,      BOOK_TYPE_CODE
,      ASSET_ID
,      DATE_INEFFECTIVE
,      COST
,      ORIGINAL_COST
,      CEILING_NAME
,      SALVAGE_VALUE
,      REVAL_CEILING
,      ITC_BASIS
,      ITC_AMOUNT_ID
,      DATE_PLACED_IN_SERVICE
,      DEPRECIATE_FLAG
,      PRORATE_CONVENTION_CODE
,      PRORATE_DATE
,      DEPRN_METHOD_CODE
,      LIFE_IN_MONTHS
,      BASIC_RATE
,      ADJUSTED_RATE
,      BONUS_RULE
,      UNIT_OF_MEASURE
,      PRODUCTION_CAPACITY
,      RECOVERABLE_COST
,      ASSET_NUMBER
,      DEPRN_METHOD
,      ITC_ELIGIBLE_FLAG
,      CURRENCY_CODE
FROM APPS.FA_BOOKS_BK_CNTRL_WEB_V;

Dependencies

[top of page]

APPS.FA_BOOKS_BK_CNTRL_WEB_V references the following:

APPS: FA_ADDITIONS_B; FA_BOOKS; FA_BOOK_CONTROLS; FA_CATEGORY_BOOK_DEFAULTS; FND_CURRENCY - show dependent code; GL_SETS_OF_BOOKS

APPS.FA_BOOKS_BK_CNTRL_WEB_V is not referenced by any database object