FA Leased Assets - draft

Description
Categories: BI Publisher
Application: Assets
Source: Leased Assets Report (XML) - Not Supported: Reserved For Future Use
Short Name: FAS930_XML
DB package: FA_FAS930_XMLP_PKG
SELECT 	&Acct_Flex_Bal_Seg			comp_code,
	&Cat_Flex_All_Seg				category,
	le.lease_number,
	ad.asset_number || ' - ' || ad.description		asset_number_desc,
	books.date_placed_in_service,
	sum(decode (dd.deprn_source_code,
		'D', dd.cost,
		dd.addition_cost_to_clear))		cost,
	sum(dd.deprn_reserve)			reserve,
	sum(dd.cost) - sum(dd.deprn_reserve)		nbv,
	--added
	fnd_flex_xml_publisher_apis.process_kff_combination_1('comp_code_dsp', 'SQLGL', 'GL#', dhcc.CHART_OF_ACCOUNTS_ID, NULL, dhcc