FA Depreciation Rate Listing - draft

select 	methods.method_code		method_code,
	methods.name			name,
	methods.life_in_months 		life,
	methods.stl_method_flag		stl_flag,
	methods.depreciate_lastyear_flag	flag,
	rates.year				year,
	rates.period_placed_in_service	period_placed_in_service,
	rates.rate				rate, 
	FA_FAS911_XMLP_PKG.d_lifeformula(methods.life_in_months) D_LIFE
from
	fa_methods	methods,
	fa_rates		rates
where
	methods.method_id = rates.method_id	and
	methods.method_code = nvl(:p_method_code, methods.method_code)	and
	methods.life_in_months = nvl(:p_life_in_months, methods.life_in_months)
order by 
	methods.method_code,
	methods.life_in_months,
	rates.year,
	rates.period_placed_in_service