Reports2017-11-18T12:27:27+00:00

FA Depreciation Rate Listing - draft

Description
Categories: BI Publisher
Application: Assets
Source: Depreciation Rate Listing (XML) - Not Supported: Reserved For Future Use
Short Name: FAS911_XML
DB package: FA_FAS911_XMLP_PKG
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
Parameter Name SQL text Validation
Life
 
LOV Oracle
Method Code
 
LOV Oracle
By continuing to use the site, you agree to the use of cookies. Accept