View: OKL_AM_ASST_DEP_METHODS_UV

Product:	OKL - Lease and Finance Management
Description:	Asset Depreciation Methods
Implementation/DBA Data:	APPS.OKL_AM_ASST_DEP_METHODS_UV

View Text

SELECT FAMET.METHOD_ID ID1
, '#' ID2
, FAMET.METHOD_CODE||'
, '||TO_CHAR(FAMET.LIFE_IN_MONTHS) NAME
, FAMET.NAME DESCRIPTION
, FAMET.METHOD_CODE METHOD_CODE
, FAMET.LIFE_IN_MONTHS LIFE_IN_MONTHS
, FAMET.DEPRECIATE_LASTYEAR_FLAG DEPRECIATE_LASTYEAR_FLAG
, FAMET.STL_METHOD_FLAG STL_METHOD_FLAG
, FAMET.RATE_SOURCE_RULE RATE_SOURCE_RULE
, FAMET.DEPRN_BASIS_RULE DEPRN_BASIS_RULE
, FAMET.PRORATE_PERIODS_PER_YEAR PRORATE_PERIODS_PER_YEAR
, FAMET.EXCLUDE_SALVAGE_VALUE_FLAG EXCLUDE_SALVAGE_VALUE_FLAG
, FAMET.DEPRN_BASIS_FORMULA DEPRN_BASIS_FORMULA
, SYSDATE START_DATE_ACTIVE
, SYSDATE+1 END_DATE_ACTIVE
, 'A' STATUS
, NULL PRIMARY_UOM_CODE
, ( FLAT.ADJUSTED_RATE *100 )DEPRN_RATE
FROM FA_METHODS FAMET
, FA_FLAT_RATES FLAT
WHERE FAMET.METHOD_ID = FLAT.METHOD_ID (+)
AND NVL(FLAT.ADJUSTING_RATE
, 0) = 0

Columns