JG Statutory Asset Cost/Reserve Detail - draft

Description
Categories: BI Publisher
Application: Regional Localizations
Source: Statutory Asset Cost/Reserve Detail Report (XML) - Not Supported: Reserved For Future Use
Short Name: JGZZFAAD_XML
DB package: JG_JGZZFAAD_XMLP_PKG
select
	i.asset_number, 
	i.company,
	substr(i.cost_account, 1, :P_PRECISION * :P_PRECISION_WIDTH) parent_account,
	substr(i.cost_account, 1, :P_PRECISION * :P_PRECISION_WIDTH) parent_acct,
	i.account,
	i.account_description,
	i.cost_account,
	i.date_placed_in_service, 
 	round(i.stl_depreciation_rate, 2) stl_depreciation_rate,
	i.concat_vendor_name vendor_name,
	i.concat_invoice_number invoice_number,
	i.concat_location location,
	i.concat_retirement_type retirement_type,
	nvl(sum(i.cost_begin_balance), 0) cost_begin_balance,
	nvl(sum(i.begin_balance), 0) begin_balance,
	nvl(sum(&lp_dynamic_col), 0) additions,
	nvl(sum(i.revaluations), 0) revaluations,
	nvl(sum(i.retirements), 0) * -1 retirements,
	nvl(sum(i.reclasses), 0) reclasses,
	nvl(sum(i.adjustments), 0) adjustments,
	nvl(sum(i.end_balance), 0) end_balance, 
	JG_JGZZFAAD_XMLP_PKG.cf_pareant_acct_descrformula(substr(i.cost_account, 1, :P_PRECISION * :P_PRECISION_WIDTH)) CF_parent_acct_descr, 
--	JG_JGZZFAAD_XMLP_PKG.cf_begin_balanceformula(:cs_begin_balance_rtot, nvl(sum(i.begin_balance), 0)) cf_begin_balance_cf, 
--	JG_JGZZFAAD_XMLP_PKG.cf_additions_cfformula(:cs_additions_rtot, nvl(sum(i.additions), 0)) cf_additions_cf, 
--	JG_JGZZF