FA Form 4562 - Depreciation and Amortization - draft

Description
Categories: BI Publisher
Application: Assets
Source: Form 4562 - Depreciation and Amortization Report (XML) - Not Supported: Reserved For Future Use
Short Name: FAS770_XML
DB package: FA_FAS771_XMLP_PKG
select       fnd_flex_xml_publisher_apis.process_kff_combination_1('acct_flex_bal_seg', 'SQLGL', 'GL#', dhcc.CHART_OF_ACCOUNTS_ID, NULL, dhcc.CODE_COMBINATION_ID, 'GL_BALANCING', 'Y', 'VALUE')    	                                          	company_code,
	decode(fy.fiscal_year, :P_fiscal_year,
			to_char(fy.fiscal_year),:PREVIOUS_FISCAL_YEAR)	fiscal_year_added,
	BK.deprn_method_code				deprn_method,
	&CAT_FLEX_ALL_SEG 				category,
	AD.asset_number || ' - ' || AD.description			asset_number,
	AD.ASSET_ID					ASSET_ID,
	sum(dd.cost)					cost,
	bk.life_in_months					life_in_months,
	bk.adjusted_rate					adjusted_rate,
	ds.bonus_rate					bonus_rate,
	bk.production_capacity				production,
	BK.prorate_convention_code				prorate_convention,
 	sum(dd.ytd_deprn)					ytd_deprn,
                 decode(  instr(bk.deprn_method_code, '30B'), 0, 
                               decode ( instr(bk.deprn_method_code, '50B'), 0, 0,
                                              decode(fy.fiscal_year, :P_FISCAL_YEAR, (bk.recoverable_cost * .5 ) , 0) )              
                             , decode(fy.fiscal_year, :P_FISCAL_YEAR, (bk.recoverable_cost * .3 ) , 0) 
                             )  special_deprn, 
	fnd_flex_xml_publisher_apis.process_kff_combination_1('d_company_code', 'SQLGL', 'GL#', dhcc.CHART_OF_ACCOUNTS_ID, NULL, dhcc.CODE_COMBINATION_ID, 'GL_BALANCING', 'Y', 'VALUE') D_COMPANY_CODE, 
	fnd_flex_xml_publisher_apis.process_kff_combination_1('c_cat_flex', 'OFA', 'CAT#', 101, NULL, cat.CATEGORY_ID, 'ALL', 'Y', 'VALUE') C_CAT_FLEX