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_EXTENDED_DEPRN_V

Object Details

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

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns

Name	Datatype	Length	Mandatory
ASSET_NUMBER	VARCHAR2	(15)	Yes
DESCRIPTION	VARCHAR2	(80)
ASSET_TYPE	VARCHAR2	(11)	Yes
ATTRIBUTE_CATEGORY_CODE	VARCHAR2	(210)	Yes
BOOK_TYPE_CODE	VARCHAR2	(15)	Yes
DATE_PLACED_IN_SERVICE	DATE		Yes
DEPRN_METHOD_CODE	VARCHAR2	(12)	Yes
LIFE_IN_MONTHS	NUMBER	(4)
COST	NUMBER		Yes
ORIGINAL_COST	NUMBER		Yes
SALVAGE_VALUE	NUMBER		Yes
PRORATE_CONVENTION_CODE	VARCHAR2	(10)	Yes
DEPRECIATE_FLAG	VARCHAR2	(3)	Yes
ITC_AMOUNT_ID	NUMBER	(15)
BASIC_RATE	NUMBER
ADJUSTED_RATE	NUMBER
BONUS_RULE	VARCHAR2	(30)
CEILING_NAME	VARCHAR2	(30)
FULLY_RSVD_REVALS_COUNTER	NUMBER	(5)
PERIOD_COUNTER_FULLY_RESERVED	NUMBER	(15)
PRODUCTION_CAPACITY	NUMBER
REVAL_AMORTIZATION_BASIS	NUMBER
REVAL_CEILING	NUMBER
UNREVALUED_COST	NUMBER		Yes
ALLOWED_DEPRN_LIMIT	NUMBER
ALLOWED_DEPRN_LIMIT_AMOUNT	NUMBER
SHORT_FISCAL_YEAR_FLAG	VARCHAR2	(3)
CONVERSION_DATE	DATE
ORIGINAL_DEPRN_START_DATE	DATE
GROUP_ASSET_ID	NUMBER	(15)
DEPRN_LIMIT_TYPE	VARCHAR2	(30)	Yes
EXTENDED_DEPRN_FLAG	VARCHAR2	(1)
EXTENDED_DEPRECIATION_PERIOD	NUMBER	(15)
TRANSACTION_NAME	VARCHAR2	(30)
AMORTIZATION_START_DATE	DATE
DEPRN_RESERVE	NUMBER		Yes
YTD_DEPRN	NUMBER		Yes
REVAL_RESERVE	NUMBER
YTD_REVAL_DEPRN_EXPENSE	NUMBER
PERIOD_NAME	VARCHAR2	(15)	Yes
IMPAIRMENT_RESERVE	NUMBER

Query Text

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


SELECT ASSET_NUMBER
,      DESCRIPTION
,      ASSET_TYPE
,      ATTRIBUTE_CATEGORY_CODE
,      BOOK_TYPE_CODE
,      DATE_PLACED_IN_SERVICE
,      DEPRN_METHOD_CODE
,      LIFE_IN_MONTHS
,      COST
,      ORIGINAL_COST
,      SALVAGE_VALUE
,      PRORATE_CONVENTION_CODE
,      DEPRECIATE_FLAG
,      ITC_AMOUNT_ID
,      BASIC_RATE
,      ADJUSTED_RATE
,      BONUS_RULE
,      CEILING_NAME
,      FULLY_RSVD_REVALS_COUNTER
,      PERIOD_COUNTER_FULLY_RESERVED
,      PRODUCTION_CAPACITY
,      REVAL_AMORTIZATION_BASIS
,      REVAL_CEILING
,      UNREVALUED_COST
,      ALLOWED_DEPRN_LIMIT
,      ALLOWED_DEPRN_LIMIT_AMOUNT
,      SHORT_FISCAL_YEAR_FLAG
,      CONVERSION_DATE
,      ORIGINAL_DEPRN_START_DATE
,      GROUP_ASSET_ID
,      DEPRN_LIMIT_TYPE
,      EXTENDED_DEPRN_FLAG
,      EXTENDED_DEPRECIATION_PERIOD
,      TRANSACTION_NAME
,      AMORTIZATION_START_DATE
,      DEPRN_RESERVE
,      YTD_DEPRN
,      REVAL_RESERVE
,      YTD_REVAL_DEPRN_EXPENSE
,      PERIOD_NAME
,      IMPAIRMENT_RESERVE
FROM APPS.FA_EXTENDED_DEPRN_V;

Dependencies

[top of page]

APPS.FA_EXTENDED_DEPRN_V references the following:

APPS: FA_ADDITIONS_B; FA_ADDITIONS_TL; FA_ADJUSTMENTS; FA_BOOKS; FA_DEPRN_PERIODS; FA_DEPRN_SUMMARY; FA_TRANSACTION_HEADERS

APPS.FA_EXTENDED_DEPRN_V is not referenced by any database object