JG Statutory Asset Cost/Reserve Detail Report- Not Supported: Reserved For Future Use

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_JGZZFAAD_XMLP_PKG.cf_retirements_cfformula(:cs_retirements_rtot, nvl(sum(i.retirements), 0) * -1) cf_retirements_cf, 
--	JG_JGZZFAAD_XMLP_PKG.cf_revaluations_cfformula(:cs_revaluations_rtot, nvl(sum(i.revaluations), 0)) cf_revaluations_cf, 
--	JG_JGZZFAAD_XMLP_PKG.cf_reclasses_cfformula(:cs_reclasses_rtot, nvl(sum(i.reclasses), 0)) cf_reclasses_cf, 
--	JG_JGZZFAAD_XMLP_PKG.cf_adjustments_cfformula(:cs_adjustments_rtot, nvl(sum(i.adjustments), 0)) cf_adjustments_cf, 
--	JG_JGZZFAAD_XMLP_PKG.cf_cost_begin_balance_cfformul(:cs_cost_begin_balance_rtot, nvl(sum(i.cost_begin_balance), 0)) cf_cost_begin_balance_cf, 
--	JG_JGZZFAAD_XMLP_PKG.cf_end_balance_cfformula(:cs_end_balance_rtot, nvl(sum(i.end_balance), 0)) cf_end_balance_cf, 
	JG_JGZZFAAD_XMLP_PKG.cf_page_parent_acct_descrformu(substr(i.cost_account, 1, :P_PRECISION * :P_PRECISION_WIDTH), substr(i.cost_account, 1, :P_PRECISION * :P_PRECISION_WIDTH)) CF_page_parent_acct_descr 
--	JG_JGZZFAAD_XMLP_PKG.cf_cost_begin_balance_reptotfo(:CS_cost_begin_balance_reptot, nvl(sum(i.cost_begin_balance), 0)) cf_cost_begin_balance_reptot, 
--	JG_JGZZFAAD_XMLP_PKG.cf_begin_balance_reptotformula(:CS_begin_bal_reptot, nvl(sum(i.begin_balance), 0)) cf_begin_balance_reptot, 
--	JG_JGZZFAAD_XMLP_PKG.cf_additions_reptotformula(:CS_additions_reptot, nvl(sum(i.additions), 0)) cf_additions_reptot, 
--	JG_JGZZFAAD_XMLP_PKG.cf_adjustments_reptotformula(:CS_adjustments_reptot, nvl(sum(i.adjustments), 0)) cf_adjustments_reptot, 
--	JG_JGZZFAAD_XMLP_PKG.cf_reclases_reptotformula(:CS_reclasses_reptot, nvl(sum(i.reclasses), 0)) cf_reclasses_reptot, 
--	JG_JGZZFAAD_XMLP_PKG.cf_retirements_reptotformula(:CS_retirements_reptot, nvl(sum(i.retirements), 0) * -1) cf_retirements_reptot, 
--	JG_JGZZFAAD_XMLP_PKG.cf_revaluations_reptotformula(:CS_revaluations_reptot, nvl(sum(i.revaluations), 0)) cf_revaluations_reptot, 
--	JG_JGZZFAAD_XMLP_PKG.cf_end_balance_reptotformula(:CS_end_balance_reptot, nvl(sum(i.end_balance), 0)) cf_end_balance_reptot
from
	fa_balances_rep_itf i
where
   	i.request_id = :P_CONC_REQUEST_ID and
	i.company = :P_BALANCING_SEGMENT
group by
	i.asset_number, 
	i.company,
	substr(i.cost_account, 1, :P_PRECISION * :P_PRECISION_WIDTH),
	substr(i.cost_account, 1, :P_PRECISION * :P_PRECISION_WIDTH),
	i.account,
	i.account_description,
	i.cost_account,
	i.date_placed_in_service, 
 	round(i.stl_depreciation_rate, 2),
	i.concat_vendor_name,
	i.concat_invoice_number,
	i.concat_location,
	i.concat_retirement_type
order by
	i.cost_account,
	i.asset_number