[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

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_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