View: OKL_ASSET_DEPRN_METHODS_UV

Product:	OKL - Lease and Finance Management
Description:	User interface view for FA depreciation methods
Implementation/DBA Data:	APPS.OKL_ASSET_DEPRN_METHODS_UV

View Text

SELECT FM.METHOD_ID METHOD_ID
, FM.METHOD_CODE METHOD_CODE
, NVL(TO_CHAR(FM.LIFE_IN_MONTHS)
, '') LIFE_IN_MONTHS
, NVL(TO_CHAR(FFR.BASIC_RATE*100)
, '') BASIC_RATE
, NVL(TO_CHAR(FFR.ADJUSTING_RATE*100)
, '') ADJUSTING_RATE
, NVL(TO_CHAR(FFR.ADJUSTED_RATE*100)
, '') ADJUSTED_RATE
FROM FA_METHODS FM
, FA_FLAT_RATES FFR
WHERE FFR.METHOD_ID(+) = FM.METHOD_ID
AND NVL(FFR.ADJUSTING_RATE
, 0) = 0 ORDER BY FM.METHOD_CODE
, NVL(FM.LIFE_IN_MONTHS
, 0)
, NVL(FFR.ADJUSTED_RATE
, 0)

Columns