View: OKX_ASST_DEP_METHODS_V

Product:	OKX - Contracts Integration
Description:	This view stores information about asset depreciation methods.
Implementation/DBA Data:	APPS.OKX_ASST_DEP_METHODS_V

View Text

SELECT METHOD_ID ID1
, '#' ID2
, METHOD_CODE||'
, '||TO_CHAR(LIFE_IN_MONTHS) NAME
, NAME DESCRIPTION
, METHOD_CODE METHOD_CODE
, LIFE_IN_MONTHS LIFE_IN_MONTHS
, DEPRECIATE_LASTYEAR_FLAG DEPRECIATE_LASTYEAR_FLAG
, STL_METHOD_FLAG STL_METHOD_FLAG
, RATE_SOURCE_RULE RATE_SOURCE_RULE
, DEPRN_BASIS_RULE DEPRN_BASIS_RULE
, PRORATE_PERIODS_PER_YEAR PRORATE_PERIODS_PER_YEAR
, EXCLUDE_SALVAGE_VALUE_FLAG EXCLUDE_SALVAGE_VALUE_FLAG
, DEPRN_BASIS_FORMULA DEPRN_BASIS_FORMULA
, SYSDATE START_DATE_ACTIVE
, SYSDATE+1 END_DATE_ACTIVE
, 'A' STATUS
, NULL PRIMARY_UOM_CODE
FROM FA_METHODS

Columns