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.FAFV_ASSET_BKS

Object Details

Object Name:	FAFV_ASSET_BKS
Object Type:	VIEW
Owner:	APPS
FND Design Data:	OFA.FAFV_ASSET_BKS
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
TRANSACTION_HEADER_ID_IN	NUMBER	(15)	Yes	Refer to base table
DATE_PLACED_IN_SERVICE	DATE		Yes	Refer to base table
DEPRN_START_DATE	DATE		Yes	Refer to base table
DEPRN_METHOD	VARCHAR2	(12)	Yes	Refer to base table
LIFE_IN_MONTHS	NUMBER	(4)		Refer to base table
COST	NUMBER		Yes	Refer to base table
ORIGINAL_COST	NUMBER		Yes	Refer to base table
SALVAGE_VALUE	NUMBER		Yes	Refer to base table
PRORATE_CONVENTION_CODE	VARCHAR2	(10)	Yes	Refer to base table
PRORATE_DATE	DATE		Yes	Refer to base table
DEPRECIATE_FLAG	VARCHAR2	(3)	Yes	Refer to base table
ITC_AMOUNT_ID	NUMBER	(15)		Refer to base table
ITC_AMOUNT	NUMBER			Refer to base table
ITC_BASIS	NUMBER			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
CEILING_NAME	VARCHAR2	(30)		Refer to base table
RECOVERABLE_COST	NUMBER		Yes	Refer to base table
PRODUCTION_CAPACITY	NUMBER			Refer to base table
REVAL_CEILING	NUMBER			Refer to base table
UNIT_OF_MEASURE	VARCHAR2	(25)		Refer to base table
UNREVALUED_COST	NUMBER		Yes	Refer to base table
PERCENT_SALVAGE_VALUE	NUMBER			Refer to base table
ALLOWED_DEPRN_LIMIT_AMOUNT	NUMBER			Refer to base table
BOOK_TYPE_CODE	VARCHAR2	(15)	Yes	Refer to base table
ASSET_ID	NUMBER	(15)	Yes	Refer to base table
ASSET_NUMBER	VARCHAR2	(15)	Yes	Refer to base table
FULLY_RSVD_REVALS_COUNTER	NUMBER	(5)		Refer to base table
PERIOD_COUNTER_CAPITALIZED	NUMBER	(15)		Refer to base table
PERIOD_CAPITALIZED	VARCHAR2	(15)		Refer to base table
PERIOD_COUNTER_FULLY_RESERVED	NUMBER	(15)		Refer to base table
PERIOD_FULLY_RESERVED	VARCHAR2	(15)		Refer to base table
PERIOD_COUNTER_FULLY_RETIRED	NUMBER	(15)		Refer to base table
PERIOD_FULLY_RETIRED	VARCHAR2	(15)		Refer to base table
PERIOD_COUNTER_LIFE_COMPLETE	NUMBER	(15)		Refer to base table
PERIOD_LIFE_COMPLETE	VARCHAR2	(15)		Refer to base table
LAST_UPDATE_DATE	DATE		Yes	Refer to base table
LAST_UPDATED_BY	NUMBER	(15)	Yes	Refer to base table

Query Text

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


SELECT TRANSACTION_HEADER_ID_IN
,      DATE_PLACED_IN_SERVICE
,      DEPRN_START_DATE
,      DEPRN_METHOD
,      LIFE_IN_MONTHS
,      COST
,      ORIGINAL_COST
,      SALVAGE_VALUE
,      PRORATE_CONVENTION_CODE
,      PRORATE_DATE
,      DEPRECIATE_FLAG
,      ITC_AMOUNT_ID
,      ITC_AMOUNT
,      ITC_BASIS
,      BASIC_RATE
,      ADJUSTED_RATE
,      BONUS_RULE
,      CEILING_NAME
,      RECOVERABLE_COST
,      PRODUCTION_CAPACITY
,      REVAL_CEILING
,      UNIT_OF_MEASURE
,      UNREVALUED_COST
,      PERCENT_SALVAGE_VALUE
,      ALLOWED_DEPRN_LIMIT_AMOUNT
,      BOOK_TYPE_CODE
,      ASSET_ID
,      ASSET_NUMBER
,      FULLY_RSVD_REVALS_COUNTER
,      PERIOD_COUNTER_CAPITALIZED
,      PERIOD_CAPITALIZED
,      PERIOD_COUNTER_FULLY_RESERVED
,      PERIOD_FULLY_RESERVED
,      PERIOD_COUNTER_FULLY_RETIRED
,      PERIOD_FULLY_RETIRED
,      PERIOD_COUNTER_LIFE_COMPLETE
,      PERIOD_LIFE_COMPLETE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
FROM APPS.FAFV_ASSET_BKS;

Dependencies

[top of page]

APPS.FAFV_ASSET_BKS references the following:

APPS: FA_ADDITIONS; FA_BOOKS; FA_DEPRN_PERIODS

APPS.FAFV_ASSET_BKS is not referenced by any database object